excel-generator

n8n community node for generating styled Excel (XLSX) files with conditional row coloring, custom columns, RTL support, and cell styling

Package Information

Downloads: 190 weekly / 190 monthly
Latest Version: 0.1.1

Available Nodes

Excel Generator icon
Excel Generator
Generate styled Excel (XLSX) files with custom columns, conditional row coloring, RTL support, and cell styling

Documentation

n8n-nodes-excel-generator

An n8n community node for generating styled Excel (XLSX) files with custom columns, conditional row coloring, RTL support, and cell styling.

Features

  • Custom column definitions — map data fields to custom headers with per-column widths, or auto-detect from input
  • Right-to-left support — native RTL worksheet layout for Hebrew, Arabic, and other RTL languages
  • Conditional row coloring — color rows based on field values with flexible rule matching (equals, in, greater than, contains, etc.)
  • Header styling — bold, background color, font color, alignment
  • Cell styling — borders, alignment, text wrapping
  • Pure data transformer — no credentials needed, no external network calls

Installation

In n8n (recommended)

  1. Go to Settings → Community Nodes
  2. Click Install a community node
  3. Enter n8n-nodes-excel-generator
  4. Click Install

Manual

cd ~/.n8n
npm install n8n-nodes-excel-generator

Restart n8n after installation.

Node Parameters

Basic Settings

Parameter Description
File Name Output file name (supports expressions)
Binary Property Binary property name for the output file

Column Mode

  • Auto — uses input item keys as column headers automatically
  • Manual — define columns explicitly with custom headers, data keys, and widths

Worksheet Options

Option Default Description
Sheet Name Sheet1 Worksheet tab name
Right to Left false RTL layout
Default Column Width 20 Default width for all columns
Creator (empty) Workbook creator metadata

Header Style

Option Default Description
Bold false Bold header font
Background Color (none) Fill color (ARGB hex)
Font Color (none) Font color (ARGB hex)
Horizontal Alignment center Left, center, or right
Vertical Alignment middle Top, middle, or bottom
Wrap Text true Wrap text in header cells

Cell Style

Option Default Description
Horizontal Alignment left Left, center, or right
Vertical Alignment middle Top, middle, or bottom
Wrap Text false Wrap text in data cells
Borders false Thin borders on all cells
Border Color FF000000 Border color (ARGB hex)

Conditional Row Styling

When enabled, rows are colored based on rules evaluated against field values.

Each rule specifies:

Field Description
Field Data field to evaluate
Operator equals, not_equals, in, not_in, greater_than, less_than, contains
Value Value to compare against (comma-separated for in/not_in)
Fill Color Row background color (ARGB hex)
Font Color Font color (ARGB hex, optional)
Bold Bold font for matching rows

Rules are evaluated in order — first match wins. Rows matching no rule use the Fallback Fill Color (if set).

ARGB Hex Color Format

Colors use 8-character ARGB hex format: AARRGGBB

Color ARGB Hex
Black FF000000
White FFFFFFFF
Red FFDF5653
Green FFA0CF63
Yellow FFFEFF54
Blue FF4472C4

FF prefix = fully opaque.

Examples

Simple unstyled report

  • Column Mode: Auto
  • All defaults — produces a plain XLSX with data keys as headers

Styled report with RTL and color-coded rows

  • Column Mode: Manual (custom Hebrew headers mapped to data fields)
  • Worksheet Options: Sheet Name = נתונים, Right to Left = true
  • Header Style: Bold = true, Alignment = center/middle
  • Cell Style: Borders = true, Alignment = center/middle, Wrap Text = true
  • Conditional Styling: enabled
    • Rule 1: Field status_code, Operator in, Value 200,201,203, Fill FFA0CF63 (green)
    • Rule 2: Field status_code, Operator equals, Value 204, Fill FFFEFF54 (yellow)
    • Fallback: FFDF5653 (red)

Development

npm install
npm run build

License

MIT

Discussion