private string SaveAs(Window winref, string filename)
{
IMessageBoxService dlg = new MessageBoxService();
//Window owner;
if (winref == null)
{
winref = Application.Current.Windows[0];
}
string result = dlg.SaveFileDlg("Select File Name to Save As", "Excel Files(*.xlsx)| *.xlsx", filename, winref);
dlg = null;
return(result);
}
private void SaveWorkbook(ref XLWorkbook _workbook)
{
try
{
IMessageBoxService dlg = new MessageBoxService();
Window owner;
owner = Application.Current.Windows[0];
string result = dlg.SaveFileDlg("Select File Name to Save As", "Excel Files(*.xlsx)| *.xlsx", owner);
if (!string.IsNullOrEmpty(result))
{
_workbook.SaveAs(result);
Process.Start(result);
_workbook.Dispose();
}
dlg = null;
}
catch (Exception e)
{
IMessageBoxService msg = new MessageBoxService();
msg.ShowMessage("The file is already open.\nPlease close or select a different file name\n" + e.Message, "File already open", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Exclamation);
msg = null;
}
}