This Python script automates cleaning of Excel files in bulk.
- Delete top N rows from specified sheets
- Remove shapes/images anchored in deleted rows
- Process multiple files in a folder
- Save cleaned files to a separate output folder
- Works with
.xlsxand.xlsfiles - Fully interactive sheet and row configuration
- Windows
- Python 3.x
- pywin32 package (
pip install pywin32)
python Excel_Batch_Cleaner.py