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