How to Read Data from Excel File in C# Using EPPlus?

Use ExcelPackage from EPPlus:

using (var package = new ExcelPackage(new FileInfo("file.xlsx")))
{
    var worksheet = package.Workbook.Worksheets[0];
    var value = worksheet.Cells[1, 1].Text; // Read cell A1
}

Try this code:

using (var package = new ExcelPackage(new FileInfo("your_file.xlsx")))
{
    var worksheet = package.Workbook.Worksheets[0];

    int startRow = worksheet.Dimension.Start.Row;
    int endRow = worksheet.Dimension.End.Row;
    int startColumn = worksheet.Dimension.Start.Column;
    int endColumn = worksheet.Dimension.End.Column;

    for (int row = startRow; row <= endRow; row++)
    {
        for (int col = startColumn; col <= endColumn; col++)
        {
            var cellValue = worksheet.Cells[row, col].Text;
            Console.WriteLine($"Row {row}, Col {col}: {cellValue}");
        }
    }
}

Keep in mind that EPPlus does not support the old .xls format. If you wish to read data from both .xls and .xlsx files, you can use the following approach provided by Spire.XLS library:

PM> Install-Package Spire.XLS

using Spire.Xls;

namespace ReadExcelData
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook object
            Workbook wb = new Workbook();

            //Load an existing Excel file
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\NewSpreadsheet.xlsx");

            //Get the first worksheet
            Worksheet sheet = wb.Worksheets[0];

            //Get the cell range containing data
            CellRange locatedRange = sheet.AllocatedRange;

            //Iterate through the rows
            for (int i = 0;i < locatedRange.Rows.Length;i++)
            {
                //Iterate through the columns
                for (int j = 0; j < locatedRange.Rows[i].ColumnCount; j++)
                {
                    //Get data of a specific cell
                    Console.Write(locatedRange[i + 1, j + 1].Value + "  ");

                }
                Console.WriteLine();            
            }
        }
    }
}

Try this approach

for (int row = 2; row <= worksheet.Dimension.End.Row; row++)
{
    string name = worksheet.Cells[row, 1].Text;
    string email = worksheet.Cells[row, 2].Text;
    Console.WriteLine($"Name: {name}, Email: {email}");
}