Skip to main content

Microsoft Excel Component

Microsoft Excel

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

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