/// <summary> /// 加载Excel /// </summary> public bool Load() { try { _stream = new FileStream(ExcelPath, FileMode.Open, FileAccess.Read); if (ExcelPath.IndexOf(".xlsx") > 0) { _workbook = new XSSFWorkbook(_stream); } else if (ExcelPath.IndexOf(".xls") > 0) { _workbook = new HSSFWorkbook(_stream); } else { string extension = Path.GetExtension(ExcelPath); throw new Exception($"未支持的Excel文件类型 : {extension}"); } for (int i = 0; i < _workbook.NumberOfSheets; i++) { ISheet sheet = _workbook.GetSheetAt(i); if (sheet.SheetName.StartsWith(ConstDefine.StrSheetLogo)) { SheetData sheetData = new SheetData(sheet.SheetName); sheetData.Load(_workbook, sheet); SheetDataList.Add(sheetData); } } // 如果没有找到有效的工作页 if (SheetDataList.Count == 0) { throw new Exception($"没有发现包含 {ConstDefine.StrSheetLogo} 的页签"); } } catch (Exception ex) { MessageBox.Show($"表格[{ExcelName}]加载错误:{ex}"); return(false); } return(true); }