All Questions
21 questions
0
votes
1
answer
2k
views
Excel table filling with EPPlus
I am making a tool to read 3 input files in CSV and then filling an XLSX file with the information from the CSV. I want to know if I am repeating myself and if I can make it better and faster. ...
3
votes
2
answers
143
views
Excel To CSV Converter Ch 9 ATBS
I am learning more about python using the book "Automate The Boring Stuff". The problem I completed was "Excel To CSV Converter". I want to kick bad habits to the curb, and make sure I'm learning the ...
3
votes
1
answer
77
views
Excel to CSV converter
To check out the cssv module i wrote a small programm which takes all xlsx files in a folder and converts them into csv files.
Let me know what you would improve on this program.
xlsx_tp_csv
...
8
votes
3
answers
6k
views
Parsing Excel file into CSV file
EDIT: Thanks everyone for your answers, this is moving quickly now and it's always essential to get better with design and best practice!
I am loading in an excel file to a dataset using ...
1
vote
1
answer
6k
views
Convert Excel files to CSV
I wrote the following script to run through several excel files and format them before saving as a CSV for upload to a Quickbase app I'm creating. Each excel file is roughly 100k lines and the code ...
3
votes
1
answer
116
views
Fetch and append player statistics to an Excel spreadsheet
I am a new programmer in python, and I need a bit of help to structure my code.
...
6
votes
1
answer
869
views
Converting multiple Excel files in multiple folders into CSV
The whole project is quite large, involving parsing the CSV files, validating them, exporting them to a database and such, but my code in question involves a subset of the project: converting multiple ...
1
vote
2
answers
81
views
Generate Orders from Matrix and save as CSV
I had a task to create a VBA macros which will take a matrix data set with products in rows and persons as a columns (on intersection we have an ordered qty for each material for each person) and ...
5
votes
1
answer
993
views
Powershell Interaction with Excel (Highlighting Cells)
I'm using Powershell to compare two, large csv files and output the rows which don't match. Once the two output files are made (one for the differences on each), I bring them up on Excel. Now I want ...
7
votes
2
answers
266
views
Reusable VBA macro to prevent Excel from destroying the data (+ backup capacity)
My goal is to prepare the Excel file (see the download link at the end) I would share with my non-technical colleagues, so that they enter some data into it and then I was able to automatically ...
6
votes
2
answers
162
views
Comparing vehicle crash data the previous year
I have created an automated macro which takes vehicle crash data from a .csv file and automatically creates a pivot table and charts and compares it to the previous year. The code is approximately ...
4
votes
2
answers
6k
views
Converting CSV files to Excel workbooks
My converter converts all CSV files in the subfolders of folders 1, 2 & 3 into Excel workbooks. As of now, I am converting using codes for each folders. I previously tried to combine those into ...
7
votes
3
answers
979
views
Extracting data from CSV file on the internet
This is my code I made that extracts data from a .csv file stored on the web. My sheet called 'New Data' stores this data for 2 days. I store 2 days worth of data so that when I run it next time, it ...
7
votes
1
answer
1k
views
Import Excel, unpivot data, output tab-delimited for SQL Import
I have a client GL file (Excel) that needs to be regularly imported to SQL Server (as tab-delimited txt).
Sample (simplified):
...
4
votes
1
answer
13k
views
Split excel file with multiple sheets, manipulate the data and create final out file
I have an excel file with 20+ separate sheets containing tables of data. My script iterates through each sheet, manipulates the data into the format I want it and then saves it to a final output file. ...