DtExcelProviderEx

Assembly: Dt;

Description

The DtExcelProviderEx class is used to collect data from Excel provider.

Comments

Advantages of DtExcelProviderEx comparing to DtExcelProvider:

The data can be loaded from Excel files to the time series database if a 64 bit operating system is used.
The IDtObjectMetaData.Tables method returns a sheets list only.
Rows with length more than 255 symbols are read correctly from XLSX files and more than 255 columns are downloaded.
Problems with reading data of different types from XLSX file are solved.
Problems with loading string values with mixed fonts: regular and italic are solved.

Properties inherited from IDtExcelProviderEx

	Property name	Brief description
	DataRow	The DataRow property determines the index of the initial row, that contains data.
	DataSheetRow	The DataSheetRow property determines the index of the first row containing data for the selected sheet.
	File	The File property determines the entire name of the data provider file.
	Format	The Format property determines format of the provider file.
	HasHeader	The HasHeader property determines whether the provider file contains the row with data headers.
	HeaderRow	The HeaderRow property determines the row index in the provider file that contains data headers.
	Sheet	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 provider 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 provider 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 record 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 provider with taking into account loading condition.
	ReadingRowsTotalCount	The ReadingRowsTotalCount method returns the number of records read from the data provider 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/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 provider/data consumer parameters from XML.
	Open	The Open method opens data provider or data consumer.
	Save	The Save method saves data provider/data consumer parameters in XML format.

See also:

Dt Assembly Classes