private void xlueSheet_EditValueChanged(object sender, EventArgs e) { try { SplashScreenManager.ShowDefaultWaitForm(); if (xlueSheet.ItemIndex >= 0) { FormatterHelper.LoadExcel(openFileDialog.FileName, xlueSheet.ItemIndex, ref _listSheetsName, ref _dtExcelData); } } catch (Exception exception) { XtraMessageBox.Show(exception.Message + "\r\n" + exception.StackTrace); } finally { SplashScreenManager.CloseDefaultWaitForm(); } }
private void xbeExcelFile_ButtonClick(object sender, ButtonPressedEventArgs e) { try { SplashScreenManager.ShowDefaultWaitForm(); if (openFileDialog.ShowDialog() != DialogResult.OK) { return; } xbeExcelFile.Text = openFileDialog.FileName; FormatterHelper.LoadExcel(xbeExcelFile.Text, 0, ref _listSheetsName, ref _dtExcelData); xlueSheet.Properties.DataSource = _listSheetsName; } catch (Exception exception) { XtraMessageBox.Show(exception.Message + "\r\n" + exception.StackTrace); } finally { SplashScreenManager.CloseDefaultWaitForm(); } }