EhLib.Com
https://forum.ehlib.com/en/

How to use ExportDBGridEhToOleExcel
https://forum.ehlib.com/en/viewtopic.php?f=2&t=90
Page 1 of 1

Author:  beroyak [ 22 Feb 2012, 11:24 ]
Post subject:  How to use ExportDBGridEhToOleExcel

Hi!
I want to know to use the procedure "ExportDBGridEhToOleExcel"

Author:  sunyesy [ 22 Mar 2012, 09:08 ]
Post subject:  Re: How to use ExportDBGridEhToOleExcel

:cry:

Author:  Administrator [ 26 Mar 2012, 11:43 ]
Post subject:  Re: How to use ExportDBGridEhToOleExcel

Hello

Here is an example:

ExportDBGridEhToOleExcel(DBGridEh1, [], True);

Here is declaration of ExportDBGridEhToOleExcel:

Code:
function ExportDBGridEhToOleExcel(DBGridEh: TCustomDBGridEh;
  Options: TDBGridEhExportAsOLEXLSOptions; IsSaveAll: Boolean = True): Variant;

type
  TDBGridEhExportAsOLEXLSOption = (oxlsColoredEh, oxlsDataAsDisplayText,
    oxlsDataAsEditText);

  TDBGridEhExportAsOLEXLSOptions = set of TDBGridEhExportAsOLEXLSOption;


function returns Instance of Excel.Application created by CreateOleObject('Excel.Application') function.
So you can perform addidtion action after creation data.

Best regards
Admin.

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/