Ole Error 800a03ec Delphi
Contents |
here for a quick overview of the site Help Center Detailed answers to ole error 800a03ec excel 2013 any questions you might have Meta Discuss the workings and policies
Excel Output Failed Ole Error 800a03ec
of this site About Us Learn more about Stack Overflow the company Business Learn more microsoft office excel error '800a03ec' about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack ole error 800a03ec excel 2007 Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Ole 800A03EC error when using TExcelWorkBook SaveAs method in Delphi 7 up vote 4 down vote favorite 3 I am trying to open excel 2003 workbook and save
Ole Error 800ac472
it as something else, for example excel 95. I use the following code: XLSApp:=TExcelApplication.Create(Self); XLSApp.Workbooks.Open(SomeFileName,NULL,false,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,defaultlcid); XLSWB:=TExcelWorkbook.Create(XLSApp); XLSWB.ConnectTo(XLSApp.Workbooks.Item[1]); XLSWB.SaveCopyAs(ExtractFilePath(edTable.Text)+'temp.xls'); XLSWB.SaveAs(SomeOtherFileName,xlExcel7,EmptyParam,EmptyParam,False,False,xlNoChange,xlUserResolution,False,EmptyParam,EmptyParam,EmptyParam,DefaultLCID); Unfortunately this code gives "Ole 800A03EC" on clients computer, while it works on mine. Note that I have Office 2007 installed, and he has Office 2003 SP3. Any help would be very much appreciated. delphi excel automation ole share|improve this question edited Mar 2 '10 at 7:37 The_Fox 6,06122758 asked Mar 1 '10 at 13:15 Tofig Hasanov 71362359 add a comment| 4 Answers 4 active oldest votes up vote 9 down vote accepted I have seen this error once when automating Excel. It happened when the user had a cell in editmode and you tried to automate that instance. Excel doesn't like it when you are editing a cell and some program is fiddling around in the background. So this is what's happening at your client (I think): Your client has Excel open
Error 800A03EC Thema durchsuchen Ansicht Themen-Optionen Delphi & Excel & OLE Error 800A03EC Ein Thema von p80286 · begonnen am 3. 800a03ec vbscript error Dez 2009 · letzter Beitrag vom 1. Mai 2016 Antwort 800a03ec excel saveas Seite 1 von 2 1 2 Nächste p80286 Registriert seit: 28. Apr 2008 Ort: Stolberg (Rhl) 5.035 Beiträge Delphi 7 Personal #1 Delphi & Excel & OLE Error 800A03EC 3. Dez 2009, 16:19 Hallo zusammen, Das Zusammenspiel von http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 Delphi und Excel ist ja schon des öfteren durchgekaut worden, darum muß ich da wohl nicht näher darauf eingehen. um Daten in ein Excel-Sheet zu schreiben nutze ich folgenden Code: markieren Delphi-Quellcode: for i:=0 to sg.rowcount-1 do begin for j:=0 to sg.colcount-1 do begin if forcestring then zelle:=''''+sg.cells[j,i] { das Hochkomma http://www.delphipraxis.net/144261-delphi-excel-ole-error-800a03ec.html erzwingt einen String in Excel!} else zelle:=sg.cells[j,i]; excel.activesheet.cells(i+1,j+1):=zelle; {cells1..x/1..y } end; end; Das Funktioniert auch ganz gut. In Fällen wo der OLE-Error 800A03EC auftaucht, nutze ich forcestring um Excel davon abzuhalten, die übergebenen Daten zu falsch zu interpretieren. Was natürlich dazu führt, das numerische Daten nicht mehr als solche erkannt werden. Kennt Ihr einen "offiziellen" Weg um Daten sauber an Excel zu übergeben? Gruß K-H Programme gehorchen nicht Deinen Absichten sondern Deinen Anweisungen Do it with Delphi Programming Zitat p80286 Öffentliches Profil ansehen Mehr Beiträge von p80286 finden shmia Registriert seit: 2. Mär 2004 5.508 Beiträge Delphi 5 Professional #2 Re: Delphi & Excel & OLE Error 800A03EC 3. Dez 2009, 17:21 entweder:cell.NumberFormat := '@'; oder auch: cell.EntireColumn.NumberFormat := '@'; Andreas Zitat shmia Öffentliches Profil ansehen Mehr Beiträge von shmia finden p80286 Registriert seit: 28. Apr 2008 Ort: Stolberg (Rhl) 5.035 Beiträge Delphi 7 Personal
Fast Reports forum>Fast Reports Products>FastReport 3.0 2 Pages 12> error when export a excel files Options lancelotshui View Member Profile Mar 2 2005, https://www.fast-report.com/en/forum/index.php?showtopic=1964 03:44 AM Post #1 Newbie Group: Members Posts: 4 Joined: 8-February 04 http://www.delphigroups.info/2/10/945741.html Member No.: 391 when I export the report as a excel file.it always encounter errorit said "project xxx raised exception EOleException with message 'OLE error 800A03EC'".what had happened jdorlon View Member Profile Mar 2 2005, 10:48 AM Post #2 Newbie Group: Members Posts: 7 Joined: 2-March 05 Member No.: 1764 more ole error info: I have seen this too with excel 2003, but not with prior versions. lancelotshui View Member Profile Mar 2 2005, 06:24 PM Post #3 Newbie Group: Members Posts: 4 Joined: 8-February 04 Member No.: 391 I'm using win2k advanced server + delphi 7 enterprise + offiice 2k/ AlexTZ View Member Profile Mar 4 2005, 02:12 PM Post #4 Advanced Member Group: FR ole error 800a03ec Team Posts: 2982 Joined: 16-October 03 Member No.: 4 Does this error happen when you export any report or only some kind of report? lancelotshui View Member Profile Mar 4 2005, 07:08 PM Post #5 Newbie Group: Members Posts: 4 Joined: 8-February 04 Member No.: 391 pdf,rtf,jpg,bmp are all okerror only happen in excel expor, AlexTZ View Member Profile Mar 7 2005, 04:58 AM Post #6 Advanced Member Group: FR Team Posts: 2982 Joined: 16-October 03 Member No.: 4 Please send the .fr3 and .fp3 files (.fp3 - save from preview) to tz@fast-report.com adolfo View Member Profile Mar 7 2005, 04:14 PM Post #7 Newbie Group: Members Posts: 2 Joined: 1-November 04 Member No.: 1294 I just have the same problem.Hope can be solved soon.Adolfo ftorres View Member Profile Apr 26 2005, 01:14 PM Post #8 Newbie Group: Members Posts: 4 Joined: 3-March 05 Member No.: 1771 I have the same problem for FR3 + Delphi7 on WinXP Pro ftorres View Member Profile Apr 27 2005, 08:08 AM Post #9 Newbie Group: Members Posts: 4 Joined: 3-March 05 Member No.: 1771 this worked for me: frxPrint1.PrepareReport;frxPrint1.Export(frxTXTExport);that wil
(TOraQuery) and adds the records to an excel file. This application has been working fine for the past 2 years; it uses a "select" statement with a "where" clause to create 2 differents excel files with different records from the same Oracle table. I had to change the "where" clause and now when the application creates the excel file, it gives me the error.... and only for one of the 2 files it creates... and the same code is used for both. It creates 100 rows at a time... the "batch" variable value is 100. It inserts in the excel range the first 4 batches, but when trying to inserts the row numbers 401 to 500 (Range.Value := arrdate), it give the error... While creating the first Excel file(about 2000 rows by 108 columns), I do not have a problem... but when creating the second Excel file(about 6500 rows by 144 columns), then I get the error. I am sending the code used to insert the record in the excel workbook. Any help is welcomed. H.Dumas xls:= CreateOLEObject('Excel.Application'); wb:= xls.Workbooks.Add; borneInf:= 2; borneSup:= batch + 1; //Title row for i:= 1 to Qry.FieldCount do begin wb.WorkSheets[1].Cells[1,i].Value:= Qry.Fields[i-1].DisplayName; end; while not Qry.Eof do begin for i:= 1 to batch do begin for j:= 1 to Qry.FieldCount do begin if not Qry.Eof then arrData[i,j]:= Qry.Fields[j-1].AsVariant //-1 pour rendre l'index [0..n-1] else arrData[i,j]:= ''; end; end; //End for i:= 1 to batch ... //Calcule le Range dans fichier excel Range:= wb.WorkSheets[1].Range[wb.WorkSheets[1].Cells[borneInf,1], wb.WorkSheets[1].Cells[borneSup,Qry.FieldCount]]; Range.Value:= arrData; //Prépare le Range suivant borneInf:= borneInf + batch; borneSup:= borneSup + batch; if not Qry.Eof then Qry.Next; end; //End while not OraQuery1.Eof ... 1. Invert colors2. ANN: LMD ElPack 6.04 (VCL Win32/.NET)3. Job Hunting - Working Overseas - Australia needs more skilled migrants4. DXF import and modify5. TQRChart for C++Builder 5 Build error1. Re: Update 3 - The performance update2. DH #33. Re: Delphi 2007 for Win32/GreyMatter UK Order4. So long, and thanks for all the fish!5. Installation count reset