Xlsx Template

Node for generating xlsx files from json and .xlsx file template

Overview

This node generates XLSX files by merging JSON data with an existing XLSX file template. It is useful when you want to create customized Excel reports or documents based on dynamic input data while preserving the formatting and structure of a predefined template file.

Typical use cases include:

Generating invoices, reports, or summaries where the layout is fixed but content varies.
Automating the creation of Excel files for data export with consistent styling.
Filling out forms or templates stored as XLSX files using JSON input.

Properties

Name	Meaning
Input Template Binary Field	The name of the binary field in the input item that contains the XLSX template file.
Put Output File In Field	The name of the field where the generated XLSX file will be placed in the output item.
Options	A collection of additional options:
- Input Sheet Name	The name of the sheet within the template XLSX file to use for data insertion (default "Sheet1").
- Output File Name	The filename to assign to the generated XLSX file (default "File.xslx").

Output

The node outputs items containing the generated XLSX file in binary form. The binary data is placed in the field specified by the "Put Output File In Field" property. The output item’s JSON part may contain metadata such as the output file name.

In summary:

json: Contains metadata about the output file.
binary: Contains the generated XLSX file data ready for download or further processing.

Dependencies

Requires an input binary field containing a valid XLSX template file.
Uses internal logic (from bundled dependencies) to merge JSON data into the XLSX template.
No external API keys or services are required.
No special environment variables needed.

Troubleshooting

Missing or invalid template file: Ensure the input binary field specified actually contains a valid XLSX file; otherwise, the node will fail to generate output.
Incorrect sheet name: If the specified input sheet name does not exist in the template, the node may error or produce empty output.
Output field conflicts: Make sure the output field name does not overwrite important data unless intended.
File naming issues: Verify the output file name has a proper .xlsx extension to avoid confusion when opening the file.