Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
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. ...
Lucas Apolinário's user avatar
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 ...
Ben A's user avatar
  • 10.7k
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 ...
Sandro4912's user avatar
  • 3,152
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 ...
Matt's user avatar
  • 183
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 ...
soren thomsen's user avatar
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. ...
J.Doe's user avatar
  • 33
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 ...
Christian's user avatar
  • 161
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 ...
Denik Gorbunov's user avatar
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 ...
Errorum's user avatar
  • 181
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 ...
Zaplatki's user avatar
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 ...
Cyclops's user avatar
  • 129
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 ...
Abdul Shiyas's user avatar
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 ...
user avatar
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): ...
Matt's user avatar
  • 215
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. ...
ashleh's user avatar
  • 197

15 30 50 per page