Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/MWest2020/skill-forge --skill xlsx-mwest2020
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/MWest2020/skill-forge/tree/main/skills/xlsx Command: npx skills add https://github.com/MWest2020/skill-forge --skill xlsx-mwest2020
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings like '=SUM(B2:B9)' directly into cells, then save the workbook. Formulas are stored but not evaluated, so run a recalculation step with LibreOffice to compute values before delivery.
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 workbooks while preserving structure.
openpyxl stores formulas as strings without calculating them. Recalculate the file with LibreOffice (for example via scripts/recalc.py) to compute values, then verify with load_workbook using data_only=True.
Run the recalc.py script, which recalculates all formulas and returns JSON listing each error type with cell locations like Sheet1!B5. Fix invalid references and unguarded divisions, then recalculate again until zero errors remain.
Yes, if you save after loading with data_only=True, formulas are permanently replaced by their cached values. Only use data_only=True for reading calculated values, and keep a separate load without it for editing.
microclawInspect, filter, aggregate, and clean CSV and TSV data with Python.
davpatel605-beepGenerate PowerPoint presentations from financial models with python-pptx.
HKU-MMLabCreate and style Word, Excel, and PowerPoint documents using Python libraries.
cellarwoodRead cell values from Google Sheets via the gws CLI.
