How to Read Data from Excel in C#

Or download the DLL directly here

How to Read Data from Excel in C# See All 37 Code Examples

using IronXL;
using System;
using System.Linq;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];

// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;

// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;

// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();

// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

Install-Package IronXL.Excel

Explore the code and run it to see the sample PDFs

Reading & Writing Excel Files in C#...

.NET Developer Support

Human Support

Talk directly with our development team

C# API Reference and Get Started Tutorials

Documentation

Clear online manuals in plain English.

View Documentation

C# Library Licensing

Simple Licensing

Free development license. Commercial from $749.

Install The C# Barcode library

Get Started Now

Get started in minutes with NuGet or DLL.

Install & Try Now

Now that you’ve downloaded IronXL

Want to deploy IronXL to a live project for FREE?

Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?

Test in production without watermarks

30 days fully functional product

24/5 technical support during trial

Get your free 30-day Trial Key instantly.

Thank you.
If you'd like to speak to our licensing team:

badge_greencheck_in_yellowcircle

The trial form was submitted
successfully.

Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com

Schedule a call

Have a question? Get in touch with our development team.

No credit card or account creation required

Now that you’ve downloaded IronXL

Want to deploy IronXL to a live project for FREE?

Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?

Test in production without watermarks

15 days fully functional product

24/5 technical support during trial

Get your free 15-day Trial Key instantly.

Thank you.
If you'd like to speak to our licensing team:

badge_greencheck_in_yellowcircle

The trial form was submitted
successfully.

Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com

Schedule a call

Have a question? Get in touch with our development team.

No credit card or account creation required

Want to deploy IronXL to a live project for FREE?

Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?

Test in production without watermarks

30 days fully functional product

24/5 technical support during trial

Get your free 30-day Trial Key instantly.

Thank you.
If you'd like to speak to our licensing team:

badge_greencheck_in_yellowcircle

The trial form was submitted
successfully.

Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com

Schedule a call

Have a question? Get in touch with our development team.

No credit card or account creation required

Want to deploy IronXL to a live project for FREE?

Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?

Test in production without watermarks

15 days fully functional product

24/5 technical support during trial

Get your free 15-day Trial Key instantly.

Thank you.
If you'd like to speak to our licensing team:

badge_greencheck_in_yellowcircle

The trial form was submitted
successfully.

Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com

Schedule a call

Have a question? Get in touch with our development team.

No credit card or account creation required