SELECT.EXCEL
Selects content from a source containing Microsoft Excel format.
Properties
From | Name of the Input Data Source.The input-source can contain either a file-path, a PBinaryStream object or a .Net Stream object. A Stream object can only be specified programmatically. |
To | Name of the Output Data Source. |
Parameters
@Context | Specifies in which context to find data in the Excel-file.
Shortcuts |
@Filter | Filter the result of the selected data. See Command Maps & Parameters for more information. |
@Order | Order the result of the selected data. See Command Maps & Parameters for more information. |
Map
From | Name of Header, as it is named in the file. |
To | Name of the Header as it should be called in the Output table |
Script | Any Script code to execute for this header |
Example 1:
The context Horizontal/B:I/3:1/1 matches a sheet as the one shown below:
… Horizontal (name of the sheet, although it cannot be seen from above example)
… B:I columns containing header and data
… 3:1 to find the header we need to skip 3 rows and then take 1 as the header
… 1 to find the data we need to skip 1 row after the header, and then take the rest
Example 2:
Â
The context Vertical/4:11/1/1 matches a sheet as the one shown below:
… Vertical (name of the sheet, although it cannot be seen from above example)
… 4:11 columns containing header and data.
… 1 to find the header we need to skip 1 row and then take 1 as the header
… 1 to find the data we need to skip 1 row after the header, and then take the rest
NOTE: Notice that since Excel uses letters for columns and numbers for rows. By specifying the columns as numbers in the context, the command knows to read the rows from the Excel-file as columns, thereby reading the vertically stored data correctly.