FileInfo fi = new FileInfo(@"D:\OneDrive\data.xlsx");
using (ExcelPackage excelPackage = new ExcelPackage(fi))
{
ExcelWorksheet data = excelPackage.Workbook.Worksheets[0];
var start = data.Dimension.Start;
var end = data.Dimension.End;
for (int row = start.Row + 1; row <= end.Row; row++)
{
var username = data.Cells[row, 2].Text.Trim();
var password = data.Cells[row, 3].Text.Trim();
// do something
}
Sample code i use:
FileInfo fi = new FileInfo(@"D:\OneDrive\data.xlsx");
using (ExcelPackage excelPackage = new ExcelPackage(fi))
{
ExcelWorksheet data = excelPackage.Workbook.Worksheets[0];
var start = data.Dimension.Start;
var end = data.Dimension.End;
for (int row = start.Row + 1; row <= end.Row; row++)
{
var username = data.Cells[row, 2].Text.Trim();
var password = data.Cells[row, 3].Text.Trim();
// do something
}