Python Excel Related

Conditional Search Multiple Excel Files

• conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.
• Then combine the results into 1 excel file

How to Split an Excel File into multiple sheets or multiple files

• Filter data and put results in either multiple sheets or multiple files

Combine multiple excel files into One

• Go through a dir and combine multiple excel files