IDtExcelConsumer

Assembly: Dt;

Namespace: Prognoz.Platform.Interop.Dt;

Description

The IDtExcelConsumer interface contains properties and methods of the Export to Excel (97-2003) data consumer.

Inheritance Hierarchy

          IDtObject

          IDtConsumer

          IDtBulkConsumer

          IDtExcelConsumer

Comments

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.

Properties

	Property name	Brief description
	DriverVersion	The DriverVersion property determines version of the driver used to work with the file.
	File	The File property determines the path and the name of the file, in which the data is exported.
	HasHeader	The HasHeader property determines whether file with fields header list is loaded into the first row.
	ImexMode	The ImexMode property determines the mode, in which the columns, that contain data of different types, are exported.
	Table	The Table property determines the name of the Excel file sheet, to which data is exported.

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 IDtBulkConsumer

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

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.

See also:

Dt Assembly Interfaces