Excel Automation Program

Automating Excel spreadsheets to process thousands of spreadsheets in under a second is very useful especially in today's era of big data. This is a simple implementation of automation using Python, particularly of adding discounts and charts for a price column in multiple Excel files and sheets, in parallel. This program also includes a function for generating a test Excel spreadsheet, whose function call in the 'main' section of the code can be commented in and out as needed.

*Comment the 'generate_excel()' or 'parallel_process()' calls in 'main', and update the filenames, sheet_names, discount, and output_dir variable values as needed.