Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 11:31

All times are UTC




Post new topic Reply to topic  [ 22 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: Error on Export to Excel
PostPosted: 01 Aug 2021, 10:28 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Hi,
I get follow error on ExportDBGridEhToOleExcel:
'Unable to set the ColumnWidth property of the Range class'


I use with this parameter ExportDBGridEhToOleExcel(dbgrideh1,[oxlsColoredEh, oxlsDataAsDisplayText,oxlsDataAsEditText])


Top
 Profile  
 
PostPosted: 01 Aug 2021, 13:51 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello jsm.

We are unable to reproduce the error with simple examples.
Can you send a Demo project in which this error would be reproduced?

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 07 Aug 2021, 14:50 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
plz check follow picture:
my code is: ExportDBGridEhToOleExcel(DBGridEh1, [oxlsColoredEh, oxlsDataAsDisplayText,oxlsDataAsEditText]);


Attachments:
Sample.png
Sample.png [ 65.49 KiB | Viewed 2094 times ]
Top
 Profile  
 
PostPosted: 10 Aug 2021, 13:08 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Quote:
plz check follow picture:
my code is: ExportDBGridEhToOleExcel(DBGridEh1, [oxlsColoredEh, oxlsDataAsDisplayText,oxlsDataAsEditText]);

Do you have MS Office installed?
ExportDBGridEhToOleExcel works only when MS Office is installed on the computer.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 10 Aug 2021, 15:19 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Yes


Top
 Profile  
 
PostPosted: 10 Aug 2021, 23:26 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
What version of MS Office do you have?
And I tested it on MS Office 2019. An error does not occur on tables larger than 100'000.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 13 Aug 2021, 06:21 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Office 2016


Top
 Profile  
 
PostPosted: 13 Aug 2021, 16:31 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

Try to reduce the number of records in the grid.
Perhaps the office 2016 does not support more than 100,000 records.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 19 Nov 2022, 06:02 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Hello, I get the following error when using this command, for a record count of about 70,000

"raised exception class EOutOfMemory with message 'Out of memory'"

I Use the TDBGridEhToXlsMemFileExporter
"I use Office 2021"


Top
 Profile  
 
PostPosted: 19 Nov 2022, 23:47 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

To export big data to Xlsx, you need to compile and run the application in Windows x64 mode.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 22 posts ]  Go to page 1, 2, 3  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 52 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group