Assembly: Dt;
The IDtExcelConsumer interface contains properties and methods of the Export to Excel (97-2003) data consumer.
IDtExcelConsumer
For exported data, determine new sheet because existing list cannot be cleared.
IMPORTANT. The file the user is working with, should be closed and should not be used by other applications.
Property name | Brief description | |
The DriverVersion property determines version of the driver used to work with the file. | ||
The File property determines the path and the name of the file, in which the data is exported. | ||
The HasHeader property determines whether file with fields header list is loaded into the first row. | ||
The ImexMode property determines the mode, in which the columns, that contain data of different types, are exported. | ||
The Table property determines the name of the Excel file sheet, to which data is exported. |
Property name | Brief description | |
CalcFieldsErrors | The CalcFieldsErrors property returns a collection of errors appeared on calculated fields calculation. |
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. |
Method name | Brief description | |
PutBulk | The PutBulk method exports specified data packet in data consumer. |
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. |
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: