@martip/node-red-xlsx 1.0.2

Converts between a XLSX formatted stream and its JavaScript object representation, in either direction.

npm install @martip/node-red-xlsx

@martip/node-red-xlsx

A Node-RED node that parses a XLSX file and converts it to a JavaScript representation (object or array).

This node uses the read-excel-file package, by catamphetamine.

Install

Either use the Node-RED Menu - Manage Palette - Install, or run the following command in your Node-RED user directory - typically ~/.node-red

npm install @martip/node-red-xlsx

Usage

You pass the content of a XLSX file, as a buffer, in the msg.payload.

Depending on how it's configured, the node outputs a single message or a message for each parsed sheet, containing arrays or objects.