Create, edit, and analyze Excel spreadsheets with formula recalculation.
npx skills add https://github.com/jsolarz/doc-toolkit --skill xlsx-jsolarz
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/jsolarz/doc-toolkit/tree/main/.skills/xlsx Command: npx skills add https://github.com/jsolarz/doc-toolkit --skill xlsx-jsolarz
This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing Excel spreadsheets, ensuring formulas calculate correctly and formatting follows industry best practices.
Use the xlsx skill to create a formatted sales forecast spreadsheet with dynamic revenue growth formulas, then recalculate all values to confirm there are no formula errors.
High-intent search queries and answers about installing and using this skill.
Automating Excel spreadsheet creation while preserving formulas involves using openpyxl to edit .xlsx files programmatically, maintaining existing formatting and template conventions while adding custom formulas and data visualization.
Recalculating formulas and detecting Excel errors like #REF! or #DIV/0! requires running a recalc.py script that uses LibreOffice to recalculate values and identify common spreadsheet calculation issues.
Yes, you can use pandas for data analysis and export results to Excel. This workflow analyzes tabular datasets to generate insights, then writes the processed data and visualizations directly into .xlsx format.
Openpyxl supports building financial models with dynamic growth assumptions by setting up multi-year projection formulas, applying financial modeling standards like color coding, and validating formula accuracy.
To modify existing .xlsm and .csv files without losing formatting, use an automated spreadsheet manipulation tool that preserves template conventions while editing data and recalculating formulas.
Spreadsheet formulas show errors after editing tabular datasets because manual modifications often break cell references. Using a formula validation script recalculates values and detects issues like #REF! automatically.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
korallisCreate, parse, and manipulate Excel spreadsheets using xlsx, exceljs, or SheetJS.
cpalumboCreate and edit Excel spreadsheets with formulas and formatting using pandas and openpyxl.
liutao96Automate Excel data handling and formula-driven models with openpyxl, pandas, and LibreOffice recalc.
