Create and edit Excel workbooks while preserving formulas with pandas and openpyxl.
npx skills add https://github.com/PaulCrossland1/claude-code-skills --skill xlsx-paulcrossland1
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/PaulCrossland1/claude-code-skills/tree/main/xlsx Command: npx skills add https://github.com/PaulCrossland1/claude-code-skills --skill xlsx-paulcrossland1
This Skill automates the creation, editing, and analysis of spreadsheets, reducing manual data handling and ensuring formula integrity across workbooks.
Create a new workbook named "sales.xlsx" with a sheet "Overview", include a header row, and a formula in cell B2 that sums B3:B12, then run the recalc script to verify all formulas.
High-intent search queries and answers about installing and using this skill.
Excel workflow automation preserves embedded formulas during edits by using pandas for data extraction and openpyxl for formatting control. This ensures formula integrity across workbooks while updating existing spreadsheets.
Pandas and openpyxl work together for spreadsheet data analysis by leveraging pandas for extraction and openpyxl for advanced formatting. This combination produces clean reports and visualizations from Excel data.
LibreOffice is required for formula recalculation in Excel workbooks. The recalc.py script runs in combination with LibreOffice to validate and recalculate formulas, ensuring accurate results across the workbook.
The best way to generate a new Excel workbook is through automated creation that applies proper formatting, headers, and formulas. This approach ensures consistent structure and formula integrity for finance and reporting workflows.
Editing an existing spreadsheet with openpyxl preserves embedded formulas and structure. The workflow maintains formula integrity during updates, ensuring calculations remain intact while data is modified.
Automated spreadsheet workflows should be used for finance, analytics, and reporting tasks involving data import and formula maintenance. They reduce manual data handling and ensure consistent formula recalculation and result visualization.
AndersHsuehCreate, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.
aleph23Create, edit, and analyze Excel workbooks with formula preservation and recalculation.
gaos6eAutomates Word and Excel document tasks using python-docx, openpyxl, and pandas.
PaneriVatsalCreate, edit and validate Excel spreadsheets preserving formulas and formatting via LibreOffice recalculation.
