i want to open an excel workbook on the server thorough asp.net dump data
from a database and save it on the server and then allow the user to either
open or save that xls file. i am using the following code:
xlWorkBook = New Excel.Application().Workbooks.Open(path, Type.Missing,
False, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing) 'to open
xlWorkSheet = xlWorkBook.Worksheets("EffortsData") 'to get worksheet object
of a particular worksheet
xlWorkSheet.SaveAs(path, Type.Missing, Type.Missing, Type.Missing, False,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing) 'to save

while debugging code on the server and on my local machine it runs perfectly
fine but while connecting through the website it gets stuck and gives no
error.
please help

Since you're writing about .NET code, you probably want to ask this in
a .NET forum, such as

microsoft.public.dotnet.general


--JP

On Sep 18, 7:50*am, Nilesh_nick
wrote:
i want to open an excel workbook on the server thorough asp.net *dump data
from a database and save it on the server and then allow the user to either
open or save that xls file. i am using the following code: