Error exporting DataGrid to excel file using RenderControl

[Andres Romero]

I have a button in my html page for exporting to excel files using the
RenderControl function. When the table generated is small in rows size it
works fine, but when there are much more rows (more than 5000) the excel loss
format in the last rows mainly in Rowsan or Colspan property for the table.
This is the code I'm using

Response.Clear();
Response.Buffer=true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new
System.Web.UI.HtmlTextWriter(oStringWriter);

Page.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
Some help?

[Andres Romero]

I can't believe, it isn't the first time I need help from this newsgroup
without any answer, especially in asp.net tecnology. How can I solve problems
without help?
"Andres Romero" wrote:

I have a button in my html page for exporting to excel files using the
RenderControl function. When the table generated is small in rows size it
works fine, but when there are much more rows (more than 5000) the excel loss
format in the last rows mainly in Rowsan or Colspan property for the table.
This is the code I'm using

Response.Clear();
Response.Buffer=true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new
System.Web.UI.HtmlTextWriter(oStringWriter);

Page.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
Some help?

[Peter Bromberg [MVP]]

Beats me. Have you tried adding a "Response.Flush()" just before the
Response.End() ??
Peter

"Andres Romero" <An**********@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

I can't believe, it isn't the first time I need help from this newsgroup
without any answer, especially in asp.net tecnology. How can I solve problems without help?
"Andres Romero" wrote:

I have a button in my html page for exporting to excel files using the
RenderControl function. When the table generated is small in rows size it works fine, but when there are much more rows (more than 5000) the excel loss format in the last rows mainly in Rowsan or Colspan property for the table. This is the code I'm using

Response.Clear();
Response.Buffer=true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new
System.Web.UI.HtmlTextWriter(oStringWriter);

Page.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
Some help?

[Andres Romero]

Thanks Peter

I put the Response.Flush as you tell me but I'm still having the same bug,
some other idea?

Especifically the bug is when tranforming Rowspan with more than 280 of
value (rows) to merging rows in excel, the total rows in file is greater than
4000 or 5000

If you can help me I can send you the output web page and the excel file
exported to some e-mail. My email is an********@hotmail.com. Please I need
help.

"Peter Bromberg [MVP]" wrote:

Beats me. Have you tried adding a "Response.Flush()" just before the
Response.End() ??
Peter

"Andres Romero" <An**********@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

I can't believe, it isn't the first time I need help from this newsgroup
without any answer, especially in asp.net tecnology. How can I solve

problems

without help?
"Andres Romero" wrote:

I have a button in my html page for exporting to excel files using the
RenderControl function. When the table generated is small in rows size it works fine, but when there are much more rows (more than 5000) the excel loss format in the last rows mainly in Rowsan or Colspan property for the table. This is the code I'm using

Response.Clear();
Response.Buffer=true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new
System.Web.UI.HtmlTextWriter(oStringWriter);

Page.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
Some help?