private IWorkbook workbook = null; //新建IWorkbook對象 public NewProcessOrderPage() { InitializeComponent(); string fileName = string.Concat(AppSettingConfig.ProcessOrderFilePath(), AppSettingConfig.ProcessOrderFileName()); try { FileStream fileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read); workbook = new XSSFWorkbook(fileStream); //xlsx數據讀入workbook var processOrderSheet = new List <string>(); for (int sheetCount = 0; sheetCount < workbook.NumberOfSheets; sheetCount++) { ISheet sheet = workbook.GetSheetAt(sheetCount); //獲取第i個工作表 if (!sheet.SheetName.Contains("HY")) { continue; } processOrderSheet.Add(sheet.SheetName); } ComboBoxProcessOrderSheet.ItemsSource = processOrderSheet; } catch (Exception ex) { MessageBox.Show(ex.Message); } }