Excel表的操作

最新推荐文章于 2023-05-11 17:05:53 发布

linminliang

最新推荐文章于 2023-05-11 17:05:53 发布

阅读量264

点赞数

分类专栏： .net 文章标签： excel null 工具 url

本文链接：https://blog.csdn.net/linminliang/article/details/6896583

版权

.net 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

Excel.Application objApp = new Excel.Application();
objApp.DisplayAlerts = false; //注意一定要加上这句

objApp.Visible = false;
Excel.Workbooks workbooks = objApp.Workbooks;

            System.Object missing = global::System.Type.Missing;
            Excel.Workbook workbook = workbooks.Open(Server.MapPath(Url), missing, missing,
            missing, missing, missing, missing, missing, missing,
            missing, missing, missing, missing, missing, missing);

Excel.Sheets objSheets = objApp.ActiveWorkbook.Sheets;

///关闭回收

    objApp.DisplayAlerts = true;//注意一定要加上这句控制显示工具栏
                workbook.Close(false, missing, false);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
                workbook = null;

                System.Runtime.InteropServices.Marshal.ReleaseComObject(objSheets);
                objSheets = null;

                objApp.Quit();
                System.Runtime.InteropServices.Marshal.ReleaseComObject(objApp);
                objApp = null;

System.GC.Collect();