IDtExcelConsumerEx

Assembly: Dt;

Description

The IDtExcelConsumerEx interface is used to load data to Excel consumer (*.xlsx).

Inheritance Hierarchy

          IDtObject

          IDtConsumer

          IDtBulkConsumer

          IDtExcelConsumerEx

Comments

Advantages of IDtExcelConsumerEx comparing to IDtExcelConsumer:

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 File property determines the entire name of the file, in which data is loaded.
The ForeFullCalculation property determines whether a workbook is force calculated on opening.
The HasHeader property determines whether to load consumer file into the row with data headers.
The Sheet property determines name of the sheet, on which data is loaded.

Properties inherited from IDtConsumer

  Property name Brief description
CalcFieldsErrors

The CalcFieldsErrors property returns a collection of errors appeared on calculated fields calculation.

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 IDtConsumer

  Method name Brief description
Clear The Clear method clears a data consumer.
Put The Put method records values array into the data consumer.
PutRow The PutRow method loads values row into the data consumer.
PutProvider The PutProvider method exports all the values of the specified data provider into the data consumer.
WritingRowsCount The WritingRowsCount method returns the number of records written to the data consumer.

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.

Methods inherited from IDtBulkConsumer

  Method name Brief description
PutBulk The PutBulk method exports specified data packet in data consumer.

See also:

Dt Assembly Interfaces