Generating Excel in ASp.NET using vb code

Generating Excel in ASp.NET using vb code

Page 1 of 1

2 Replies - 2675 Views - Last Post: 25 November 2009 - 01:35 AM Rate Topic: -----

#1 bunnyraja  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 27-April 09

Generating Excel in ASp.NET using vb code

Posted 22 November 2009 - 09:52 PM

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

Is This A Good Question/Topic? 0
  • +

Replies To: Generating Excel in ASp.NET using vb code

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: Generating Excel in ASp.NET using vb code

Posted 23 November 2009 - 08:44 AM

Do you have Office installed on your web server?

Generating Excel Report in ASP.NET 2.0
Was This Post Helpful? 0
  • +
  • -

#3 bunnyraja  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 27-April 09

Re: Generating Excel in ASp.NET using vb code

Posted 25 November 2009 - 01:35 AM

Yes Office installed in server, even though its not generating

View Postbunnyraja, 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

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1