exceljs

What problem does it solve?

This Skill simplifies the process of reading, manipulating, and writing Excel spreadsheets directly within Node.js applications, eliminating the need for manual data entry or complex external tools.

Core Features & Use Cases

• Create & Write Excel Files: Generate new XLSX files with data, headers, and formulas.
• Style Cells: Apply custom formatting, colors, and borders to cells for professional reports.
• Read & Parse Excel Files: Extract data from existing XLSX files into a structured format.
• Stream Large Files: Efficiently handle very large Excel files without consuming excessive memory.
• Use Case: Automatically generate a monthly sales report in XLSX format, complete with styled headers and calculated totals, directly from your application's data.

Quick Start

Use the exceljs skill to create a new Excel file named 'report.xlsx' with sales data.