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

[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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"Morten Snedker" <morten_spammenot_ATdbconsult.dk> wrote in message
news:s1********************************@4ax.com...

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

[Morten Snedker]

On Tue, 14 Jun 2005 13:15:09 -0700, "Steve C. Orr [MVP, MCSD]"
<St***@Orr.net> wrote:

Just what I needed. Thank you.

/Regards

[Morten Snedker]

On Tue, 14 Jun 2005 10:46:16 +0200, Morten Snedker
<morten_spammenot_ATdbconsult.dk> wrote:

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