IDtExcelProviderEx

Assembly: Dt;

Description

The IDtExcelProviderEx interface is used to collect data from Excel provider (*.xlsx).

Inheritance Hierarchy

          IDtObject

          IDtProvider

          IDtExcelProviderEx

Comments

Advantages of IDtExcelProviderEx comparing to IDtExcelProvider:

IMPORTANT. The file the user is working with, should be closed and should not be used by other applications.

Properties

  Property name Brief description
The DataRow property determines the index of the initial row, that contains data.
The File property determines the entire name of the data source file.
The Format property determines format of the source file.
The HasHeader property determines whether the source file contains the row with data headers.
The HeaderRow property determines the row index in the source file, that contains data headers.
The Sheet property determines the name of the sheet, on which data is located.

Properties inherited from IDtProvider

  Property name Brief description
AutoFillFieldsMode The AutoFillFieldsMode property determines the field type detection mode of the data provider.
CalcFieldsErrors The CalcFieldsErrors property returns a collection of errors appeared on calculated fields calculation.
Eof The Eof property returns True if the cursor in the data source is on the last record.
FetchErrors The FetchErrors property returns errors occurred on data import.
FilterIf The FilterIf property returns condition of loading of records from data provider.
StringDataFormat The StringDataFormat property returns settings used on data identification.
TypeGuessRows The TypeGuessRows property determines number of rows by means of which the data type of each field will be determined.

Properties inherited from IDtObject

  Property name Brief description
Active The Active property returns data source or data consumer state.
Fields The Fields property returns data provider/data consumer fields description.
GetType The GetType property returns data provider/data consumer type.
Metabase The Metabase property determines the repository, in which data is imported or exported.

Methods inherited from IDtProvider

  Method name Brief description
Fetch The Fetch method reads data of the current entry from the data provider.
FetchRows The FetchRows method reads data of the specified number of entries from the data provider and returns the number of actually read entries.
ReadingRowsCount The ReadingRowsCount method returns the number of records read from the data source with taking into account loading condition.
ReadingRowsTotalCount The ReadingRowsTotalCount method returns the number of records read from the data source without taking into account loading condition.

Methods inherited from IDtObject

  Method name Brief description
ClearFields The ClearFields method clears fields list of the data provider or data consumer.
Close The Close method closes data provider or data consumer.
FieldsFromFile The FieldsFromFile method reads fields list from the source file.
Load The Load method loads data source or data consumer parameters from XML.
Open The Open method opens data provider or data consumer.
Save The Save method saves data source or data consumer parameters in XML format.

See also:

Dt Assembly Interfaces