XLSX File
Reference
Reads and writes data from a XLS/XLSX file.
Categories: [helpers]
Version: 1
Actions
Read from File
Reads data from a XLS/XLSX file.
Properties
Name | Type | Control Type | Description |
---|---|---|---|
File | FILE_ENTRY | FILE_ENTRY | The object property which contains a reference to the XLS/XLSX file to read from. |
Sheet Name | STRING | TEXT | The name of the sheet to read from in the spreadsheet. If not set, the first one gets chosen. |
Header Row | BOOLEAN | SELECT | The first row of the file contains the header names. |
Include Empty Cells | BOOLEAN | SELECT | When reading from file the empty cells will be filled with an empty string. |
Page Size | INTEGER | INTEGER | The amount of child elements to return in a page. |
Page Number | INTEGER | INTEGER | The page number to get. |
Read As String | BOOLEAN | SELECT | In some cases and file formats, it is necessary to read data specifically as string, otherwise some special characters are interpreted the wrong way. |
Write to File
Writes the data to a XLS/XLSX file.
Properties
Name | Type | Control Type | Description |
---|---|---|---|
Sheet Name | STRING | TEXT | The name of the sheet to create in the spreadsheet. |
Rows | [{}] | ARRAY_BUILDER | The array of objects to write to the file. |
Filename | STRING | TEXT | Filename to set for binary data. By default, “file.xlsx” will be used. |
Output
Type: FILE_ENTRY
Properties
Type | Control Type |
---|---|
STRING | TEXT |
STRING | TEXT |
STRING | TEXT |
STRING | TEXT |