XLSX File

Reads and writes data from a XLS/XLSX file.

Categories: helpers

Type: xlsxFile/v1

Actions

Read from File

Name: read

Reads data from a XLS/XLSX file.

Properties

Name	Label	Type	Description	Required
fileEntry	File	FILE_ENTRY	The object property which contains a reference to the XLS/XLSX file to read from.	true
sheetName	Sheet Name	STRING	The name of the sheet to read from in the spreadsheet. If not set, the first one gets chosen.	null
headerRow	Header Row	BOOLEAN Options true, false	The first row of the file contains the header names.	null
includeEmptyCells	Include Empty Cells	BOOLEAN Options true, false	When reading from file the empty cells will be filled with an empty string.	null
pageSize	Page Size	INTEGER	The amount of child elements to return in a page.	null
pageNumber	Page Number	INTEGER	The page number to get.	null
readAsString	Read As String	BOOLEAN Options true, false	In some cases and file formats, it is necessary to read data specifically as string, otherwise some special characters are interpreted the wrong way.	null

Example JSON Structure

{
  "label" : "Read from File",
  "name" : "read",
  "parameters" : {
    "fileEntry" : {
      "extension" : "",
      "mimeType" : "",
      "name" : "",
      "url" : ""
    },
    "sheetName" : "",
    "headerRow" : false,
    "includeEmptyCells" : false,
    "pageSize" : 1,
    "pageNumber" : 1,
    "readAsString" : false
  },
  "type" : "xlsxFile/v1/read"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Write to File

Name: write

Writes the data to a XLS/XLSX file.

Properties

Name	Label	Type	Description	Required
sheetName	Sheet Name	STRING	The name of the sheet to create in the spreadsheet.	null
rows	Rows	ARRAY Items [{}]	The array of rows to write to the file.	true
filename	Filename	STRING	Filename to set for binary data. By default, “file.xlsx” will be used.	true

Example JSON Structure

{
  "label" : "Write to File",
  "name" : "write",
  "parameters" : {
    "sheetName" : "",
    "rows" : [ { } ],
    "filename" : ""
  },
  "type" : "xlsxFile/v1/write"
}

Output

Type: FILE_ENTRY

Properties

Name	Type	Description
extension	STRING
mimeType	STRING
name	STRING
url	STRING

Output Example

{
  "extension" : "",
  "mimeType" : "",
  "name" : "",
  "url" : ""
}