Using this method you can read content of an Excel sheet into an entity in a context store.
PARAMETERS
Format
String (Context Store Reference, Data Constant Reference)
The format of an Excel file. The accepted values are XLS
and XLSX
. The default value is XLS
.
FileName
String (Context Store Reference, Data Constant Reference)
A path to an input Excel file. Ignored when File is specified.
File
Blob (Context Store Reference)
The file itself (e.g. when loaded from a database).
SheetName
String (Context Store Reference, Data Constant Reference)
A name of the sheet to read from.
Entity
String (Context Store Reference, Data Constant Reference)
A name of a data-structure entity in your output context store to read to. You can use a database or virtual entity. Field names must be the same as column names in the header row of the Excel sheet. Only fields defined in the entity will be read, the rest of the fields will be skipped.
Options
XML (Context Store Reference)
TextReaderOptions XML specifying how the data will be handled (e.g. date formats or how many lines to ignore in the beginning and an end of the sheet).
Parameter
Type
Description