Info:
original Env: VS2005 with Office 2003 using Microsoft.Offic e.Interop.Excel (11.0)
Have upgraded to
VS2008 with office 2007 still using library Microsoft.Offic e.Interop.Excel (11.0)
Ok, I have a simple class that exports data into excel worksheets. It copys an existing workbook, and loops to create around 75 worksheets. This works perfectly under XP(both office 2003 & 2007) but not in Windows 2003 with Office 2003. It works with office 2007, but not 2003. It works when creating less that 37 worksheets, but it dies on the 38th worksheet with the following error.
Event Type: Error
Event Source: Metadata.Report s
Event Category: None
Event ID: 0
Date: 2/11/2008
Time: 10:26:41 AM
User: N/A
Computer: d20092
Description:
Error
Class: ReportForm.cs
Method: LoadExcelTest_V 2()
Error Detail:
System.Runtime. InteropServices .COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Offic e.Interop.Excel .WorkbookClass. SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPasswor d, Object ReadOnlyRecomme nded, Object CreateBackup, XlSaveAsAccessM ode AccessMode, Object ConflictResolut ion, Object AddToMru, Object TextCodepage, Object TextVisualLayou t, Object Local)
at Metadata.Report s.ReportForm.Lo adExcelTest_V2( ) in C:\MetadataMana ger_V2_01-02-2008\Metadata.R eports\ReportFo rm.cs:line 581
Stack Trace:
at Microsoft.Offic e.Interop.Excel .WorkbookClass. SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPasswor d, Object ReadOnlyRecomme nded, Object CreateBackup, XlSaveAsAccessM ode AccessMode, Object ConflictResolut ion, Object AddToMru, Object TextCodepage, Object TextVisualLayou t, Object Local)
at Metadata.Report s.ReportForm.Lo adExcelTest_V2( ) in C:\MetadataMana ger_V2_01-02-2008\Metadata.R eports\ReportFo rm.cs:line 581
For more information, see Help and Support Center at http://go.microsoft.co m/fwlink/events.asp.
original Env: VS2005 with Office 2003 using Microsoft.Offic e.Interop.Excel (11.0)
Have upgraded to
VS2008 with office 2007 still using library Microsoft.Offic e.Interop.Excel (11.0)
Ok, I have a simple class that exports data into excel worksheets. It copys an existing workbook, and loops to create around 75 worksheets. This works perfectly under XP(both office 2003 & 2007) but not in Windows 2003 with Office 2003. It works with office 2007, but not 2003. It works when creating less that 37 worksheets, but it dies on the 38th worksheet with the following error.
Event Type: Error
Event Source: Metadata.Report s
Event Category: None
Event ID: 0
Date: 2/11/2008
Time: 10:26:41 AM
User: N/A
Computer: d20092
Description:
Error
Class: ReportForm.cs
Method: LoadExcelTest_V 2()
Error Detail:
System.Runtime. InteropServices .COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Offic e.Interop.Excel .WorkbookClass. SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPasswor d, Object ReadOnlyRecomme nded, Object CreateBackup, XlSaveAsAccessM ode AccessMode, Object ConflictResolut ion, Object AddToMru, Object TextCodepage, Object TextVisualLayou t, Object Local)
at Metadata.Report s.ReportForm.Lo adExcelTest_V2( ) in C:\MetadataMana ger_V2_01-02-2008\Metadata.R eports\ReportFo rm.cs:line 581
Stack Trace:
at Microsoft.Offic e.Interop.Excel .WorkbookClass. SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPasswor d, Object ReadOnlyRecomme nded, Object CreateBackup, XlSaveAsAccessM ode AccessMode, Object ConflictResolut ion, Object AddToMru, Object TextCodepage, Object TextVisualLayou t, Object Local)
at Metadata.Report s.ReportForm.Lo adExcelTest_V2( ) in C:\MetadataMana ger_V2_01-02-2008\Metadata.R eports\ReportFo rm.cs:line 581
For more information, see Help and Support Center at http://go.microsoft.co m/fwlink/events.asp.