Automate Excel Sheet Splitting using python

Замовник: AI | Опубліковано: 12.02.2026

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.