Exporting Datagrid to Excel

[Stephen Noronha]

Hi,

I found an very interesting article on converting Datagrids to Excel. I
apologize that I forgot the name of the author/article but it was very
helpful.

Problem:
it converts only the current page on the Datgrid to Excel and if there are
other pages it does not.

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

Thanks all,
Stephen

[Mark Rae]

"Stephen Noronha" <st********@hotmail.com> wrote in message
news:uL**************@TK2MSFTNGP09.phx.gbl...

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

http://www.seriousfish.com/Home.aspx

[Cowboy (Gregory A. Beamer) - MVP]

http://www.carlosag.net/Tools/ExcelX...r/Default.aspx
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Stephen Noronha" wrote:

Hi,

I found an very interesting article on converting Datagrids to Excel. I
apologize that I forgot the name of the author/article but it was very
helpful.

Problem:
it converts only the current page on the Datgrid to Excel and if there are
other pages it does not.

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

Thanks all,
Stephen

[Cowboy (Gregory A. Beamer) - MVP]

You will likely have to use the Office SDK (Yuck, at least until the .NET
bits for 2003) or use a third party component. There is a free library here:

http://www.asp.net/ControlGallery/Co...977&tabindex=2

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Stephen Noronha" wrote:

Hi,

I found an very interesting article on converting Datagrids to Excel. I
apologize that I forgot the name of the author/article but it was very
helpful.

Problem:
it converts only the current page on the Datgrid to Excel and if there are
other pages it does not.

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

Thanks all,
Stephen

[Paul Clement]

On Tue, 20 Sep 2005 10:01:09 -0700, "Stephen Noronha" <st********@hotmail.com> wrote:

¤ Hi,
¤
¤ I found an very interesting article on converting Datagrids to Excel. I
¤ apologize that I forgot the name of the author/article but it was very
¤ helpful.
¤
¤ Problem:
¤ it converts only the current page on the Datgrid to Excel and if there are
¤ other pages it does not.
¤
¤ does anyone have an article or sample code that converts all data from
¤ datagrid to Excel? i have like 10 pages and it does 1 only.

Technically not all of the data is *in* the DataGrid. You probably want to export from the
underlying data source which would be the DataSet or database.

http://www.dotnetjohn.com/articles.aspx?articleid=36
Paul
~~~~
Microsoft MVP (Visual Basic)

[Steve C. Orr]

When exporting to Excel you should turn DataGrid paging off, that way it will
export the entire underlying dataset.

Here's more info:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx

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

"Stephen Noronha" wrote:

Hi,

I found an very interesting article on converting Datagrids to Excel. I
apologize that I forgot the name of the author/article but it was very
helpful.

Problem:
it converts only the current page on the Datgrid to Excel and if there are
other pages it does not.

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

Thanks all,
Stephen

[Stephen Noronha]

Hi all,
thanks for the links to the articles and info.
Stephen

"Stephen Noronha" <st********@hotmail.com> wrote in message
news:uL**************@TK2MSFTNGP09.phx.gbl...

Hi,

I found an very interesting article on converting Datagrids to Excel. I
apologize that I forgot the name of the author/article but it was very
helpful.

Problem:
it converts only the current page on the Datgrid to Excel and if there are
other pages it does not.

does anyone have an article or sample code that converts all data from
datagrid to Excel? i have like 10 pages and it does 1 only.

Thanks all,
Stephen

[Alan Samet]

Or, you can just do it the easy way by giving a user a link to a page
that renders similar to the following -- let their copy of Excel do the
rendering:

<%@ Page Language="C#"%>
<script runat=server>
void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "application/vnd.ms-excel";
}
</script>
<table>
<tr>
<td><b>Column 1</b></td>
<td style="width: 300px;"><b>Column 2</b></td>
</tr>
<tr>
<td style="background-color: yellow; color: red;">Value</td>
<td>Another Value</td>
</tr>
</table>

-Alan