C# 数据窗口保存EXCEL文件的异常处理
代码如下,保存EXCEL文件的时候,已有同名文件且文件被打开,程序就会出错。
请问如何加个判断RETURN,避免出错。
string strFile = savefile;
//xbook.SaveAs(strFile, Type.Missing, "", "", Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, 1, false, Type.Missing, Type.Missing, Type.Missing);
//bool fileSaved = false;
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xlsx";
saveDialog.Filter = "Excel文件|*.xlsx";
saveDialog.FileName = strFile;
saveDialog.ShowDialog();
strFile = saveDialog.FileName;
if (saveDialog.FileName.IndexOf(":") < 0)
{
return; //被点了取消
xbook.Close(false, Missing.Value, Missing.Value);
xbook = null;
excel.Quit();
excel = null;
GC.Collect();
}
else
{
xbook.SaveAs(strFile, Type.Missing, "", "", Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, 1, false, Type.Missing, Type.Missing, Type.Missing);
xbook.Close(false, Missing.Value, Missing.Value);
xbook = null;
excel.Quit();
excel = null;
GC.Collect();
MessageBox.Show("保存成功!"); return;
}