Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/svpfahad/RES200 --skill xlsx-svpfahad
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/svpfahad/RES200/tree/main/claude-scientific-writer-main/.claude/skills/document-skills/xlsx Command: npx skills add https://github.com/svpfahad/RES200 --skill xlsx-svpfahad
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formulas as strings, such as sheet['B10'] = '=SUM(B2:B9)', then save the workbook. Always use Excel formulas instead of hardcoding Python-calculated values so the spreadsheet recalculates when source data changes.
Run the included recalc.py script with python recalc.py output.xlsx. It uses LibreOffice headless to recalculate all formulas and returns JSON reporting any errors like #REF! or #DIV/0! with their exact cell locations.
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 edits to existing files while preserving their structure.
openpyxl stores formulas as strings without evaluating them, so values are missing until recalculated. Run recalc.py, which configures a LibreOffice macro to recalculate and save the workbook, or open the file in Excel or LibreOffice.
Saving a workbook loaded with data_only=True permanently replaces all formulas with their cached values, destroying the formulas. Only use data_only=True for reading calculated values, never for files you intend to modify and save.
nicepkgTransform raw data from CSVs, spreadsheets, databases, and APIs into executive reports.
Cloud-Byte-ConsultingDesign presentation narratives and validate finished decks against evidence and brand rules.
nahisahoGenerate publication-quality scientific schematics as SVG, Mermaid, or TikZ vector diagrams.
404kidwizDesign interactive dashboards and optimize SQL queries for business intelligence.
