Skip to main content

Microsoft Excel Component

Parse and build .xlsx files (spreadsheets)

Component key: ms-excel

Description#

Microsoft Excel is a spreadsheet application developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. This component allows you to read and build .xlsx files. (spreadsheets)

Data Sources#

Select Sheet#

| key: sheetSelect | type: jsonForm

InputNotes
Input
File URL
string
/ Required
Notes
 

Actions#

Build Spreadsheet#

Creates a buffer containing a spreadsheet made from a 2D JavaScript array, | key: build

InputNotesExample
Input
Create Options
code
Notes
Here you can provide several configuration options for turning the array into a spreadsheet. For more information on possible configurations, see the documentation for the node library this component was built with. https://www.npmjs.com/package/node-xlsx
Example
{'!cols': [{ wch: 6 }, { wch: 7 }, { wch: 10 }, { wch: 20 } ]};
Input
File Name
string
/ Required
Notes
Provide a string value for the name of the file.
Example
mySheet
Input
Spreadsheet Data
code
/ Required
Notes
For each item, provide a list of items representing the items to be inserted.
Example
[ [1,2,3,4,5], [] ]

Output Example Payload#

{  "data": {    "type": "Buffer",    "data": [      115,      97,      109,      112,      108,      101,      66,      117,      102,      102,      101,      114    ]  }}

Read From Buffer#

Parse an xlsx file from a Buffer, outputs an array of worksheets | key: parseBuffer

InputNotes
Input
File
string
/ Required
Notes
Provide a Spreadsheet (file/buffer) to be parsed into array values.

Read From URL#

Parse an xlsx file from a URL endpoint, outputs an array of worksheets | key: parse

InputNotes
Input
File URL
string
/ Required
Notes