Exporting data from a datalist to an Excel sheet

[see07]

I

 

[mike55]

Hi A.L.

I am using the same code as yourself for taking the data stored in my datagrid an putting it in an excel file. I am however encountering a problem.

"I believe the problem is related to Microsoft Windows Service Pack 2." I have surrounded the above code with a try catch statement, and for testing purposes I threw in a "Throw Ex" statement after the catch block. From what I can figure out, the code seems to throw an exception once it reachs the final line. Any suggestions on how to prevent this error from occuring.

In addition if I transfer my code to a web server and run it, if I hit the save button, the excel file will be save to my web server?

Mike55