private void ImportDataFromExcelFile() { var dialog = new OpenFileDialog() { Filter = "Excel Files(*.xlsx)|*.xlsx|All(*.*)|*" }; if (dialog.ShowDialog() == true) { DataTable tempTable; bool importResult = ExcelProvider.Import(out tempTable, dialog.FileName); BBCodeBlock codeBlock = new BBCodeBlock(); if (importResult) { codeBlock.BBCode = string.Format("Succesfully imported excel {0} model data.\nFile: {1}.\n[color=Green]Load data?[/color]", ModelInfoSelected.ModelName, dialog.FileName); var dlg = new ModernDialog { Title = "Import Excel Data", Content = codeBlock }; dlg.Buttons = new[] { dlg.YesButton, dlg.NoButton }; bool?result = dlg.ShowDialog(); if (result != null && result.Value) { ModuleItems = tempTable; } } else { codeBlock.BBCode = string.Format("Error importing excel {0} model data.\nFile: {1}.\n[color=Red]Please try again.[/color]", ModelInfoSelected.ModelName, dialog.FileName); var dlg = new ModernDialog { Title = "Import Excel Data", Content = codeBlock }; dlg.Buttons = new[] { dlg.OkButton }; dlg.ShowDialog(); } } }