Skip to content

Instantly share code, notes, and snippets.

@dannylloyd
Last active December 8, 2020 20:29
Show Gist options
  • Save dannylloyd/3a86a483f09631fecadc419bb8a14a97 to your computer and use it in GitHub Desktop.
Save dannylloyd/3a86a483f09631fecadc419bb8a14a97 to your computer and use it in GitHub Desktop.
Read data from Excel file using EPPLUS
var path = @"C:\Temp\Path-To-File.xlsx";
using (var pck = new OfficeOpenXml.ExcelPackage())
{
using (var stream = File.OpenRead(path))
{
pck.Load(stream);
}
var ws = pck.Workbook.Worksheets.First();
for (int rowNum = 1; rowNum <= ws.Dimension.End.Row; rowNum++)
{
var cellValue = ws.Cells[rowNum, 1].Value.ToString();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment