n8n-nodes-xlsx-template

Generate .xlsx files from JSON data using an .xlsx template in n8n.

Features

• Substitute variables in an .xlsx template with JSON data.
• Output the generated .xlsx file as a binary field.
• Configure input/output fields and file names.

Usage

1. Add the Xlsx Template node to your workflow.

2. Provide an .xlsx template file as binary input (e.g., from an HTTP Request or Read Binary File node).

3. Configure the node parameters:

   • Input Template Binary Field: Name of the binary property containing the template (default: data).
   • Put Output File In Field: Name of the binary property for the output file (default: data).
   • Options:
     • Input Sheet Name: Sheet name or index to substitute (default: Sheet1).
     • Output File Name: Name for the generated file (default: File.xlsx).

4. The node outputs the generated .xlsx file in the specified binary field.

Example

Suppose you have a template with placeholders like ${name} and input JSON:

{ "name": "Alice" }

The node will substitute ${name} in the template with "Alice" and output the resulting .xlsx file.

Parameters

| Parameter | Description | Default | |------------------------------|--------------------------------------------------|--------------| | Input Template Binary Field | Binary field with the template | data | | Put Output File In Field | Binary field for the output file | data | | Options → Input Sheet Name | Sheet name or index to substitute | Sheet1 | | Options → Output File Name | Name for the generated file | File.xlsx |

License

MIT