Automate Excel Sheet Splitting using python
Budget: $30 – $250 CAD
I keep a single master report in Excel that contains every client’s figures. I need a small, repeatable Python script that will:
• read the master workbook,
• isolate the Total Cost column and perform specific calculations,
• split the rows so each client gets only their own data,
• save every subset as an individual Microsoft Excel 97-2003 (.xls) file.
With Data Visualization for Analysis
Inside every generated file I still want the same conditional formatting and any existing cell-level number/date formats to remain intact, so the look and feel matches the master.
Please write clean, well-commented code—pandas plus xlwt/xlrd or any other library that supports the older .xls format is fine—as long as it runs from the command line on Windows. Include a short README and one sample output file so I can confirm everything before marking it done.
• read the master workbook,
• isolate the Total Cost column and perform specific calculations,
• split the rows so each client gets only their own data,
• save every subset as an individual Microsoft Excel 97-2003 (.xls) file.
With Data Visualization for Analysis
Inside every generated file I still want the same conditional formatting and any existing cell-level number/date formats to remain intact, so the look and feel matches the master.
Please write clean, well-commented code—pandas plus xlwt/xlrd or any other library that supports the older .xls format is fine—as long as it runs from the command line on Windows. Include a short README and one sample output file so I can confirm everything before marking it done.
Related categories:
Python
Data Processing
Excel
Software Architecture
Excel VBA
Data Visualization
Data Analysis
Pandas