IDtExcelProviderEx.Sheet

Syntax

Sheet: String;

Description

The Sheet property determines the name of the sheet on which data is located.

Comments

As a property value, specify name of one or several sheets. If several sheets are specified, names are separated via the combination of characters \;, for example, Sheet1\;Sheet2. Data structure of all the sheets must be the same to ensure correct import.

To determine a data provider file, use the IDtExcelProviderEx.File property.

To determine an index of the first sheet rows, starting from which data will be imported, use the IDtExcelProviderEx.DataSheetRow property.

Example

The property use is given in the example for IDtExcelProviderEx.File.