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

Input	Notes
Input File URL string / Required	Notes

---

Actions

Build Spreadsheet

Creates 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 {'!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

Input	Notes
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

Input	Notes
Input File URL string / Required	Notes

---