error when export a excel files

Comments

• jdorlon

  March 2005 edited 5:43PM

  more info: I have seen this too with excel 2003, but not with prior versions.
• lancelotshui

  March 2005 edited 5:43PM

  I'm using win2k advanced server + delphi 7 enterprise + offiice 2k/
• AlexTZ

  March 2005 edited 5:43PM

  Does this error happen when you export any report or only some kind of report?
• lancelotshui

  March 2005 edited 5:43PM

  pdf,rtf,jpg,bmp are all ok
  error only happen in excel expor,
• AlexTZ

  March 2005 edited 5:43PM

  Please send the .fr3 and .fp3 files (.fp3 - save from preview) to tz@fast-report.com
• adolfo

  March 2005 edited 5:43PM

  I just have the same problem.
  Hope can be solved soon.
  
  Adolfo
• ftorres

  April 2005 edited 5:43PM

  I have the same problem for FR3 + Delphi7 on WinXP Pro
• ftorres

  April 2005 edited 5:43PM

  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

  June 2005 edited 5:43PM

  lancelotshui wrote:

  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

  June 2005 edited 5:43PM

  help..help..help
• AlexTZ

  June 2005 edited 5:43PM

  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

  October 2005 edited 5:43PM

  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

  October 2005 edited 5:43PM

  I have the same problem for FR318 + Delphi7 on WinXP Pro
  
  help me..........................
• sandy

  November 2006 edited 5:43PM

  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

  January 2009 edited 5:43PM

  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

  October 2009 edited March 2011

  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

  July 2010 edited March 2011

  Thanks for all the help with this - was driving me crazy!
  

  ---