C#操作EXCEL--使用Microsoft.Office.Interop.Excel，来自.netV1.2_microsoft.office.interop.excel 读取当前sheet页内容区域-优快云博客

本文链接：https://blog.youkuaiyun.com/ansencumt/article/details/5739824

本文介绍了一种使用Microsoft.Office.Interop.Excel库从Excel文件读取数据的方法，并提供了.NET V1.2版本中实现的具体代码示例，展示了如何打开Excel文件、获取指定单元格的数据、删除特定行以及保存更改。

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

最近的项目，遇到了一个需求，需要从EXCEL中导点数据到XML和操作一下数据库。以前没有接触过这一块，匆忙间先学点基础的，

以下这个方法是从Microsoft.Office.Interop.Excel来进行操作的，这类来自.netV1.2，代码如下：

[STAThread] static void Main(string[] args) { string path = Environment.CurrentDirectory.Replace("//bin//Debug", "") + "//excel//editvest.xls"; Microsoft.Office.Interop.Excel.Application app = null; Microsoft.Office.Interop.Excel.Workbooks wbs = null; Microsoft.Office.Interop.Excel.Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet wst = null; try { app = new Microsoft.Office.Interop.Excel.Application(); app.DisplayAlerts = false; wbs = app.Workbooks; wb = wbs.Open(path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, Type.Missing, Type.Missing, Type.Missing, Type.Missing , Type.Missing, Type.Missing, Type.Missing); //wst = (Microsoft.Office.Interop.Excel.Worksheet)wb.ActiveSheet; wst = (Microsoft.Office.Interop.Excel.Worksheet)wb.Sheets.get_Item(1); //wst.Cells.Columns.Count //wst.Name //wst.Next Microsoft.Office.Interop.Excel.Range rng1 = wst.get_Range("A20", Type.Missing); Microsoft.Office.Interop.Excel.Range rng2 = wst.get_Range("A6","B6");//删除 rng2.Select(); rng2.EntireRow.Delete(Microsoft.Office.Interop.Excel.XlDirection.xlUp); wb.Save(); Console.WriteLine("A20:{0}", rng1.Value2); Console.WriteLine("row:{0}",wst.Cells.Rows.Count); Console.WriteLine("Colomns:{0}", wst.Cells.Columns.Count); } catch { } finally { app.Quit(); app = null; wbs.Close(); wbs = null; wb = null; wst = null; } Console.ReadKey(); }