Ho installato nella gac l'assembly Microsoft.Office.Interop.Excel.dll del mio pc window 7 con visual studio 2005 Pro, ho generato la classe e i metodi per esportare in xls il risultato di un datareader.
Funziona perfettamente.

Quando pubblico il proggetto sul server windows 2008 R2 64 bit il metodo genera il seguente errore.
Sul server ho utilizzato la stessa procedura per registrare nella Gac l'assembly.


System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.
at Inet.Microsoft.Excel.Reports.RubricaExportXls()
at _Station.ExportExcelLK_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.voip_station_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\ea46b669\f8a44709\App_Web_q_eqy86r.4.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean

Come ultima ratio ho installato excel sul server ma il risultato è sempre lo stesso:

System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.


Qui ci vuole l'aiuto del magico Bochicchio

---

Modificato da dotnet72 il 06 novembre 2012 23.02 -