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