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]

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

 

[Guest]

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

***************************
Think Outside the Box!
***************************

 

[Guest]

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/ControlDetail.aspx?Control=1977&tabindex=2

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

***************************
Think Outside the Box!
***************************

 

[Paul Clement]

¤ 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)

 

[Guest]

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

 

[Stephen Noronha]

Hi all,
thanks for the links to the articles and info.
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