Convert DataGrid to Excel

[DOKOM]

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

<---->

 

[Ken Cox [Microsoft MVP]]

Maybe there's a control character or format command in the 201st row that is
throwing Excel off?

Excel should be able to accept 65,536 rows.

 

[DOKOM]

I think that the Request to render the Excel sheet is not send by the browser (IE6). After filling and showing the DataGrid the IEXPLORE-Process uses about 170 MB of Memory
When I press the "Excel" Button in my Webpage nothing happens. Neither private void btnExcel_Click () is called nor page functions like OnInit(...) or InitilaizeComponents(...)

Any more Ideas?
Thanks in advance


----- Ken Cox [Microsoft MVP] wrote: ----

Maybe there's a control character or format command in the 201st row that is
throwing Excel off

Excel should be able to accept 65,536 rows