1、先导入epplus.dll
2、
string path = "wd.xlsx";//文件
using (ExcelPackage package = new ExcelPackage(new FileStream(path, FileMode.Open)))
{
DateTime dt = DateTime.Now;
Console.WriteLine(dt.ToLocalTime().ToString());//开始时间
for (int i = 1; i <= package.Workbook.Worksheets.Count; ++i)
{
ExcelWorksheet sheet = package.Workbook.Worksheets[i];
for (int j = sheet.Dimension.Start.Column, n = sheet.Dimension.End.Row; j <= n; j++)
{
string wddd = "";
for (int m = sheet.Dimension.Start.Row, k = sheet.Dimension.End.Column ; m <= k; m++)
{
// string str = GetValue(sheet, m, j);
wddd += sheet.Cells[j, m].Value.ToString();
wddd += "~";
// Console.WriteLine(j+"行");
// Console.WriteLine(m+"列");
}
Console.WriteLine(wddd);//excel每行的数据
}
}
DateTime dts = DateTime.Now;
Console.WriteLine(dts.ToLocalTime().ToString());//结束时间
}