Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and pandas.
npx skills add https://github.com/wolfmanstout/agent-skills --skill xlsx-wolfmanstout
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/wolfmanstout/agent-skills/tree/main/subtrees/skills/skills/xlsx Command: npx skills add https://github.com/wolfmanstout/agent-skills --skill xlsx-wolfmanstout
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. After saving, run the recalc.py script with LibreOffice to calculate formula 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 but never evaluates them, so cells lack computed values until opened in a spreadsheet application. Run the recalc.py script, which uses LibreOffice headless mode to recalculate all formulas and save the results.
Run python scripts/recalc.py on the workbook. It returns JSON listing every error type with exact sheet and cell locations, plus a total formula count, so you can fix each issue and recalculate again.
Load the workbook with load_workbook('file.xlsx', data_only=True) to read cached calculated values. Never save from a data_only session, because doing so permanently replaces all formulas with static values.
brainbrewlabsProfile and clean tabular datasets, then write a cleaned file with a change report.
tDalileAutomate milestone completion, audit verification, artifact archival, and tracker status updates.
Cloud-Byte-ConsultingMap slide claims to workbook tabs, cells, sources, and review status.
cellarwoodRead cell values from Google Sheets via the gws CLI.
