Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/Syedyasir001/RVULibPass --skill xlsx-syedyasir001
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Syedyasir001/RVULibPass/tree/main/.agent/skills/library/xlsx Command: npx skills add https://github.com/Syedyasir001/RVULibPass --skill xlsx-syedyasir001
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 scripts/recalc.py afterward to compute values with LibreOffice 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 workbooks that must preserve 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 scripts/recalc.py to populate computed values before reading results.
Run python scripts/recalc.py on the workbook. It recalculates all formulas with LibreOffice, scans every cell, and returns JSON listing each error type with counts and exact cell locations like Sheet1!B5.
Yes, if you load a workbook with data_only=True and then save it, all formulas are permanently replaced by their cached values. Only use data_only=True for read-only inspection, never for files you intend to save.
WizarckCreate, read, edit, and convert xlsx, xlsm, csv, and tsv spreadsheet files.
Duzhenyang111Validate Excel workbooks for formula errors and structural flaws using Python.
jonnytacos8Validate financial figures and cross-check totals against rag_search context.
cellarwoodRead cell values from Google Sheets via the gws CLI.
