IDtExcelProviderEx.Sheet

Syntax

Sheet: String;

Description

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

Comments

As a value of this property, set name for one or several file sheets via the \; character. Data structure of all the sheets must be the same to ensure correct import.

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

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

Example

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