What problem does it solve?
This Skill simplifies the process of handling Excel files, automating tasks like reading, writing, and formatting, and providing advanced features like formula calculations and data querying.
Core Features & Use Cases
- Excel 文件操作: Read, write, and edit .xlsx, .xls, and .csv files.
- 工作表管理: Manage sheets, including adding, deleting, renaming, and copying.
- 格式化: Format columns and cells, including styles and formulas.
- 数据查询: Filter, sort, and find data within tables.
- 格式转换: Convert between Excel and other formats like JSON and CSV.
- 公式计算: Perform calculations using Excel formulas.
- Use Case: For example, you can use this Skill to extract specific data from a large Excel spreadsheet, format it for analysis, and then convert it to a CSV file for further processing.
Quick Start
Use the xlsx skill to read data from the 'data.xlsx' file into a JSON object.