Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/danielbere1973/promoar --skill xlsx-danielbere1973
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/danielbere1973/promoar/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/danielbere1973/promoar --skill xlsx-danielbere1973
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 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, so cells appear empty when read with data_only=True. Recalculate the file with LibreOffice using the recalc.py script to compute and cache all formula values.
Run the recalc.py script on the file; it returns JSON listing each error type with exact cell locations like Sheet1!B5. Fix invalid references or add denominator checks, then recalculate again until the status is success.
Yes, load the file with openpyxl's load_workbook to preserve existing formulas and styles, then modify only the needed cells. Avoid saving with data_only=True, which permanently replaces formulas with static values.
yuyalun-allenEdit spreadsheet files to clean tabular data and verify Excel formulas.
tDalileAutomate milestone completion, audit verification, artifact archival, and tracker status updates.
BasitShafiqGenerate Excel spreadsheets with formulas, charts, and data validation using openpyxl and xlsxwriter.
cellarwoodRead cell values from Google Sheets via the gws CLI.
