DataTable导出

 //输出

   ExcelExport(ZKEngine.Common.Help.GetStringWriter(dt,drt, labName.Text, labType.Text, labTag.Text, labCount.Text, labScore.Text, labClassName.Text, labNumberPeople.Text, labHighestScore.Text, labLowestScore.Text, labAverage.Text, labWeicy.Text), "名称");



protected void ExcelExport(StringWriter sw, string exportFileName)
    {
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        //避免文件名为乱码
        string fileName = HttpUtility.UrlEncode(exportFileName, Encoding.UTF8);
        string str = "attachment; filename=" + fileName + ".xls";

        Response.AppendHeader("Content-Disposition", str);
        Response.ContentType = "application/ms-excel";
        Response.Write(sw);
        Response.End();
    }



//将datatable中的数据进行组装，比如添加列头（这样excel文件中第一行就看到列头名称）
        public static StringWriter GetStringWriter(DataTable dt, DataTable drt, string strTrainingListName, string strTrainingType, string strTag, string strSum, string sreSumScore, string strClassName, string strSumPro, string strMax, string strMix, string strAvg, string strWeicy)
        {
            StringWriter sw = new StringWriter();
            //先写列的表头，这样保证如果没有数据也能输出列表头
            sw.Write("实训名称：" + "\t");
            sw.Write(strTrainingListName + "\t");
            sw.Write(sw.NewLine);
            sw.Write("实训类别：" + "\t");
            sw.Write(strTrainingType + "\t");
            sw.Write("拆卸/安装：" + "\t");
            sw.Write(strTag + "\t");
            sw.Write(sw.NewLine);
            sw.Write("步骤总数：" + "\t");
            sw.Write(strSum + "\t");
            sw.Write("总分：" + "\t");
            sw.Write(sreSumScore + "\t");
            sw.Write(sw.NewLine);
            sw.Write("班级：" + "\t");
            sw.Write(strClassName + "\t");
            sw.Write("参与实训人数：" + "\t");
            sw.Write(strSumPro + "\t");
            sw.Write("未参与实训人数：" + "\t");
            sw.Write(strWeicy + "\t");
            sw.Write("最高分：" + "\t");
            sw.Write(strMax + "\t");
            sw.Write("最低分：" + "\t");
            sw.Write(strMix + "\t");
            sw.Write("平均分：" + "\t");
            sw.Write(strAvg + "\t");
            sw.Write(sw.NewLine);
            sw.Write("学生姓名" + "\t");
            sw.Write("学号" + "\t");
            sw.Write("得分" + "\t");
            sw.Write(sw.NewLine);
            //如果包含数据
            if (dt != null)
            {
                //写数据
                foreach (DataRow dr in dt.Rows)
                {
                    sw.Write(dr["S_Name"].ToString() + "\t");
                    sw.Write("[" + dr["S_Number"].ToString() + "]" + "\t");
                    sw.Write(dr["TS_SCORE"].ToString() + "\t");
                    //换行
                    sw.Write(sw.NewLine);
                }
            }
            sw.Write(sw.NewLine);
            sw.Write("未参加实训的学生" + "\t");
            sw.Write(sw.NewLine);
            sw.Write("姓名" + "\t");
            sw.Write("学号" + "\t");
            sw.Write(sw.NewLine);
            if (drt != null)
            {
                foreach (DataRow drtt in drt.Rows)
                {
                    sw.Write(drtt["S_Name"].ToString() + "\t");
                    sw.Write("[" + drtt["S_Number"].ToString() + "]" + "\t");
                    sw.Write(sw.NewLine);
                }
            }
            sw.Close();
            return sw;
        }