Difference between revisions of "Python Excel Related"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
=[[Conditional Search Multiple Excel Files]]= | =[[Conditional Search Multiple Excel Files]]= | ||
* conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true. | * 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]]= | =[[How to Split an Excel File into multiple sheets or multiple files]]= | ||
* Filter data and put results in either multiple sheets or multiple files | * Filter data and put results in either multiple sheets or multiple files | ||
=[[Combine multiple excel files into One]]= | =[[Combine multiple excel files into One]]= | ||
* Go through a dir and combine multiple excel files | * Go through a dir and combine multiple excel files | ||
Revision as of 15:52, 3 September 2020
Clean up excel data
Merge Excel Spreadsheet with same columns
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