Create, edit, analyze, and validate Excel spreadsheets with Python and LibreOffice.
npx skills add https://github.com/zhongjjm-design/claude-skills --skill xlsx-zhongjjm-design
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/zhongjjm-design/claude-skills/tree/main/xlsx Command: npx skills add https://github.com/zhongjjm-design/claude-skills --skill xlsx-zhongjjm-design
Creating and maintaining professional Excel files is time-consuming and error-prone, especially when dealing with complex formulas, consistent formatting, and large datasets. This Skill automates spreadsheet workflows while enforcing industry best practices for financial models and data integrity.
Use the xlsx skill to build a quarterly budget spreadsheet with dynamic SUM formulas and professional currency formatting for all monetary values.
High-intent search queries and answers about installing and using this skill.
Automate Excel spreadsheet creation and editing by using openpyxl to generate new .xlsx files or modify existing ones with full support for formulas, charts, and multi-sheet workbooks. This approach enforces industry best practices for financial models and data integrity.
Clean messy .csv or .tsv files by loading them with pandas, restructuring malformed rows and headers, and exporting clean, formatted Excel spreadsheets. This workflow transforms disorganized tabular data into professional, validated reports.
Validate Excel formulas by recalculating them using LibreOffice, which automatically detects errors like #REF!, #DIV/0!, and #VALUE!. This ensures formula-driven cell manipulation produces accurate results without manual auditing.
Yes, spreadsheet automation supports financial modeling standards by applying professional color coding, number formatting, and documentation rules for hardcoded values and assumptions. This ensures generated .xlsx files meet professional reporting requirements.
The best way to restructure malformed rows and headers in tabular data is loading the dataset with pandas to clean and restructure the information. You can then export the restructured data into a formatted .xlsx or .xlsm spreadsheet.
Yes, you need LibreOffice to recalculate formulas in openpyxl spreadsheets because openpyxl writes formulas but does not compute them. LibreOffice handles the formula recalculation and subsequent error detection for accurate validation.
northseadlCreate, edit, and analyze .xlsx, .csv, and .tsv files with Python.
cellarwoodRead cell values from Google Sheets via the gws CLI.
jeffpeckyAutomate Excel workflows with pandas and openpyxl for data analysis and editing.
rezosndGenerate styled Excel workbooks with formulas, charts, and data validation.
