NPOI在EXCEL中追加数据

嗲猫

1. DataTable dt = (gridControl1.DataSource as DataTable).Copy();
2. string tempFile = System.IO.Path.GetTempFileName();
4. string path = AppConfig.GetValue("ImportResult");
5. System.IO.FileInfo info = new System.IO.FileInfo(path);
6. info.CopyTo(tempFile, true);
7. XSSFWorkbook workbook = new XSSFWorkbook(tempFile);
8. #region 写入杆塔位置验收对比
9. ISheet sheet = workbook.GetSheet("杆塔位置验收");
10. for (int i = 0; i < dt.Rows.Count; i++)
11. {
12.    // 第二步：创建新数据行
13.    NPOI.SS.UserModel.IRow row = sheet.CreateRow(sheet.LastRowNum + 1);
14.    NPOI.SS.UserModel.ICell cell;
15.    // 添加测试数据
16.    cell = row.CreateCell(0);
17.    //cell.CellStyle = cellStyle;
18.    cell.SetCellValue(dt.Rows[i]["塔号"].ToString());
19.    cell = row.CreateCell(1);
20.    //cell.CellStyle = cellStyle;
21.    cell.SetCellValue(dt.Rows[i]["杆塔型式"].ToString());
22.    cell = row.CreateCell(2);
23.    //cell.CellStyle = cellStyle;
24.    cell.SetCellValue(dt.Rows[i]["档距设计值"].ToString());
25.    cell = row.CreateCell(3);
26.    //cell.CellStyle = cellStyle;
27.    cell.SetCellValue(dt.Rows[i]["档距实测值"].ToString());
28.    cell = row.CreateCell(4);
29.    //cell.CellStyle = cellStyle;
30.    cell.SetCellValue(dt.Rows[i]["档距偏差值"].ToString());
31.    cell = row.CreateCell(5);
32.    //cell.CellStyle = cellStyle;
33.    cell.SetCellValue(dt.Rows[i]["档距允许偏差"].ToString());
34.    cell = row.CreateCell(6);
35.    //cell.CellStyle = cellStyle;
36.    cell.SetCellValue(dt.Rows[i]["线路转角设计值"].ToString());
37.    cell = row.CreateCell(7);
38.    //cell.CellStyle = cellStyle;
39.    cell.SetCellValue(dt.Rows[i]["线路转角实测值"].ToString());
40.    cell = row.CreateCell(8);
41.    //cell.CellStyle = cellStyle;
42.    cell.SetCellValue(dt.Rows[i]["线路转角偏差值"].ToString());
43.    cell = row.CreateCell(9);
44.    //cell.CellStyle = cellStyle;
45.    cell.SetCellValue(dt.Rows[i]["线路转角允许偏差"].ToString());
46.    cell = row.CreateCell(10);
47.    //cell.CellStyle = cellStyle;
48.    cell.SetCellValue(dt.Rows[i]["塔位高程设计值"].ToString());
49.    cell = row.CreateCell(11);
50.    //cell.CellStyle = cellStyle;
51.    cell.SetCellValue(dt.Rows[i]["塔位高程实测值"].ToString());
52.    cell = row.CreateCell(12);
53.    //cell.CellStyle = cellStyle;
54.    cell.SetCellValue(dt.Rows[i]["塔位高程偏差值"].ToString());
55.    cell = row.CreateCell(13);
56.    //cell.CellStyle = cellStyle;
57.         cell.SetCellValue(dt.Rows[i]["塔位高程允许偏差"].ToString());
59.    cell = row.CreateCell(14);
60.    //cell.CellStyle = cellStyle;
61.    cell.SetCellValue(dt.Rows[i]["直线桩位置偏移设计值"].ToString());
62.    cell = row.CreateCell(15);
63.    //cell.CellStyle = cellStyle;
64.    cell.SetCellValue(dt.Rows[i]["直线桩位置偏移实测值"].ToString());
65.    cell = row.CreateCell(16);
66.    //cell.CellStyle = cellStyle;
67.    cell.SetCellValue(dt.Rows[i]["直线桩位置偏移偏差值"].ToString());
68.    cell = row.CreateCell(17);
69.    //cell.CellStyle = cellStyle;
70.    cell.SetCellValue(dt.Rows[i]["直线桩位置偏移允许偏差"].ToString());
71.    cell = row.CreateCell(18);
72.    ICellStyle cellStyle = workbook.CreateCellStyle();
73.    if(dt.Rows[i]["是否合格"].ToString()=="合格")
74.        cellStyle.FillForegroundColor = HSSFColor.LIGHT_GREEN.index;
75.    else
76.        cellStyle.FillForegroundColor = HSSFColor.RED.index;
77.    cellStyle.FillPattern = FillPatternType.SOLID_FOREGROUND;
78.    cell.CellStyle = cellStyle;
79.    cell.SetCellValue(dt.Rows[i]["是否合格"].ToString());
80. }
81. #endregion

复制代码

来源:https://www.cnblogs.com/Caidecheng/archive/2023/02/21/17140581.html
免责声明：由于采集信息均来自互联网，如果侵犯了您的权益，请联系我们【E-Mail:cb@itdo.tech】 我们会及时删除侵权内容，谢谢合作！