G
Guest
Hi,
I have a dataset which I bind to a datagrid on my ASPX.
I then export the datagrid to Excel and stream the file to the user by
setting the MIME Type etc etc.
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFile.xls");
However, the problem I have is that it streams it as an Excel Worksheet.
When the user clicks on Save they get "Excel WorkSheet" or "HTML Page" as
the File Types.
I need to stream this as a workbook.
Has anyone else had the same problem.
Any advice or help is much appreciated.
Thanks,
C.
I have a dataset which I bind to a datagrid on my ASPX.
I then export the datagrid to Excel and stream the file to the user by
setting the MIME Type etc etc.
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFile.xls");
However, the problem I have is that it streams it as an Excel Worksheet.
When the user clicks on Save they get "Excel WorkSheet" or "HTML Page" as
the File Types.
I need to stream this as a workbook.
Has anyone else had the same problem.
Any advice or help is much appreciated.
Thanks,
C.