Create and modify Excel workbooks with pandas and openpyxl.
npx skills add https://github.com/dachent/skills --skill xlsx-dachent
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/dachent/skills/tree/main/.upstream/anthropic-skills/57546260929473d4e0d1c1bb75297be2fdfa1949/skills/xlsx Command: npx skills add https://github.com/dachent/skills --skill xlsx-dachent
This skill solves the challenge of programmatically creating, editing, and analyzing complex Excel spreadsheets while ensuring formula integrity and professional formatting standards.
Use the xlsx skill to load the provided sales data, apply the required financial formatting, and recalculate all formulas to ensure there are no errors.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation by using pandas and openpyxl to generate dynamic financial models with live formulas. This approach ensures spreadsheets remain updateable and recalculates them via LibreOffice to verify professional deliverables.
openpyxl handles formula insertion, but automatic formula recalculation and error checking require LibreOffice. This integration runs headless recalculation across all sheets to identify errors like #REF! or #DIV/0! in your Excel workbooks.
The best way to clean messy tabular data is restructuring it into clean, professional-grade workbooks using pandas and openpyxl. This process validates formatting standards and applies formula-based calculations for financial modeling deliverables.
Yes, you can modify existing Excel spreadsheets using pandas and openpyxl while preserving formulas. The Skill automates workbook modifications, applies financial formatting, and uses LibreOffice to recalculate formulas and verify no errors are introduced.
Yes, LibreOffice is required for headless formula recalculation and error verification across all sheets. While pandas and openpyxl handle data restructuring and formatting, LibreOffice specifically validates formula integrity by identifying errors like #DIV/0!.
Excel formulas show #REF! or #DIV/0! errors after data restructuring due to broken references or invalid calculations. Automating formula verification with LibreOffice headless recalculation identifies and reports these exact errors across all sheets for validation.
QvvvvvvQAutomate XLSX/XLSM/CSV workbook construction, formula recalculation, and validation via CLI.
Mo7amed-MahmoudGenerate and modify Excel workbooks with Python libraries.
openyakRead, create, and edit DOCX documents locally using Python-docx and XML.
danielorzeata83-a11yCreate and edit Excel files with openpyxl and pandas.
