Convert DataGrid to Excel

[Guest]

Hi,
I wrote a small function, thaht converts a DataGrid to Excel from a Web-Application (C#).
Running the function with 100-200 rows it just works fine.
Starting a "special" Report produces a DataDrid with about 13650 Rows. Now the conversion to Excel does not work.
Are there any known restrictions?
The code looks like this:
<---->
private void btnExcel_Click(object sender, System.EventArgs e)
{
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter(System.Globalization.CultureInfo.CurrentCulture);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
ReportGrid.RenderControl(hw);
Response.Write(makeHTMLcode(tw.ToString()));
Response.End();
}
<---->
Thanks in advance
Patrick

 

[Rick Spiewak]

Turn off the viewstate on the datagrid before you complete the download. The
extra data kills the ability of Excel to load it. That will fix this
problem.

Hi,
I wrote a small function, thaht converts a DataGrid to Excel from a Web-Application (C#).
Running the function with 100-200 rows it just works fine.
Starting a "special" Report produces a DataDrid with about 13650 Rows. Now

the conversion to Excel does not work.