public static void DataTableToExcel(System.Data.DataTable dtData, String FileName)    {        　　GridView dgExport = null;        　   HttpContext curContext = HttpContext.Current;        　　StringWriter strWriter = null;        　　HtmlTextWriter htmlWriter = null;        　　if (dtData != null)        　　 {            　　　　 HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8);             curContext.Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");            curContext.Response.ContentType = "application/vnd.ms-excel";            curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7");            curContext.Response.Charset = "GB2312";            strWriter = new StringWriter();            htmlWriter = new HtmlTextWriter(strWriter);             dgExport = new GridView();            dgExport.RowDataBound += (GridViewFormat); //在GridView绑定数据时，将数据格式化            dgExport.DataSource = dtData.DefaultView;            dgExport.AllowPaging = false;            dgExport.DataBind();            dgExport.RenderControl(htmlWriter);            curContext.Response.Write(strWriter.ToString());            curContext.Response.End();         }} protected static void GridViewFormat(object sender, GridViewRowEventArgs e)    {        　  　 //1）  文本：vnd.ms-excel.numberformat:@        //2）  日期：vnd.ms-excel.numberformat:yyyy/mm/dd        //3）  数字：vnd.ms-excel.numberformat:#,##0.00        //4）  货币：vnd.ms-excel.numberformat:￥#,##0.00        //5）  百分比：vnd.ms-excel.numberformat: #0.00%        for (int i = 0; i < e.Row.Cells.Count; i++)        {            if (e.Row.RowType == DataControlRowType.DataRow)　　　　{                e.Row.Cells[i].Attributes.Add("style", "vnd.ms-excel.numberformat:@");　　　　}        }    }