public static void ExportToExcel(DataGrid m_grid, Page _page)
{
_page.Response.Clear(); 
_page.Response.Buffer = true;
_page.Response.Charset = "BIG5"; //"GB2312"; StringBuilder m_strName = new StringBuilder();
m_strName.Append(DateTime.Now.Year.ToString()).Append(DateTime.Now.Month.ToString())
.Append(DateTime.Now.Day.ToString()).Append(DateTime.Now.Hour.ToString())
.Append(DateTime.Now.Minute.ToString()).Append(DateTime.Now.Second.ToString()); _page.Response.AppendHeader("Content-Disposition", "attachment;filename=ExportData" + m_strName.ToString() + ".xls"); _page.Response.ContentEncoding = Encoding.GetEncoding("BIG5"); // _page.Response.ContentType = "application/ms-excel"; _page.EnableViewState = false; CultureInfo m_CI = new CultureInfo("zh-hk", true); //("EN-US",true);
StringWriter m_stringWriter = new StringWriter(m_CI);
HtmlTextWriter m_htmlTextWriter = new HtmlTextWriter(m_stringWriter); //htmlTextWriter
m_grid.RenderControl(m_htmlTextWriter); _page.Response.Write(m_stringWriter.ToString()); //
_page.Response.End();
}