export to excel

[elangovan.cse]

Hi all,
I'm exporting a datagrid to an excel file.
I'm using the following source code to export.
DataTable dt = new DataTable();


DataAccess.StoredProcedure sproc = new
DataAccess.StoredProcedure("sproc_getdata");

sproc.Run(dt);

DataGrid1.DataSource = dt;

DataGrid1.DataBind();

DataGrid1.EnableViewState = false;

DataGrid1.Visible = true;

DataGrid1.GridLines = GridLines.Both;

Response.Clear();

Response.Buffer = true;

Response.AddHeader( "Content-Disposition", "filename=File1.xls");


StringWriter stringWriter = new StringWriter();

HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);

DataGrid1.RenderControl(htmlWriter);

Response.Write(stringWriter.ToString());

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

Response.End();

Its working fine.

but there is an isuue datagrid dt contains extended language
strings (like chinese, japanese).These strings are not getting
exported to excel .
DataGrid is getting data from SQLServer2005 database. I know that
sqlserver is using utf-16 encoding for unicode character. So i've tried
to change Response.ContentEncoding to utf-16. But it is also not
working.

Can anyone help me.

 

[Mark Fitzpatrick]

An example using a datagrid is at:
http://www.c-sharpcorner.com/Code/2003/Sept/ExportASPNetDataGridToExcel.asp

I've seen others that used HTML table instead. That may work better as a
simple HTML table does not have all the extra formatting and features that a
datagrid does.

Hope this helps,
Mark Fitzpatrick