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

Question

Hi everyone,
I'm trying to read data from an Excel file (.xlsx) using C# and the EPPlus library. I was able to load the file, but I'm not sure how to read specific cells or loop through rows and columns properly.

Here’s a quick look at what I’ve tried:

using (var package = new ExcelPackage(new FileInfo("sample.xlsx")))
{
    ExcelWorksheet sheet = package.Workbook.Worksheets[0];
    // Not sure how to read rows/cells here
}

Can someone please guide me with a simple example of reading rows and columns using EPPlus?
Thanks in advance!

Python

sasikala s · Answer

install from NuGet Package Manager, Install-Package EPPlus using System; using System.IO; using OfficeOpenXml; class Program { static void Main() { // Set the EPPlus license context ExcelPackage.LicenseContext = LicenseContext.NonCommercial; // Path to your Excel file var filePath = @"C:\path	o\your\file.xlsx"; // Open and read the Excel file using (var package = new ExcelPackage(new FileInfo(filePath))) { ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; // First worksheet int rowCount = worksheet.Dimension.Rows; int colCount = worksheet.Dimension.Columns; for (int row = 1; row <= rowCount; row++) { for (int col = 1; col <= colCount; col++) { Console.Write($"{worksheet.Cells[row, col].Text}	"); } Console.WriteLine(); } } } }

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

Answers (1)