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