[bunnyraja]

Hi,

I am generating Excel in asp.net using vb.net code,
but my problem is When i am generating with localhost(http://localhost/Emp/test.aspx) the excel is generating and working fine,
and when i am generating using IP Address (http://192.111.12.1/Emp/test.aspx) , my excel is not generating.

		Dim Excel_app As Excel.Application
		Dim Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, w_sheet_source, Sheet6 As Excel.Worksheet
		Dim WorkSheetFunction As New Excel.ApplicationClass

		Excel_app = New Excel.Application
		Dim w_book As Excel.Workbook
		
		Excel_app.Workbooks.Open(Server.MapPath("Templates") & "\Sample.xls")
		Excel_app.Visible = True
		w_book = Excel_app.ActiveWorkbook

		Sheet1.Activate()
		Sheet1.Cells(6, 11) = "RAJA"
		Sheet1.Cells(7, 11) = "TEST"

Any one can help me?

very urgent

Raja

[Jayman]

Do you have Office installed on your web server?

Generating Excel Report in ASP.NET 2.0

[bunnyraja]

Yes Office installed in server, even though its not generating

bunnyraja, on 22 Nov, 2009 - 08:52 PM, said:

Hi,

I am generating Excel in asp.net using vb.net code,
but my problem is When i am generating with localhost(http://localhost/Emp/test.aspx) the excel is generating and working fine,
and when i am generating using IP Address (http://192.111.12.1/Emp/test.aspx) , my excel is not generating.

		Dim Excel_app As Excel.Application
		Dim Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, w_sheet_source, Sheet6 As Excel.Worksheet
		Dim WorkSheetFunction As New Excel.ApplicationClass

		Excel_app = New Excel.Application
		Dim w_book As Excel.Workbook
		
		Excel_app.Workbooks.Open(Server.MapPath("Templates") & "\Sample.xls")
		Excel_app.Visible = True
		w_book = Excel_app.ActiveWorkbook

		Sheet1.Activate()
		Sheet1.Cells(6, 11) = "RAJA"
		Sheet1.Cells(7, 11) = "TEST"

Any one can help me?

very urgent

Raja