Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/UlaYuga/promo-preflight --skill xlsx-ulayuga
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/UlaYuga/promo-preflight/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/UlaYuga/promo-preflight --skill xlsx-ulayuga
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 by openpyxl, so recalculate them with LibreOffice using the recalc.py script to produce computed values.
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 that must preserve styles.
openpyxl stores formulas as strings without evaluating them, so cells appear empty when read with data_only=True. Recalculate the file with LibreOffice through scripts/recalc.py, which computes all formulas and reports any errors as JSON.
Run scripts/recalc.py on the workbook; it scans every cell and returns JSON listing each error type with exact sheet and cell locations. Fix invalid references for #REF! and guard denominators against zero for #DIV/0!, then recalculate again.
Yes, load the file with load_workbook and modify cells in place; existing styles and formulas are preserved. Avoid saving a workbook opened with data_only=True, since that permanently replaces formulas with their cached values.
yuyalun-allenEdit spreadsheet files to clean tabular data and verify Excel formulas.
nexu-ioGenerate single-file HTML presentation decks using a Y2K-inspired chrome visual system.
jonnytacos8Validate financial figures and cross-check totals against rag_search context.
73aiExtract Google Sheets data and generate formatted Google Docs reports.
