DtExcelConsumerEx

Assembly: Dt;

Description

The DtExcelConsumerEx class loads data to Excel data consumer.

Comments

Advantages of IDtExcelConsumerEx comparing to DtExcelConsumer:

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.

Properties inherited from IDtExcelConsumerEx

	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 the row with data headers to consumer file.
	Sheet	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 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 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 to the data consumer.
	PutProvider	The PutProvider method exports all values of the specified data provider to 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/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