Download to Excel...

[leo2180]

Hey All,

I have an application that builds Excel worksheets and the application works fine, its just that it's opening on the webserver rather than to the local user. Can you help me figure out what I'm doing wrong here? Please let me know...


Thanks,
Leo2180

 

[jmeckley]

yes that's expected. if you want to user to view the workbook you need to:
1. open file stream
2. write stream to byte array
3. close stream
4. send correct content headers and byte array with response.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[leo2180]

Do you have an example? Code snipet perhaps?

 

[jmeckley]

there are plenty of examples online. google stream file to response asp.net.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[taree]

Check out this blog. It is very helpful

http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html