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)

Actions#

Build Spreadsheet#

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

InputKeyNotesExample

Create Options

code
createOptionsHere 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{'!cols': [{ wch: 6 }, { wch: 7 }, { wch: 10 }, { wch: 20 } ]};

File Name

string
/ Required
fileNameProvide a string value for the name of the file.mySheet

Spreadsheet Data

code
/ Required
sheetDataFor each item, provide a list of items representing the items to be inserted.[ [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

InputKeyNotes

File

string
/ Required
fileProvide 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

InputKeyNotes

File

string
/ Required
fileProvide a Spreadsheet (file/buffer) to be parsed into array values.