Novice: consult
How PivotGridEh output to excel, to see someone in http://blog.csdn.net/ghs79/article/details/54926534,
Consult ace can give PivotGridEh export excel instance,
The function ExportPivotGridEhToOleExcel (Grid: TCustomPivotGridEh; Options: TPivotGridExportAsOLEXLSOptionsEh) : the Variant;
Function parameters how to write, thank you!

CodePudding user response:

DBGridEh export EXCEL is not very mature,
Suggest you use the third control XLSReadWriteII4, DBGridEh intact, generate EXCEL table,

CodePudding user response:

The new version comes with export Excel function, call example: ExportPivotGridEhToOleExcel (PivotGridEh1, [pgxlsColoredEh]);

CodePudding user response:

Upstairs can output, but the format is different, and if the final statistics if there are two columns, can output a list,

CodePudding user response:

oooooooo

CodePudding user response:

reference xulibing1016 reply: 3/f

upstairs can output, but the format is different, and if the final statistics if there are two columns, can only output a list of

Are there any errors you mean control itself, lost a list of export content? Maybe related to set up, such a serious problem should not appear,

CodePudding user response:

reference xulibing1016 reply: 3/f

upstairs can output, but the format is different, and if the final statistics if there are two columns, can only output a list of

Or write their own one, is better,
Here is to write their own generated the effect of EXCEL, support multiple column headings, complete consistent with DBGrid,

CodePudding user response:

You can also specify the hidden columns, the above is the hidden "admission date" and "date of departure from the hospital."

CodePudding user response:

Suggest using DEV I now SanBuYong EHlib controls