返回 Skill 列表
extension
分类: 开发与工程无需 API Key

document-processing-xlsx

使用如xlsx、exceljs或SheetJS等库处理、解析、创建和操作Excel电子表格(.xlsx, .xls),用于数据的导入/导出和电子表格自动化。当需要读取Excel文件进行数据导入、生成Excel报告、将数据导出到电子表格、解析批量上传、创建财务报告、操作工作簿和工作表,或是构建数据导出功能时使用。

person作者: jakexiaohubgithub

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"); ```

Resources