Microsoft Excel Component
Parse and build .xlsx files (spreadsheets)
Component key: ms-excelDescription
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
Actions
Build Spreadsheet
Creates a buffer containing a spreadsheet made from a 2D JavaScript array, | key: build
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
Read From URL
Parse an xlsx file from a URL endpoint, outputs an array of worksheets | key: parse