Microsoft Excel Component

Parse and build .xlsx files (spreadsheets)
Component key: ms-excel#
DescriptionMicrosoft 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
Input | Notes |
---|---|
Input File URL string / Required | Notes |
#
Actions#
Build SpreadsheetCreates a buffer containing a spreadsheet made from a 2D JavaScript array, | key: build
Input | Notes | Example |
---|---|---|
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
|
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
|
#
Output Example Payload{ "data": { "type": "Buffer", "data": [ 115, 97, 109, 112, 108, 101, 66, 117, 102, 102, 101, 114 ] }}
#
Read From BufferParse an xlsx file from a Buffer, outputs an array of worksheets | key: parseBuffer
Input | Notes |
---|---|
Input File string / Required | Notes Provide a Spreadsheet (file/buffer) to be parsed into array values. |
#
Read From URLParse an xlsx file from a URL endpoint, outputs an array of worksheets | key: parse
Input | Notes |
---|---|
Input File URL string / Required | Notes |