如何捕捉excel的异常?急~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
try
{
Exworkbooks = ExcelApp.Workbooks.Open(strFileName, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing, refmissing);
return true;
}
catch
{
MessageBox.Show("打开excel表路径错误!");
return false;
}
这是一段打开excel workbooks的程序,当要打开的excel表不存在时会触发异常,此时我能够捕捉到.但如果要打开的excel表存在,但格式不对时,就会先弹出一个"关于格式说明的...."对话框,然后才是catch捕捉到的Messagebox对话框, 我想不出现那个"关于格式说明的...."对话框,直接出现Messagebox对话框,各位有什么好的方法吗?谢谢!