WPF使用SaveFileDialog对话框保存文件 ,使用下面代码判断对话框正常关闭会报DialogResult没有OK值的错误。
if (saveFileDialog.ShowDialog() == DialogResult.OK)
使用如下代码可以解决
if (saveFileDialog.ShowDialog() == true)
完整代码如下
private void ExportToExcel_Click(object sender, RoutedEventArgs e)
{
#region 导出Excel
ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
SaveFileDialog saveFileDialog = new();
saveFileDialog.Title = "导出Excel";
saveFileDialog.RestoreDirectory = true;
saveFileDialog.FileName = "电表" + DateTime.Today.ToString("yyyy-MM-dd");
saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx";
if (saveFileDialog.ShowDialog() == true)
{
string path = saveFileDialog.FileName;
var package = new ExcelPackage();
var sheet = package.Workbook.Worksheets.Add(DateTime.Today.ToString("yyyy-MM-dd"));
sheet.Cells["A1"].LoadFromDataTable(ds.Tables[0], true);
package.SaveAs(path);
MessageBox.Show("文件已导出");
}
#endregion
}