Create, edit, and analyze .xlsx, .csv, and .tsv files with pandas and openpyxl.
npx skills add https://github.com/KnoWhiz/DoWhiz --skill xlsx-knowhiz
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/KnoWhiz/DoWhiz/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/KnoWhiz/DoWhiz --skill xlsx-knowhiz
This Skill empowers users to create, edit, and analyze spreadsheet files (.xlsx, .csv, .tsv) with unparalleled ease, automating complex data manipulation, formula creation, and formatting tasks.
scripts/recalc.py to ensure zero formula errors and provides detailed error reporting.Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns 'Date', 'Product', and 'Revenue', and populate it with sample data.
High-intent search queries and answers about installing and using this skill.
To automate Excel formula creation, you use openpyxl to dynamically write formulas into cells rather than static values. This approach ensures generated spreadsheets remain updateable and react to data changes without manual recalculation.
The best way to clean messy data into a formatted spreadsheet is using pandas for data manipulation combined with openpyxl for formatting. This workflow transforms raw tabular data into professional reports suitable for analysis or presentation.
To prevent formula errors in generated xlsx files, the spreadsheet is recalculated using LibreOffice. This process validates formulas, ensures zero calculation errors, and provides detailed error diagnostics for any issues detected.
Yes, you can use pandas and openpyxl together for spreadsheet tasks by leveraging pandas for data analysis and openpyxl for formatting and formula management. This combination enables automated creation and editing of complex xlsx files.
Yes, this approach supports converting between csv, tsv, and xlsx tabular formats. It automates the creation, editing, and conversion of these spreadsheet files while preserving formulas, formatting, and data integrity across formats.
MOODMNKY-LLCCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with pandas and openpyxl.
omosb1-sysGenerate executive PPT and PDF reports from data analysis results.
loganylchenCreate, edit, analyze, and visualize .xlsx, .csv, and .tsv spreadsheets with Python.
OpenSenseNovaAutomate large-scale Excel data analysis with reading, cleaning, filtering, and visualization.