Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/pchemguy/AISandbox --skill xlsx-pchemguy
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/pchemguy/AISandbox/tree/main/docs/AgentSkills/anthropics/skills/skills/xlsx Command: npx skills add https://github.com/pchemguy/AISandbox --skill xlsx-pchemguy
High-intent search queries and answers about installing and using this skill.
Use openpyxl to create a workbook and assign formula strings like '=SUM(B2:B9)' directly to cells, then save with wb.save(). Always run recalc.py afterward so LibreOffice calculates the formula values, since openpyxl stores formulas without evaluating them.
Use pandas for data analysis, bulk operations, and simple exports via read_excel and to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or editing existing files while preserving their structure.
Run 'python recalc.py output.xlsx' from the command line. The script configures a LibreOffice macro on first run, recalculates all formulas in all sheets, and returns JSON reporting any Excel errors with their exact cell locations.
#REF! occurs when formulas point to invalid cell references, and #DIV/0! happens when dividing by zero or empty cells. Run recalc.py to get a JSON error summary listing each error type with up to 20 cell locations, then fix the references and recalculate again.
Yes, loading with load_workbook() preserves formulas and formatting by default. However, opening with data_only=True and saving replaces formulas with their cached values permanently, so only use data_only for reading calculated values.
nicepkgTransform raw data from CSVs, spreadsheets, databases, and APIs into executive reports.
2nth-aiAutomate financial KPI extraction, calculation, and reporting from ERP and CRM systems.
MuzeWinterValidate analysis claims, calculations, visuals, and conclusions before stakeholder sharing.
CraftOS-devManage Google Sheets data, formatting, and sheets via the API with Node.js.
