优化标准老化界面

alielie

2026-06-15 f08871fe7d148d667f2f11f80f64de71a0d9504c

 HMI.Util/ExcelHelper.cs

@@ -104,6 +104,36 @@
            }
        }

        public static void ExportExcel(string targetPath, List<string[]> rows)
        {
            IWorkbook workbook = null;
            if (targetPath.EndsWith(".xlsx"))
            {
                workbook = new XSSFWorkbook();
            }
            else if (targetPath.EndsWith(".xls"))
            {
                workbook = new HSSFWorkbook();
            }
            workbook.CreateSheet("sheet1");////新建一个工作表
            ISheet SheetOne = workbook.GetSheet("sheet1");


            for (int i = 0; i < rows.Count; i++)
            {
                IRow rowTemp = SheetOne.CreateRow(i);
                for (int j = 0; j < rows[i].Length; j++)
                {
                    rowTemp.CreateCell(j).SetCellValue(rows[i][j]);
                }
            }

            using (FileStream fs = new FileStream(targetPath, FileMode.OpenOrCreate))
            {
                workbook.Write(fs);
            }
        }


        public static List<T> ReadFromExcel<T>(string sourcePath)
        {