EPPlus操作Excel

EPPlus是一个可以读写Excel的第三方插件

1.官网http://epplus.codeplex.com/

2.代码：读取Excel中某个单元格

using OfficeOpenXml;

 

 

string path = @"C:\Users\Administrator\Desktop\t1.xlsx";
FileInfo newFile = new FileInfo(path);
using (ExcelPackage pck = new ExcelPackage(newFile))
{
ExcelWorksheet ws = pck.Workbook.Worksheets[1];
Response.Write(ws.Cells["D7"].Value);

}