protected override void BrowseFileExcel() { cmbWorksheet.Items.Clear(); using (var dlgOpen = new OpenFileDialog()) { // Excel file only dlgOpen.Filter = "Microsoft Excel files (*.xlsx)|*.xlsx"; dlgOpen.Title = string.Format("Import data master {0}", ImportTitle); var result = dlgOpen.ShowDialog(); if (result == DialogResult.OK) { txtPath.Text = dlgOpen.FileName; IImportExportDataBll <Golongan> importDataBll = new ImportExportDataGolonganBll(txtPath.Text, _log); if (importDataBll.IsOpened()) { var msg = "Maaf file master {0} sedang dibuka, silahkan ditutup terlebih dulu."; MsgHelper.MsgWarning(string.Format(msg, ImportTitle)); txtPath.Clear(); return; } var listOfWorksheet = importDataBll.GetWorksheets(); if (listOfWorksheet.Count > 0) { foreach (var workSheet in listOfWorksheet) { cmbWorksheet.Items.Add(workSheet); } cmbWorksheet.SelectedIndex = 0; } } } }