All Questions
Tagged with excel python-3.x
22 questions
2
votes
1
answer
240
views
Python using generators with Excelwriter - Performance
I'm looking to understand if my code has an obvious blockage or performance pain point that will cause it to operate slower or use more memory than it should.
The current Excelfile i am processing ...
- 131
1
vote
1
answer
554
views
Python script to read an XML file and write some information to an Excel file
I'm getting an XML file from an application, want to extract some information from that file and write it to an Excel file. The XML file contains data about vacations. I need data from the last month ...
- 113
3
votes
1
answer
164
views
Update an Excel master workbook with values from new workbook
I have a master .xlsx file on which other spreadsheets depend. Each week, I export a new .xlsx file (from MRP) that may or may not be the same as the master. The columns are always identical. Rows may ...
- 33
3
votes
1
answer
103
views
Python data entry into excel based on equality check with dataframe
My objective is to enter/type in values into Excel cells if the column names and indices match between Excel and dataframe.
So, my code does the below
Gets the ID values from the dataframe
for each ...
- 247
2
votes
0
answers
314
views
Optimizing the openpyxl program
Purpose of the code:
Let's say I have 3 excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every ...
- 61
4
votes
0
answers
94
views
Combine filtered or hidden cells
Purpose of the code:
I have 3 Excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every excel files.
I ...
- 61
2
votes
1
answer
1k
views
Populate list with Excel range and keep formatting
I have written a Python programme that takes data from Excel sheets and adds this data to new .DAT files.
I use win32com.client because the Excel sheets will ...
- 131
12
votes
1
answer
230
views
Not so Excellent Knight's Tour
Note: This is part of a set of demo applications I'm writing for colleagues to show we're not limited to VBA when dealing with Excel. Considering our IT challenges (no admin on-site & no local-...
Mast♦
- 13.8k
6
votes
1
answer
121
views
Parsing Long Excel Report Files for Predefined Results
I work as an IT intern in a multinational, and I was given a tedious task of combing through a 2500+ long multi-column Excel report file in search of inactive servers.
Here's a sample row from that ...
- 1,378
5
votes
1
answer
308
views
Migrating data from multiple spreadsheets to multiple text files
This is like the reverse functionality of Text file to spreadsheet.
One or multiple .xlsx files in the path of the script get opened and the content is split into ...
- 3,152
5
votes
1
answer
161
views
Excel for travel expenses
Every month I need to make an Excel sheet with travel expenses. Since this is a tedious task, I decided to make a little Python script to do this work for me.
Everything works correctly, but any ...
- 11.8k
1
vote
1
answer
1k
views
Read unstructured Excel payslip and export to structured Excel table
I've not used this site before, I would like to get opinions on the code I've completed for my first 'program' in Python. I would like to understand how 'good' it is and where it can be improved, ...
- 13
2
votes
0
answers
1k
views
Regex search to Excel
I made this to track my variable changes while I experiment in Python. I tend to use the same variable names and fit different values to them so it's nice to be able to see what I've tried, especially ...
- 21
2
votes
0
answers
647
views
Create and email an Excel report of data retrieved from SQL
This is my first Python (3.6) script which I would appreciate some critique of.
I am generating a daily alarm report. The data is gathered from an SQL Server database, presented in an xlsx file ...
- 21
4
votes
1
answer
6k
views
Duplicating Excel-workbook, and transferring data
This is a follow up to the simpler question here.
I have hundreds of files looking something like this:
These files have names such as:
...
- 2,077