xlsx

Read, write, and transform Excel files using the ExcelJS library.

17|3|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/ErixWong/touwaka-ai-mate --skill xlsx-erixwong
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ErixWong/touwaka-ai-mate/tree/main/data/skills/xlsx
Command: npx skills add https://github.com/ErixWong/touwaka-ai-mate --skill xlsx-erixwong

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires exceljs, and includes scripts (resource) components.

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.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate reading and writing Excel data in .xlsx files?

Automating Excel data reading and writing in .xlsx files involves parsing the workbook structure programmatically. This Skill uses the ExcelJS library to manipulate worksheets and cell data without manual intervention.

Can I convert Excel data to JSON or CSV format for further processing?

Yes, you can convert Excel data to JSON or CSV format. This Skill supports format conversion between Excel worksheets and JSON or CSV outputs, enabling seamless downstream data analysis and processing.

Does ExcelJS support Excel formula calculations and cell formatting?

ExcelJS supports Excel formula calculations and cell formatting. You can apply styles to columns and cells, and perform calculations using Excel formulas directly within the manipulated workbook structure.

What is the best way to filter and sort data within Excel spreadsheets?

Filtering and sorting data within Excel spreadsheets is achieved through programmatic data querying. This Skill applies the ExcelJS library to filter, sort, and find specific data within tables efficiently.

How do I manage worksheets like adding, deleting, or renaming sheets?

Managing worksheets, including adding, deleting, renaming, and copying sheets, is handled by manipulating the workbook structure. This Skill automates these worksheet management tasks using the ExcelJS dependency.