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);
}
}