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

Error on Export to Excel
https://forum.ehlib.com/en/viewtopic.php?f=5&t=1098
Page 2 of 3

Author:  jsm [ 20 Nov 2022, 05:05 ]
Post subject:  Re: Error on Export to Excel

my app is 32 bit app, but run in windows 64.
Do you mean that the program itself is 64 bit?

Author:  EhLibSupport [ 20 Nov 2022, 15:26 ]
Post subject:  Re: Error on Export to Excel

Hello

The program itself must be compiled 64 bit mode.

Author:  jsm [ 22 Nov 2022, 04:57 ]
Post subject:  Re: Error on Export to Excel

Does that mean we have to change the whole project because of the Excel output?
Is there no other way?

Author:  EhLibSupport [ 25 Nov 2022, 16:03 ]
Post subject:  Re: Error on Export to Excel

Hello

What do you mean by "to change"?
When compiling a Delphi project in x64 mode, the compiler automatically generates byte code for the x64 platform.

Author:  jsm [ 29 Nov 2022, 09:42 ]
Post subject:  Re: Error on Export to Excel

Do you mean this section?

Attachments:
Platform.png
Platform.png [ 4.38 KiB | Viewed 982 times ]

Author:  EhLibSupport [ 29 Nov 2022, 10:37 ]
Post subject:  Re: Error on Export to Excel

Yes

Author:  jsm [ 10 Dec 2022, 07:51 ]
Post subject:  Re: Error on Export to Excel

Our program is very large and various components are used in it that do not support the 64-bit version.
Is there no other way?

Author:  jsm [ 15 Feb 2023, 06:01 ]
Post subject:  Re: Error on Export to Excel

for this error:
"Unable to set the ColumnWidth property of the Range class"
plz check
follow links:
https://stackoverflow.com/questions/402 ... ange-class
https://www.mrexcel.com/board/threads/u ... ss.477941/
https://www.excelforum.com/excel-progra ... olumn.html



also i have problem with big data for export "Memory error"

Author:  blumache [ 11 Mar 2023, 19:48 ]
Post subject:  Re: Error on Export to Excel

About Excel XLSX export. It is possible to export the color of the ehlib grid cells? :roll:

Author:  EhLibSupport [ 13 Mar 2023, 08:52 ]
Post subject:  Re: Error on Export to Excel

Hello

You can use ExportDBGridEhToXlsx procedure with ExportOptions.IsExportFillColor := True to export cell colors.

See the documentation for the procedure ExportDBGridEhToXlsx.

https://www.ehlib.com/online-help/EhLib ... lsx-format

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