//输出
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;
}
DataTable导出
最新推荐文章于 2022-06-17 13:59:55 发布