document-processing-xlsx
使用xlsx、exceljs或SheetJS等库处理、解析、创建和操作Excel电子表格(.xlsx, .xls),用于数据导入/导出和电子表格自动化。在读取Excel文件进行数据导入、生成Excel报告、将数据导出到电子表格、解析批量上传、创建财务报告、操作工作簿和工作表或构建数据导出功能时使用。
📖 中文导读:使用xlsx、exceljs或SheetJS等库处理、解析、创建和操作Excel电子表格(.xlsx, .xls),用于数据导入/导出和电子表格自动化。在读取Excel文件进行数据导入、生成Excel报告、将数据导出到电子表格、解析批量上传、创建财务报告、操作工作簿和工作表或构建数据导出功能时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: document-processing-xlsx description: Process, parse, create, and manipulate Excel spreadsheets (.xlsx, .xls) using libraries like xlsx, exceljs, or SheetJS for data import/export and spreadsheet automation. Use when reading Excel files for data import, generating Excel reports, exporting data to spreadsheets, parsing bulk uploads, creating financial reports, manipulating workbooks and worksheets, or building data export features.
Document Processing - Excel Files
When to use this skill
- Reading Excel files for data import and processing
- Generating Excel reports and spreadsheets
- Exporting application data to Excel format
- Parsing bulk data uploads from spreadsheets
- Creating financial reports and statements
- Manipulating workbooks, worksheets, and cells
- Building CSV to Excel converters
- Creating templates for data entry
- Extracting data from uploaded spreadsheets
- Generating dynamic Excel reports with formulas
- Handling large dataset imports from Excel
- Building data export and reporting features
When to use this skill
- Creating, parsing Excel spreadsheets.
- When working on related tasks or features
- During development that requires this expertise
Use when: Creating, parsing Excel spreadsheets.
Example
```typescript import * as XLSX from 'xlsx';
const ws = XLSX.utils.aoa_to_sheet([[1, 2], [3, 4]]); const wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, "Sheet1"); ```