Open Excel file with ASP.Net

[Raggie]

Gentlemen,
first of all I have a general question... is it possible to open an
excel file directly through the ASP.NET page without to install Excel
on server?
I tried something on my localhost...
this following code creates an Excel.exe instance in my TaskMgr but I
am not able to make it visible...
I debugged several times through the code. I tested ex.visible
immediately after I set it true... it was still false!!!
Private Sub btnExcel_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnExcel.Click
Dim path As String = AppSettings("Pivotpath") ' "C:\pivot\
path = path & "63.xls" 'dummy
Dim ex As Excel.Application
Dim wb As Excel.Workbook
' Dim ws As Excel.Worksheet
ex = CreateObject("Excel.Application")
wb = ex.Workbooks.Open(path)
ex.Visible = True
'wb = ex.Workbooks.Open(path)
'ws = ex.Worksheets.Item(1)
'ws.Activate()
'ex.Windows(1).Activate()
'ex.Sheets(1).visible = True
'ex.Application.Visible = True
' ex.Visible = Not ex.Visible
' ws = wb.Worksheets(1)
excontrol = True
ex.EnableEvents = False
Me.lblExControl.Text = "true"
Me.lblExControl.Visible = True
' Response.WriteFile(path)
End Sub
thx & regards
Raggie

[Ken Tucker [MVP]]

Raggie,

You should not automate excel from a web application. To display it
in the webpage navigate to the xls file.

Here is a link on how to create a spreadsheet in a web application using xml
transformations.

http://support.microsoft.com/default...b;en-us;319180

Ken
----------------
"Raggie" <ra*****@googlemail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...

Gentlemen,
first of all I have a general question... is it possible to open an
excel file directly through the ASP.NET page without to install Excel
on server?
I tried something on my localhost...
this following code creates an Excel.exe instance in my TaskMgr but I
am not able to make it visible...
I debugged several times through the code. I tested ex.visible
immediately after I set it true... it was still false!!!
Private Sub btnExcel_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnExcel.Click
Dim path As String = AppSettings("Pivotpath") ' "C:\pivot\
path = path & "63.xls" 'dummy
Dim ex As Excel.Application
Dim wb As Excel.Workbook
' Dim ws As Excel.Worksheet
ex = CreateObject("Excel.Application")
wb = ex.Workbooks.Open(path)
ex.Visible = True
'wb = ex.Workbooks.Open(path)
'ws = ex.Worksheets.Item(1)
'ws.Activate()
'ex.Windows(1).Activate()
'ex.Sheets(1).visible = True
'ex.Application.Visible = True
' ex.Visible = Not ex.Visible
' ws = wb.Worksheets(1)
excontrol = True
ex.EnableEvents = False
Me.lblExControl.Text = "true"
Me.lblExControl.Visible = True
' Response.WriteFile(path)
End Sub
thx & regards
Raggie