Turn Excel data into clean reports, pivots, and charts.
Analyzes Excel spreadsheets, cleans and combines data, and creates formatted workbooks, pivot tables, and charts.
When to use it
Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
Give it spreadsheet files and the desired work; it analyzes the data or creates workbook and chart files in the project.
What you provide
Requires Python to run the documented analysis code.
Uses pandas as the primary package for data analysis and manipulation.
Uses openpyxl for Excel file creation and formatting.
Enables reading older .xls files.
No additional actions listed.