Datagrid to Excel

[Morten Snedker]

I wish to save the data of a grid to Excel. But there is a little
twist to it:

The user should immidiatly get the "Save as.." dialog.

1. I don't wish to save the xls-file serverside.
2. I don't wish to show the xls to the user on-screen.

Is what I ask for possible? Or am I missing out on a more proper
approach?

Help is greatly appreciated. Thx in advance.


Regards /Snedker

 

[Guest]

To show excel on-screen, you can have

Response.AddHeader("content-disposition", "inline; filename=" +
"yourExcelFile.xls");

HTH

Elton Wang
(e-mail address removed)

 

[Steve C. Orr [MVP, MCSD]]

There are a variety of ways to export ASP.NET content to Excel.
The DataGrid technique described in this article meets your requirements:
http://SteveOrr.net/articles/ExcelExport.aspx

Here's another option worth browsing:
http://SteveOrr.net/articles/ExportPanel.aspx

 

[Morten Snedker]

On Tue, 14 Jun 2005 13:15:09 -0700, "Steve C. Orr [MVP, MCSD]"

Just what I needed. Thank you.

/Regards

 

[Morten Snedker]

I ended up with a XML-document that i simply gave the XLS-extension..
bit of a cheat, but it works like a charm ;-)

Regards /Snedker