Export to Excel. Browser setting?

[Bill E.]

I've used the following code countless times to successfully create an
excel export from a datagrid.

Protected Sub ExportToExcel(ByVal datagrid As Control)
'Create an MS Excel Response
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""

Dim oStringWriter As System.IO.StringWriter = New
System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New
System.Web.UI.HtmlTextWriter(oStringWriter)

datagrid.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter.ToString)
Response.End()
End Sub

However, for some reason on one particular project I'm only getting
the first row of results
when the browser returns with the response.

If I comment out the line

Response.ContentType = "application/vnd.ms-excel"

I receive all rows. Is there a browser directive that I'm missing?

Bill E.
Hollywood, FL

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

Hello,

I have seen a sample on the web and the code used it's a bit different,
try the sample, it should work fine:

http://www.dotnetjohn.com/articles.aspx?articleid=231

protected void btnExport_Click ( object sender, EventArgs e )

{

Response.Clear ( );

Response.AddHeader ( "content-disposition",
"attachment;filename=FileName.xls" );

Response.Charset = "";

Response.ContentType = "application/vnd.xls";

StringWriter StringWriter = new System.IO.StringWriter ( );

HtmlTextWriter HtmlTextWriter = new HtmlTextWriter ( StringWriter );

gvToExport.RenderControl ( HtmlTextWriter );

Response.Write ( StringWriter.ToString ( ) );

Response.End ( );

}

To check for more resources about generating Excel from ASP .net:

http://www.tipsdotnet.com/ArticleBlo...el&PageIndex=0


/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"Bill E." wrote:

I've used the following code countless times to successfully create an
excel export from a datagrid.

Protected Sub ExportToExcel(ByVal datagrid As Control)
'Create an MS Excel Response
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""

Dim oStringWriter As System.IO.StringWriter = New
System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New
System.Web.UI.HtmlTextWriter(oStringWriter)

datagrid.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter.ToString)
Response.End()
End Sub

However, for some reason on one particular project I'm only getting
the first row of results
when the browser returns with the response.

If I comment out the line

Response.ContentType = "application/vnd.ms-excel"

I receive all rows. Is there a browser directive that I'm missing?

Bill E.
Hollywood, FL

[Bill E.]

Braulio,

Thanks for the reply. There really is no difference between the code
you posted and what I posted except the content type, which I don't
believe is correct in your case.

I discovered that the Response.End statement was the culprit. For
whatever reason, the response was getting truncated by this, and only
when the content type was Excel. I'll have to look at it in more
depth because this has not happened before to me.

Bill