exceljs
exceljs enables you to programmatically build and customize Excel spreadsheets with full formatting control. Generate workbooks with styled cells, formulas, charts, and multiple sheets, then export them as .xlsx files ready for distribution or further analysis.
exceljs allows you to both read existing Excel files and create new ones programmatically in Node.js. To read an Excel file, you load a workbook from a .xlsx file and access its worksheets and cell data. To write, you create a new workbook, add worksheets, populate cells with data, apply formatting, and then save it as a .xlsx file. exceljs handles the entire lifecycle of Excel file manipulation, making it straightforward to integrate spreadsheet operations into your Node.js applications.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-01-28
exceljs allows you to both read existing Excel files and create new ones programmatically in Node.js. To read an Excel file, you load a workbook from a .xlsx file and access its worksheets and cell data. To write, you create a new workbook, add worksheets, populate cells with data, apply formatting, and then save it as a .xlsx file. exceljs handles the entire lifecycle of Excel file manipulation, making it straightforward to integrate spreadsheet operations into your Node.js applications.
Use it when
- exceljs supports comprehensive cell styling including colors, fonts, borders, alignment, and number formatting.
- Yes, exceljs is designed to process large Excel files efficiently using streaming capabilities.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Install
AIDotNet/MoYuCode/exceljs · repository language: TypeScript
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do you read and write Excel files in Node.js using exceljs?
exceljs allows you to both read existing Excel files and create new ones programmatically in Node.js. To read an Excel file, you load a workbook from a .xlsx file and access its worksheets and cell data. To write, you create a new workbook, add worksheets, populate cells with data, apply formatting, and then save it as a .xlsx file. exceljs handles the entire lifecycle of Excel file manipulation, making it straightforward to integrate spreadsheet operations into your Node.js applications.
What formatting options does exceljs provide for styling Excel cells?
exceljs supports comprehensive cell styling including colors, fonts, borders, alignment, and number formatting. You can customize font properties like size, bold, italic, and color; apply background colors and fill patterns; set border styles and colors on all sides; control text alignment and wrapping; and format numbers as currency, percentages, or dates. exceljs also enables conditional formatting and merged cells, giving you full control over the visual presentation of your Excel spreadsheets.
Can exceljs stream large Excel files efficiently?
Yes, exceljs is designed to process large Excel files efficiently using streaming capabilities. Rather than loading an entire workbook into memory, exceljs can stream data row-by-row, which significantly reduces memory consumption when working with massive datasets. This streaming approach makes exceljs ideal for handling big Excel files in production environments where memory efficiency is critical, allowing you to process files that would otherwise cause performance issues.
How do you generate Excel reports programmatically with exceljs?
exceljs enables you to generate Excel reports programmatically by creating workbooks, adding multiple worksheets, populating cells with data, applying professional styling with colors and fonts, and including formulas for calculations. You can structure your reports with headers, formatted data rows, summary sections, and charts. exceljs then exports the complete styled report as a .xlsx file ready for distribution or further analysis, making it perfect for automated report generation workflows.
Does exceljs support adding formulas and calculations to Excel workbooks?
exceljs supports adding formulas and calculations to Excel cells, allowing you to create dynamic spreadsheets with built-in computations. You can insert standard Excel formulas like SUM, AVERAGE, IF, and VLOOKUP directly into cells, and exceljs will preserve them when the file is saved. This means your exported Excel files can perform calculations automatically when opened, enabling users to modify data and see results update in real-time without requiring additional processing.
What is exceljs and why use it for Excel file manipulation?
exceljs is a Node.js library that enables you to programmatically create, read, and manipulate Excel spreadsheets with full formatting control. It's distributed under the MIT license and supports generating .xlsx files with styled cells, formulas, charts, and multiple sheets. exceljs is ideal for automating Excel workflows, exporting data from databases or APIs, creating styled reports, and processing existing spreadsheets—all without requiring Microsoft Excel to be installed on your system.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
ExcelJS Tool
Description
Read, manipulate, and write Excel spreadsheets with full formatting support.
Source
- Repository: exceljs/exceljs
- License: MIT
Installation
npm install exceljs
Usage Examples
Create Excel File
```typescript import ExcelJS from 'exceljs';
async function createReport() { const workbook = new ExcelJS.Workbook(); workbook.creator = 'My App'; workbook.created = new Date();
const sheet = workbook.addWorksheet('Sales Report');
// Define columns sheet.columns = [ { header: 'ID', key: 'id', width: 10 }, { header: 'Product', key: 'product', width: 30 }, { header: 'Quantity', key: 'quantity', width: 15 }, { header: 'Price', key: 'price', width: 15 }, { header: 'Total', key: 'total', width: 15 }, ];
// Add data const data = [ { id: 1, product: 'Widget A', quantity: 100, price: 9.99 }, { id: 2, product: 'Widget B',
(truncated - see the full file via the links below)
File tree — 1 file
skills/tools/exceljs/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Generate and export data to Excel files with formatting”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Spreadsheet Builder lets you generate and structure spreadsheets through code or simple automation workflows, eliminating repetitive manual setup. Perfect for data-heavy tasks, this skill streamlines the creation of organized, formatted sheets at scale.
excel-handler streamlines the process of reading Excel files and converting their contents into alternative formats for downstream use. Whether you need to parse spreadsheet data, extract specific ranges, or transform tabular information into JSON, CSV, or other structures, this skill handles the conversion workflow efficiently.
git-stats examines your repository's commit history, contributor activity, and code modifications. Run it with command-line flags to filter by date range, list top contributors, or identify the most-changed files.
Documentation Writer creates complete project documentation covering README files, API references, and inline code comments in multiple formats. It provides structured templates and examples to help you document features, installation steps, usage patterns, and contribution guidelines.
nodemailer enables Node.js developers to dispatch transactional emails programmatically with straightforward configuration and robust delivery handling. Whether you're sending password resets, order confirmations, or notifications, this skill integrates email functionality directly into your application workflow.
web-scraper enables you to harvest structured information from websites by defining selectors and parsing patterns. Perfect for automating data collection tasks, this skill transforms raw HTML into organized, usable datasets without manual intervention.