Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for creating new spreadsheets, reading/analyzing data, modifying existing spreadsheets, or recalculating formulas.
The 'xlsx' skill is designed to provide comprehensive capabilities for working with spreadsheets. It facilitates the creation, editing, and analysis of Excel files (.xlsx, .xlsm, .csv, .tsv, etc.), enabling users to handle a wide range of tasks from generating new spreadsheets to recalculating formulas. By leveraging Python libraries such as pandas and openpyxl, this skill allows users to seamlessly manipulate data, format cells, and apply advanced features like formulas and charts for data visualization. It addresses the need for a flexible, powerful toolset that works across different spreadsheet formats while ensuring compatibility with industry-standard Excel files.
You can read data from an Excel file using pandas' `pd.read_excel()` function. By default, it reads the first sheet, or you can specify `sheet_name=None` to load all sheets as a dictionary.
Yes, you can write data to an Excel file using pandas' `df.to_excel()` function. You can specify the file name and whether to include the index.
To modify an existing spreadsheet, use the `openpyxl` library's `load_workbook()` function. You can edit cells, add new sheets, and perform various operations like inserting rows or deleting columns.
Always use formulas in Excel instead of hardcoding values. For example, use `'=SUM(B2:B9)'` instead of hardcoding the sum. This ensures that the calculations are dynamic and will update if data changes.
For large files, you can use the `read_only=True` or `write_only=True` options in `openpyxl` to improve performance. However, be aware that formulas may not be evaluated by `openpyxl`.
Quick Setup:
.claude/skills/Repository
skillcreatorai/Ai-Agent-Skills