«

Hi,
I am having a problem exporting a Datagrid to excel in asp.net. For
some reason I am getting a blank excel page. I set up in IIS the Mime for
..xls. My code is below any help would be appreciated..

Thanks

CODE:

private void ExportToExcel()
{
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.Charset = "";
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
DataGrid dg = new DataGrid();
dg.DataSource = (DataSet) Cache["dataset"];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(tw.ToString());
Response.Flush() ;
Response.Close();
}

You might want to compare your code to the sample here to see what is
different about your approach:

HOW TO: Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel

http://support.microsoft.com/default...b;en-us;317719

"Ugo" <> wrote in message
news:%...
> Hi,
> I am having a problem exporting a Datagrid to excel in asp.net.
> For
> some reason I am getting a blank excel page. I set up in IIS the Mime for
> .xls. My code is below any help would be appreciated..
>
> Thanks
>
> CODE:
>
> private void ExportToExcel()
> {
> Response.Clear();
> Response.ContentType = "application/vnd.ms-excel";
> Response.ContentEncoding = System.Text.Encoding.Default;
> Response.Charset = "";
> this.EnableViewState = false;
> StringWriter tw = new StringWriter();
> HtmlTextWriter hw = new HtmlTextWriter(tw);
> DataGrid dg = new DataGrid();
> dg.DataSource = (DataSet) Cache["dataset"];
> dg.DataBind();
> dg.RenderControl(hw);
> Response.Write(tw.ToString());
> Response.Flush() ;
> Response.Close();
> }
>
>