Hi, Stephen is right, as it uses unmanaged code. May be you got issues with version compatibility. If you really have to use excel you can try out office web component (owc) which is a bit lightweight.
http://www.codeproject.com/KB/aspnet/OWCAjaxDemo.aspx Regards. On Tue, Mar 31, 2009 at 10:11 PM, Stephen Russell <[email protected]> wrote: > > I have to kick out a few loader files for another outside app from my site. > I'll give you the steps I used to NOT USE EXCEL on the server!!!! > > > > ………………………………………………………………… > Stephen Russell – > Senior Visual Studio Developer, DBA > > Memphis, TN > 901.246-0159 > > > >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of stapes >> Sent: Tuesday, March 31, 2009 3:37 AM >> To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web >> Services,.NET Remoting >> Subject: [DotNetDevelopment] Re: Generating Excel report using ASP.NET >> and C# >> >> >> Server has installed programs: >> >> Microsoft Office 2003 Web Components >> Microsoft Office 2007 Primary Interop Assemblies >> Microsoft Office Enterprise 2007 >> >> On Mar 30, 6:30 pm, "Stephen Russell" <[email protected]> wrote: >> > Office is not loaded on the server? >> > >> > ......................... >> > Stephen Russell - >> > Senior Visual Studio Developer, DBA >> > >> > Memphis, TN >> > 901.246-0159 >> > >> > >> > >> > > -----Original Message----- >> > > From: [email protected] >> > > [mailto:[email protected]] On Behalf Of stapes >> > > Sent: Monday, March 30, 2009 5:12 AM >> > > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML >> Web >> > > Services,.NET Remoting >> > > Subject: [DotNetDevelopment] Generating Excel report using ASP.NET >> and >> > > C# >> > >> > > This works OK on my development machine, but when I try to run it >> on >> > > the live server, I get this error: >> > >> > > System.Runtime.InteropServices.COMException (0x80080005): >> Retrieving >> > > the COM class factory for component with CLSID {00024500-0000-0000- >> > > C000-000000000046} failed due to the following error: 80080005 at >> > > Web_Reports_KPI.excelKPIS() in c:\inetpub\wwwroot\AGwww\Web_Reports >> > > \KPI.aspx.cs:line 67 >> > >> > > Line 67: MyExcel.Application excelApp = new >> MyExcel.ApplicationClass >> > > (); >> > >> > > MyExcel is defined at the top: using MyExcel = >> > > Microsoft.Office.Interop.Excel; >> > >> > > I also have references: Microsoft Excel 12.0 Object Library, >> Microsoft >> > > Office 10.0 Object Library, Microsoft Office 11.0 Object Libray, >> > > Microsoft Office 12 Object Library, >> Microsoft.Office.Interop.Word.dll >> > >> > > I have used Component Services / DCOM Config to set permssions for >> > > Microsoft Excel Application. In the Launch and Activation >> permissions >> > > I have added NETWORK SERVICE and Evereyone. Same for Access >> Permssions >> > > and Configuration Permissions. Did not make any difference. >> > >> > > Does anyone have any clues? >> > >> > > No virus found in this incoming message. >> > > Checked by AVG -www.avg.com >> > > Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date: >> > > 03/29/09 16:56:00- Hide quoted text - >> > >> > - Show quoted text - >> >> No virus found in this incoming message. >> Checked by AVG - www.avg.com >> Version: 8.0.238 / Virus Database: 270.11.31/2029 - Release Date: >> 03/30/09 08:40:00 > > >
