Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and pandas.
npx skills add https://github.com/changfengpro/agent-skills --skill xlsx-changfengpro
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/changfengpro/agent-skills/tree/main/skills/xlsx Command: npx skills add https://github.com/changfengpro/agent-skills --skill xlsx-changfengpro
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 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. 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!.
Yes. Loading with data_only=True reads cached values, and saving that workbook permanently replaces formulas with values. Only use data_only=True for reading, never for files you intend to save.
Run recalc.py to get a JSON report listing each error type with cell locations. Fix invalid cell references for #REF! errors and guard denominators against zero for #DIV/0! errors, then recalculate again to confirm.
LeonChaoXOpen, clean, convert, and edit tabular files with Excel formulas.
jeremydhoover-blipOrganize content audit findings into actionable stakeholder reports.
cipriantitireClean, edit, and convert spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.
googleworkspaceAppend deal status updates to a Google Sheets sales tracking spreadsheet.
