Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and pandas.
npx skills add https://github.com/chhpt/skills --skill xlsx-chhpt
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/chhpt/skills/tree/main/skills/xlsx Command: npx skills add https://github.com/chhpt/skills --skill xlsx-chhpt
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 the recalc.py script with LibreOffice to compute values and verify no errors exist.
Use pandas for data analysis, bulk operations, and simple exports with pd.read_excel and df.to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or editing existing workbooks while preserving structure.
openpyxl stores formulas as strings without evaluating them. Recalculate with LibreOffice using the recalc.py script, which runs a macro to compute all formulas and scans every cell for errors like #REF! and #DIV/0!.
Run recalc.py to get a JSON report listing each error type with exact cell locations. Fix invalid cell references for #REF! errors and add denominator checks for #DIV/0!, then recalculate again until the status is success.
Yes, load the workbook with data_only=True to read cached calculated values. However, never save a workbook opened this way, because formulas will be permanently replaced with their static values.
OwnLabAIReads and writes spreadsheet data, transforms formats, and exports to XLSX/CSV/TSV.
HKU-MMLabCreate and style Word, Excel, and PowerPoint documents using Python libraries.
openaiValidate analysis methodology, calculations, visuals, and conclusions before stakeholder sharing.
cellarwoodRead cell values from Google Sheets via the gws CLI.
