Using this method you can read content of an Excel sheet into an entity in a context store.
The format of an Excel file. The accepted values are
XLSX. The default value is
A path to an input Excel file. Ignored when File is specified.
Blob (Context Store Reference)
The file itself (e.g. when loaded from a database).
A name of the sheet to read from.
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.
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).