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