生成有樣式的excel文檔，不過再次讀入數據的時候要另存一下哦

最新推荐文章于 2023-08-15 15:28:45 发布

ShulingLiu

最新推荐文章于 2023-08-15 15:28:45 发布

阅读量617

点赞数

分类专栏： c# 文章标签： excel string 工作

本文链接：https://blog.csdn.net/ShulingLiu/article/details/6257099

版权

c# 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

private void GenerateErrorFile(DataTable dt, string FileName) { HttpResponse resp; resp = Page.Response; resp.Charset = "utf-8"; resp.Buffer = true; resp.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); resp.ContentType = "application/ms-excel"; StringBuilder sb = new StringBuilder(); string colHeaders = ""; colHeaders = @" 序號 ID 工號姓名工作能力（A）50％工作態度（B）40% 簽核主管工號簽核主管姓名錯誤信息 "; colHeaders += @""; DataTable dtScore = Get_ScoreHead(); for (int i = 0; i < dtScore.Rows.Count; i++) { colHeaders += @"" + dtScore.Rows[i]["ab_item"] + ""; } colHeaders += @""; for (int j = 0; j < dtScore.Rows.Count; j++) { colHeaders += @"" + dtScore.Rows[j]["ab_stand_score"] + ""; } colHeaders += @""; sb.Append("

"); sb.Append(colHeaders); for (int i = 0; i < dt.Rows.Count; i++) { if (i % 2 == 0) { sb.Append("

"); sb.Append((i + 1) + "

"); sb.Append(dt.Rows[i][1].ToString() + "

"); sb.Append(dt.Rows[i][2].ToString() + "

"); sb.Append(dt.Rows[i][3].ToString() + "

"); sb.Append(dt.Rows[i][4].ToString() + "

"); sb.Append(dt.Rows[i][5].ToString() + "

"); sb.Append(dt.Rows[i][6].ToString() + "

"); sb.Append(dt.Rows[i][7].ToString() + "

"); sb.Append(dt.Rows[i][8].ToString() + "

"); sb.Append(dt.Rows[i][9].ToString() + "

"); sb.Append(dt.Rows[i][10].ToString() + "

"); sb.Append(dt.Rows[i][11].ToString() + "

"); sb.Append(dt.Rows[i][12].ToString() + "

"); sb.Append(dt.Rows[i][13].ToString() + "

"); sb.Append(dt.Rows[i][14].ToString() + "

"); sb.Append(dt.Rows[i][15].ToString() + "

"); sb.Append(dt.Rows[i][16].ToString() + "

"); sb.Append(dt.Rows[i][17].ToString()); sb.Append("

"); } else { sb.Append("