NPOI将某个程序段耗时插入Excel_npoi导出excel-CSDN博客

本文链接：https://blog.csdn.net/qq_41375318/article/details/119083318

本文介绍了一个使用NPOI库在C#中生成Excel文件的方法，具体实现为将程序运行时间数据写入到指定的Excel表格中，并确保表格格式整齐。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

NPOI将某个程序段耗时插入Excel

        public void GenCaptureRunTimeExcel(string ProStart, string ProEnd, string ProDuration)
        {
            try
            {

                /****
                 * 1.判断"./TempData/CaptureRunTime.xls"是否存在
                 * 2.如果存在，则计算有多少行
                 * 3.在创建下一行插入内容
                 * ***/
                /***
                 * 1.建表
                 * ***/
                HSSFWorkbook wk = new HSSFWorkbook();
                ISheet capture_run_time_sheet = wk.CreateSheet("CaptureRunTime");


                /***
                 * 2.定义单元格格式
                 * ***/
                ICellStyle style_1 = wk.CreateCellStyle();
                style_1.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
                style_1.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
                for (int i = 0; i < 100; i++)
                {
                    capture_run_time_sheet.SetColumnWidth(i, 23 * 256);
                }

                /***
                * 3.插入内容
                ***/
                IRow dataRow;
                ICell cell;
                dataRow = capture_run_time_sheet.CreateRow(0);
                cell = dataRow.CreateCell(0);
                cell.SetCellValue("ProStart");
                cell.CellStyle = style_1;
                cell = dataRow.CreateCell(1);
                cell.SetCellValue("ProEnd");
                cell.CellStyle = style_1;
                cell = dataRow.CreateCell(2);
                cell.SetCellValue("ProDuration");
                cell.CellStyle = style_1;

                dataRow = capture_run_time_sheet.CreateRow(1);
                cell = dataRow.CreateCell(0);
                cell.SetCellValue(ProStart);
                cell.CellStyle = style_1;
                cell = dataRow.CreateCell(1);
                cell.SetCellValue(ProEnd);
                cell.CellStyle = style_1;
                cell = dataRow.CreateCell(2);
                cell.SetCellValue(ProDuration);
                cell.CellStyle = style_1;

                /***
                 * 4.保存Excel
                 * ***/
                using (FileStream fs = File.OpenWrite("./TempData/CaptureRunTime.xls"))
                {
                    wk.Write(fs);
                }


            }
            catch (Exception exp)
            {
                MessageBox.Show("插入CaptureRunTime失败"+"--失败原因："+exp.Message);
            }
        }