XLSX
Comprehensive spreadsheet creation, editing, and analysis with support for formulas...
Install
npx skills add jjyaoao/HelloAgents --skill xlsx -g -a claude-code -y- Repository
- jjyaoao/HelloAgents3.3k
- Category
- Documents
- Updated
- 29d ago
- License
- See repository
- Context cost
- Mediumabout 3,000 tokens
- Runs scripts
- Yes, review before use
What it does
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When GLM needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
XLSX creation, editing, and analysis
Overview
A user may ask you to create, edit, or analyze the contents of an .xlsx file. You have different tools and workflows available for different tasks.
Must output excel files.
Important Requirements
Python 3 and openpyxl Required for Excel Generation: You can assume Python 3 as the runtime environment. The openpyxl library is required as the primary tool for creating Excel files, managing styles, and writing formulas.
pandas Utilized for Data Processing: You can utilize pandas for efficient data manipulation and processing tasks. The processed data is subsequently exported to the final Excel file through openpyxl.
LibreOffice Required for Formula Recalculation: You can utilize recalc.py for formula check. You can assume LibreOffice is installed for recalculating formula values using the recalc.py script. The script automatically configures LibreOffice on first run.
