ReadSheet Method

ReadSheet Method

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