IDtExcelConsumerEx

Assembly: Dt;

Namespace: Prognoz.Platform.Interop.Dt;

Description

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

IDtExcelConsumerEx

Advantages of IDtExcelConsumerEx comparing to IDtExcelConsumer:

Loading of data headers is available.
Rows with length more than 255 symbols are exported.
For exporting data a new sheet is created, or existing one is cleared.
Links in formulas from other sheets are stored.
Apostrophe is not pasted before string values.
During export in the sheet, the name of which starts from a digital, in the beginning of the sheet name the low underlining is not substituted.

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

	Property name	Brief description
	File	The File property determines the entire name of the file, in which data is loaded.
	ForceFullCalculation	The ForeFullCalculation property determines whether a workbook is force calculated on opening.
	HasHeader	The HasHeader property determines whether to load consumer file into the row with data headers.
	Sheet	The Sheet property determines name of the sheet, on which data is loaded.

	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
	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.

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