方法一

public void Data2Excel(DataTable dtData)    {        System.Web.UI.WebControls.DataGrid dgExport = null;            // 当前对话            System.Web.HttpContext curContext = System.Web.HttpContext.Current;             // IO用于导出并返回excel文件             System.IO.StringWriter strWriter = null;            System.Web.UI.HtmlTextWriter htmlWriter = null;           if (dtData != null)           {               // 设置编码和附件格式                curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=ExportStudentInfo.xls");               curContext.Response.ContentType = "application/vnd.ms-excel";               curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;               curContext.Response.Charset = "";               // 导出excel文件                strWriter = new System.IO.StringWriter();               htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);               // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid                dgExport = new System.Web.UI.WebControls.DataGrid();               dgExport.ItemDataBound += new DataGridItemEventHandler(dgExport_ItemDataBound);               dgExport.DataSource = dtData.DefaultView;               dgExport.AllowPaging = false;               dgExport.DataBind();               // 返回客户端                dgExport.RenderControl(htmlWriter);               curContext.Response.Write(strWriter.ToString());               curContext.Response.End();           }    }    void dgExport_ItemDataBound(object sender, DataGridItemEventArgs e)    {        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)        {            e.Item.Cells[3].Attributes.Add("style", "vnd.ms-excel.numberformat:@");            e.Item.Cells[5].Attributes.Add("style", "vnd.ms-excel.numberformat:@");        }    }

 方法二:

private void Data2Excel(System.Data.DataTable dtData)    {        System.Web.HttpContext curContext = System.Web.HttpContext.Current;        if (dtData != null)        {            // 设置编码和附件格式             if (curContext.Request.UserAgent.Contains("MSIE"))            {                curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("报考信息.xls", System.Text.Encoding.UTF8));            }            else            {                curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=报考信息.xls");            }            curContext.Response.ContentType = "application/vnd.ms-excel";            curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;            curContext.Response.Charset = "";            System.Text.StringBuilder sb = new System.Text.StringBuilder();            sb.Append("
     
      ");            sb.Append("
");            for (int i = 0; i < dtData.Rows.Count; i++)            {                string stuCount = dtData.Rows[i]["PersonCount"].ToString() == "" ? "0" : dtData.Rows[i]["PersonCount"].ToString();                sb.AppendFormat("
", dtData.Rows[i]["NUM"], dtData.Rows[i]["SiteName"], dtData.Rows[i]["SiteCode"], dtData.Rows[i]["CenterCount"], dtData.Rows[i]["RoomCount"], stuCount, dtData.Rows[i]["SequenceName"]);            }            sb.Append("
      
       
        
序号
        
名称
        
编码
        
数量
        
场数量
        
xuesheng数量
        
轮次信息
       
       
        
{0}
        
{1}
        
{2}
        
{3}
        
{4}
        
{5}
        
{6}
       
      
     
");            curContext.Response.Write(sb.ToString());            curContext.Response.End();        }    }