C# 获取Excel文件中某个单元格的内容

来源:互联网 发布:unity3d 官方换装demo 编辑:程序博客网 时间:2024/06/05 01:06
     
  ///<summary>       /// 获取指定文件的指定单元格内容      ///</summary>       /// <paramname="fileName">文件路径</param>       /// <paramname="row">行号</param>       /// <paramname="column">列号</param>       ///<returns>返回单元指定单元格内容</returns>       public string getExcelOneCell(string fileName,int row, int column)       {          Microsoft.Office.Interop.Excel.Application app = newApplication();           Workbookwbook = app.Workbooks.Open(fileName, 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);           WorksheetworkSheet = (Worksheet)wbook.Worksheets[1];           stringtemp = ((Range)workSheet.Cells[row, column]).Text.ToString();          wbook.Close(false, fileName, false);          app.Quit();          NAR(app);          NAR(wbook);          NAR(workSheet);           returntemp;       }      //此函数用来释放对象的相关资源       private void NAR(Object o)       {           try           {              //使用此方法,来释放引用某些资源的基础 COM对象。 这里的o就是要释放的对象             System.Runtime.InteropServices.Marshal.ReleaseComObject(o);                       }           catch {}          finally           {              o = null; GC.Collect();           }       }

0 0
原创粉丝点击