程序如下：

程序描述：该程序能够实现有大型的标题，以及表头等功能

调用方法：ToExcel(newDt, FileName);

protected void ToExcel(DataTable dt, string FileName)    {        StringBuilder sb = new StringBuilder();        sb.Append("");        sb.Append("
     
      ");        DataRow[] myRow = dt.Select();        int i = 0;        int cl = dt.Columns.Count;        //定义标题        sb.Append("
        ");        sb.Append("
");        sb.Append("
");                //定义中间标题        sb.Append("
        ");        sb.Append("
");        for (i = 0; i < cl - 2; i++)        {            sb.Append("
");        }        sb.Append("
");        sb.Append("
");        //定义字段名        sb.Append("
        ");        for (i = 0; i < cl; i++)        {            if (i == (cl - 1))            {                sb.Append("
");            }            else            {                //ls_item += dt.Columns[i].ColumnName.ToString() + "\t";                sb.Append("
");            }        }                //定义数据        foreach (DataRow row in myRow)        {            sb.Append("
        ");            for (i = 0; i < cl; i++)            {                if (i == (cl - 1))                {                    sb.Append("
");                }                else                {                    //ls_item += dt.Columns[i].ColumnName.ToString() + "\t";                    sb.Append("
");                }            }                    }        sb.Append("
      
       
        
"+ DropEnterprise.SelectedItem + "
       
       
        
" + txtStart.Text + "
        
        
" + DropEnterprise.SelectedItem + "
       
       
        
" + dt.Columns[i].ColumnName.ToString() + "
       
       
        
" + dt.Columns[i].ColumnName.ToString() + "
       
       
        
" + row[i].ToString() + "
       
       
        
" + row[i].ToString() + "
       
      
     
");        System.Web.HttpContext.Current.Response.Clear();        System.Web.HttpContext.Current.Response.Charset = "GB2312";        // System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;        // 添加头信息，为"文件下载/另存为"对话框指定默认文件名         System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" +  System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");        // 添加头信息，指定文件大小，让浏览器能够显示下载进度         // System.Web.HttpContext.Current.Response.AddHeader("Content-Length",sb.ToString());        // 指定返回的是一个不能被客户端读取的流，必须被下载         System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";        // 把文件流发送到客户端         System.Web.HttpContext.Current.Response.Write(sb.ToString());        // 停止页面的执行         System.Web.HttpContext.Current.Response.End();         }