Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and pandas.
npx skills add https://github.com/adrianasiam19/ATLAS --skill xlsx-adrianasiam19
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/adrianasiam19/ATLAS/tree/main/.agent/skills/xlsx Command: npx skills add https://github.com/adrianasiam19/ATLAS --skill xlsx-adrianasiam19
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 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 files while preserving their structure.
openpyxl stores formulas as strings but never evaluates them, so cells appear empty when read with data_only=True. Recalculate the file with LibreOffice via scripts/recalc.py to compute and store the values.
Run scripts/recalc.py on the file; it returns JSON listing each error type with cell locations like Sheet1!B5. Fix invalid references for #REF! errors and check denominators before division to prevent #DIV/0! errors, then recalculate again.
Yes, load the file with load_workbook() and modify cells, rows, or sheets while existing formulas and styles are preserved. Avoid saving a file 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.
Duzhenyang111Validate Excel workbooks for formula errors and structural flaws using Python.
jihe520Generate DrawIO sources and PDFs for non-data diagrams from reports.
cellarwoodRead cell values from Google Sheets via the gws CLI.
