以下是一个完整的关闭excel进程的例子

最新推荐文章于 2023-04-23 14:29:01 发布

ycl111

最新推荐文章于 2023-04-23 14:29:01 发布

阅读量5.1k

点赞数

分类专栏： office 文章标签： excel null exception

本文链接：https://blog.youkuaiyun.com/ycl111/article/details/66021

版权

office 专栏收录该内容

8 篇文章

订阅专栏

，我刚用过，没有问题了。
Excel.Application myExcel;
Excel._Workbook myWB;
Excel._Worksheet myWS = null;
Excel.Range myRrange = null;
try
{
    myExcel = new Excel.ApplicationClass();
    myWB = (Excel._Workbook)myExcel.Workbooks.Open(file.FullName,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
}
catch(Exception e)
{
    e.ToString();
}
int SheetNum = myWB.Worksheets.Count;
if(SheetNum >0)
{
   for(int i=1;i<=SheetNum;i++)
   {
      myWS = (Excel._Worksheet)myWB.Worksheets[i];

int RowNum = myWS.UsedRange.Cells.Rows.Count;
if(RowNum >= 2)
{
     for(int j=2;j<=RowNum;j++)
     {
  myRrange = myWS.get_Range("A"+j.ToString(), "E"+j.ToString());
  Array myvalues = (Array)myRrange.Cells.Value;
     }
}
   }

//以下内容全都不能少！！
myWB.Close(false, Type.Missing, Type.Missing);
myExcel.Workbooks.Close();
myExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(myRrange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myWS);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myWB);
myWS = null;
myWB = null;
myExcel = null;
GC.Collect();