node-red-contrib-excelsheets
Advanced tools
Comparing version 1.0.2 to 1.0.3
{ | ||
"name": "node-red-contrib-excelsheets", | ||
"version": "1.0.2", | ||
"version": "1.0.3", | ||
"description": "writes multi-sheet excel files", | ||
@@ -5,0 +5,0 @@ "scripts": { |
@@ -1,7 +0,44 @@ | ||
# node-red-json2excel | ||
# node-red-contrib-excelsheets | ||
This is a fork of this project: https://flows.nodered.org/node/node-red-contrib-excel | ||
## Overview | ||
I needed the ability to save data to multiple sheets and it wasn't supported by the json2xls module. | ||
Features the ability to save data to multiple sheets. I found it wasn't supported in some of the other nodes already available. | ||
This project uses a module named json2excel that does support multiple sheets. | ||
To see an example, install the package, then in your Node-RED environment go to Import > Examples > node-red-contrib-excelsheets | ||
Basic **msg** format is, | ||
``` | ||
payload: [ | ||
{ | ||
header: { | ||
col1: "Column 1", | ||
col2: "Column 2", | ||
... | ||
} , | ||
items: [ | ||
{ | ||
col1: "data", | ||
col2: "data", | ||
... | ||
} | ||
] , | ||
sheetName: "Sheet 1" | ||
} , | ||
{header, items, sheetName} , | ||
{header, items, sheetName} , | ||
{header, items, sheetName} , | ||
... | ||
] , | ||
filename: "output.xlsx" | ||
``` | ||
# Change Log | ||
1.0.0 - Original version, forked from "node-red-contrib-excel" and swapped out a different dependency. | ||
1.0.1 - Cleanup. | ||
1.0.2 - Cleanup and documentation. | ||
1.0.3 - Cleanup and documentation. | ||
# TODO | ||
[ ] - Digging deeper into the dependencies, there's a really powerful package called "xlsx" (npmjs.com)[https://www.npmjs.com/package/xlsx] that has a rich base of features, I would like to create a node that uses everything available. | ||
[ ] - Come up with a few examples that do something more interesting |
Sorry, the diff of this file is not supported yet
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
6806
44