Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/SESELOVSKYDarian/Vase --skill xlsx-seselovskydarian
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/SESELOVSKYDarian/Vase/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/SESELOVSKYDarian/Vase --skill xlsx-seselovskydarian
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. Because openpyxl stores formulas without computing them, run scripts/recalc.py afterward so LibreOffice calculates and caches the values.
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 edits to existing workbooks while preserving their structure.
openpyxl writes formulas as strings but never evaluates them, so cells appear empty until opened in Excel. Run scripts/recalc.py, which drives LibreOffice headlessly to recalculate all formulas and store the computed values in the file.
Run scripts/recalc.py on the workbook; it returns JSON listing each error type with exact sheet and cell locations. Fix invalid references for #REF!, guard denominators for #DIV/0!, then recalculate again until the error count reaches zero.
Yes, load the file with data_only=True to read cached calculated values instead of formula strings. Never save a workbook opened this way, because doing so permanently replaces all formulas with their static values.
brainbrewlabsProfile and clean tabular datasets, then write a cleaned file with a change report.
Duzhenyang111Validate Excel workbooks for formula errors and structural flaws using Python.
Cloud-Byte-ConsultingMap slide claims to workbook tabs, cells, sources, and review status.
shiro123444Edit and validate Excel workbooks through OOXML XML editing.
