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