Microsoft Excel
Creates an Excel .xlsx document from row-based JSON input.
Revision History
0.0.0.11 - 2026/04/13 - Initial release.
Setup Notes
- No authentication or external service setup is required.
- Ensure
Requestis a streamed array of JSON objects. - The first object defines worksheet columns; later rows map values to those column names.
Methods
This node exposes one method that writes request rows into a single-sheet workbook stream.
WriteToExcel
Builds an .xlsx workbook (Sheet1 by default) from streamed input rows and returns the workbook as a stream.
| Parameter | Type | Description |
|---|---|---|
WorksheetName |
String | Optional worksheet name written into workbook metadata. |
Request |
Array | Streamed array where each item must be a JSON object representing one row. |
| Return | Type | Description |
|---|---|---|
Document |
Stream | Generated .xlsx file stream positioned at the start for downstream consumers. |
Usage Notes
- Input rows must be objects; non-object values raise a validation error.
- Missing values for known columns are written as empty strings.
- Complex JSON values (arrays/objects) are serialized to JSON text in cells.
- Generated workbooks currently contain a single worksheet.