lancelotshui
Mar 2 2005, 03:44 AM
when I export the report as a excel file.
it always encounter error
it said "project xxx raised exception EOleException with message 'OLE error 800A03EC'".
what had happened
jdorlon
Mar 2 2005, 10:48 AM
more info: I have seen this too with excel 2003, but not with prior versions.
lancelotshui
Mar 2 2005, 06:24 PM
I'm using win2k advanced server + delphi 7 enterprise + offiice 2k/
AlexTZ
Mar 4 2005, 02:12 PM
Does this error happen when you export any report or only some kind of report?
lancelotshui
Mar 4 2005, 07:08 PM
pdf,rtf,jpg,bmp are all ok
error only happen in excel expor,
AlexTZ
Mar 7 2005, 04:58 AM
Please send the .fr3 and .fp3 files (.fp3 - save from preview) to tz@fast-report.com
adolfo
Mar 7 2005, 04:14 PM
I just have the same problem.
Hope can be solved soon.
Adolfo
ftorres
Apr 26 2005, 01:14 PM
I have the same problem for FR3 + Delphi7 on WinXP Pro
ftorres
Apr 27 2005, 08:08 AM
this worked for me:
frxPrint1.PrepareReport;
frxPrint1.Export(frxTXTExport);
that will bring up the export dialog (according to your setting) and do the job.
though an excel export is really slow for me.
I rather use a TXT export and then use a step import procedure in Excel. Much faster.
JiguJigu
Jun 15 2005, 03:49 AM
| QUOTE (lancelotshui @ Mar 2 2005, 03:44 AM) |
when I export the report as a excel file.
it always encounter error
it said "project xxx raised exception EOleException with message 'OLE error 800A03EC'".
what had happened |
i have exactly problem with you ,...
i am running the frdemo (demo from FastReport 3.14), i download the program today (06/15/05),.. i click the preview the simple list, after that i click export btn, and choice the excel (ole).. or (xml).. it will show error :
"project xxx raised exception EOleException with message 'OLE error 800A03EC'".
I am using window xp-sp1 and delphi 7 pacth 1 and win office xp (in about dialog microsoft excel say : Microsoft Execl 2002 (10.4302.4219) SP-2.
please help..
Jigu2x
JiguJigu
Jun 17 2005, 02:21 AM
help..help..help
AlexTZ
Jun 18 2005, 02:25 AM
xml export does not use any OLE calls! This error may happens only with excel-ole export. Try to check/uncheck the "fast export" option in the export dialog.
clanmilano
Oct 5 2005, 05:17 AM
The solution is: comment the lines in the unit that work with the excel files export...there is a problem with a procedure in that unit...i resolve that problem doing that...
Verify if that problem exists only when you do fast export, if you uncheck that option in the window, it works good...
DG_1
Oct 28 2005, 04:35 PM
I have the same problem for FR318 + Delphi7 on WinXP Pro
help me..........................
sandy
Nov 15 2006, 11:00 PM
oke maybe it's been a years more, but actually i've found the answer, before you export your report into excel, make sure that is no violation of the rules of excel. In Example, if you have text "=Test This is Wrong" , then it can raise OLE Error, because Excel interprets it as a Formula.. So you need to add quote (') in the left of string (become '=Test This is Right). It'll happen too for all ambiguous condition.
Make sure your data isn't ambiguous. Then you'll be fine.
Thank you.
Alex Krenvalk
Jan 8 2009, 09:09 AM
For work with excel files recommend use-
recovery xls,tool is free,it has many features,utility can be easily solved with Excel recovery software for recovery xls,will allow you to Excel files recovery and make sure, that it works and that your work results can now be recovered just in several clicks,allows to save many hours of your work for recovery for Excel download and recover everything, that was done before.
Crimson12
Oct 6 2009, 11:12 PM
The solution is: comment the lines in the unit that work with the excel files export...there is a problem with a procedure in that unit...i resolve that problem doing that...
Regards
Crimson
______
cannonfodder
Jul 15 2010, 01:21 PM
Thanks for all the help with this - was driving me crazy!
---------------------------
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.