Asp.net操作Excel (用Com方式)-优快云博客

本文介绍了一种使用ASP.NET读取Excel文件的方法，包括打开、读取指定范围内的单元格数据，并在操作完成后彻底释放相关资源，避免内存泄漏。此外，还提供了一个结束所有Excel进程的函数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

   protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                ApplicationClass app = new ApplicationClass();
                Workbook workBook = app.Workbooks.Open(@"e:\tt.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                Worksheet sheet = (Worksheet)workBook.Worksheets[1];
                Response.Write(sheet.Name + "<br/>");
                Range range = sheet.get_Range("E7:J112", Type.Missing);
                Range item = null;
                for (int row = 0; row < range.Rows.Count; row++)
                {
                    for (int col = 0; col < range.Columns.Count; col++)
                    {
                        item = (Range)range.get_Item(row, col);
                        Response.Write(item.Value2);
                        Response.Write(" | ");
                    }
                    Response.Write("<br/>");
                }
                //关闭
                app.Workbooks.Close();
                app.Quit();
                //释放
                System.Runtime.InteropServices.Marshal.ReleaseComObject(item);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(workBook);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(app);

                item = null;
                app = null;
                workBook = null;
                range = null;

                GC.Collect();
                //杀进程
                try{
                KillExcelProcess();
                }catch{}
            }
        }

        public void KillExcelProcess()
        {
            Process[] myProcesses;

            myProcesses = Process.GetProcessesByName("Excel");

            foreach (Process myProcess in myProcesses)
            {
                myProcess.Kill();
            }
        }

转载于:https://www.cnblogs.com/jmax/archive/2010/12/30/1921532.html