I need assistance using Excel in my ASP.Net 3.5 application
Hi Experts,
I have an ASP.Net 3.5 application with VB.Net codebehind. The application works fine on my machine, but When I deployed it to the Web Server I got the following error:
retrieving the com class factory for component with clsid{00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154
I don't have Excel installed on my the Web Server. I have included my code so you could see how I use Excel in my application. Please tell me what's causing this error.
Partial Class BoardReportAutomation
Inherits System.Web.UI.Page
Dim objXL As Microsoft.Office.Interop.Excel.Application
Dim objWkB As Microsoft.Office.Interop.Excel.Workbook
Dim objSht As Microsoft.Office.Interop.Excel.Worksheet
Dim objRange As Microsoft.Office.Interop.Excel.Range
Protected Sub cmdFormat_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdFormat.Click
If Page.IsValid Then
Try
'OPEN EXCEL
objXL = New Microsoft.Office.Interop.Excel.Application
objWkB = objXL.Workbooks.Open(strExcel)
objSht = CType(objWkB.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)
objXL.Visible = False
Catch ex As Exception
Dim strError As String
strError = "Error Message: "
Response.Write("<script language='JavaScript'>alert('" & strError & ex.Message.ToString & "');window.location=self.location;</script>")
Exit Sub
End Try
End If
I don't have Excel installed on my the Web Server. That there is part of the problem. You are using Excel Automation and that means you MUST have Excel on the server. That is the problem with Excel Automation. The alternative is to try and use a library that allows you to generate Excel files without requiring Excel itself to be installed on the deployment server. There are several options for this. Have a look at these comments I made before:
https://www.experts-exchange.com/questions/26918336/ASP-net-host-and-download-an-Excel-2003-spreadsheet-with-macros.html?cid=1065&anchorAnswerId=35277606#a35277606