node-red-contrib-xlsx-template-tienho 1.0.0

Allow to generate XLSX reports

npm install node-red-contrib-xlsx-template-tienho

Node-red xlsx Template

This node take an xlsx file as template and generate a report based on this file.

This node uses the xlsx-template package by optilude.

Inputs

The node receives an object stringified (i.e. JSON.stringify(object)) in msg.payload which contain all data to fill the sheet 1 of the xlsx file template to generate the report.

The object has to contain all data that is configured in the tamplate file as placeholder as decribed in the documentation of the original module xlsx-template https://www.npmjs.com/package/xlsx-template?activeTab=readme.

It also receives the full path to the xlsx template (including the name of the file .xlsx) in msg.template.

/home/user/templates/template_name.xlsx

and the full path of the report where (including the report name .xlsx) msg.report

/home/user/reports/report_name.xlsx

and sheet in file msg.sheet

1