IRONSOFTWARE
  • PRODUCTS
  • OPEN SOURCE
  • ABOUT US
  • CONTACT US
205 N. Michigan Ave. Chicago, IL 60611, USA
+1 (312) 500-3060
Join Iron Slack

Our Company

  • About Us 
  • Company News 
  • Customers 
  • Environmental Commitments 
  • Beta Program 
  • Year in Review: 2022 

Sales Partners

  • Global Resellers 

Contact Us

  • Live Chat 
  • Send an Email 
+1 (312) 500-3060
205 N. Michigan Ave.
Chicago, IL 60611, USA

Careers at Iron

Join our teamJoin our team
We're hiring
ironpdf_logo
ironpdf_logo
for
Create, read, and edit PDFs
ironocr_logo
ironocr_logo
for
Image to text in 127 languages
ironxl_logo
ironxl_logo
for
Edit Excel & CSV Files.
No Office Interop required
ironzip_logo
ironzip_logo
for
Zip and unzip archives
ironqr_logo
ironqr_logo
for
Read & write QR codes with ML detection
ironbarcode_logo
ironbarcode_logo
for
Read and write Barcodes
ironwebscraper_logo
ironwebscraper_logo
for
Extract structured data from websites
7 for the Price of 2 Full Suite of products from $1498 Save 70% with Iron Suite
Iron Suites - Donate $50
irondrawing_logo
irondrawing_logo
for
System.Drawing.Common Replacement
ironfreetools_logo
ironfreetools_logo
Free Software Development Tools
IronXL - Excel Library for C# .NET
  • Home
  • Licensing
    • Licensing
    • EULA
    • Support & Update Extensions
    • License Upgrades
    • Start Free Trial
  • Features
  • Docs
    • Get Started
    • Code Examples
    • Tutorials
    • How-Tos
    • Troubleshooting
    • Product Updates
    • API Reference  
Search
Ctrl
K
Free NuGet DownloadTotal downloads: 615,442 Start for FreeTotal downloads: 615,442
IronXL - Excel Library for C# .NET
for
.NET
  • IRONSOFTWARE HOME
  • PRODUCTS
    • IRONSUITE

    • IRONPDF
      UPDATED
    • IRONOCR
    • IRONXL
    • IRONZIP
    • IRONQR
    • IRONBARCODE
    • IRONWEBSCRAPER
  • OPEN SOURCE
    • IRONDRAWING
    • IRONFREETOOLS
  • ABOUT US
    • About US
    • Company News
    • Environmental Commitments
    • Beta Program
    • Year in Review: 2022
    • Live Chat
    • Global Resellers
    • Join our team
  • CONTACT US
  • HOME
  • LICENSING
    • Licensing
    • EULA
    • Support & Update Extensions
    • License Upgrades

    • Start Free Trial
  • FEATURES
  • DOCS
    • Get Started
    • Code Examples
    • Tutorials
    • How-Tos
    • Troubleshooting
    • Product Updates

    • API Reference  
Message's icon

How to Read Data from Excel in C#

  1. Read Data or Excel Tutorial
  2. C# Excel Reader for C# Developers
  3. Trusted C# Excel Library
Free NuGet Download Total downloads: 615,442 Start for Free Total downloads: 615,442 Free 30-Day Trial Key Total downloads: 615,442
Start for Free Total downloads: 615,442

Or download the DLL directly here

Examples

  • How to Read Data from Excel in C#
See All 37 Code Examples
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

IronXL

Reading & Writing Excel Files in C#...

.NET Developer Support

Human Support

Talk directly with our development team

Ask a Question
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.

Browse Options
Install The C# Barcode library

Get Started Now

Get started in minutes with NuGet or DLL.

Install & Try Now
Try IronXL for Free
Get Set Up in 5 Minutes
C# NuGet Library for PDF
Install with NuGet
Version: 2023.12
Install-Package IronXL.Excel
nuget.org/packages/IronXL.Excel/
  1. In Solution Explorer, right-click References, Manage NuGet Packages
  2. Select Browse and search "IronXL"
  3. Select the package and install
C# PDF DLL
Download DLL
Version: 2023.12
Download Now
Manually install into your project
  1. Download and unzip IronXL to a location such as ~/Libs within your Solution directory
  2. In Visual Studio Solution Explorer, right click References. Select Browse, "IronXL.dll"
Licenses from $749

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

15 1000 1
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
15 1000 1
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
15 1000 1
Your Trial License Key has been emailed to you.
Not ready to buy?
Thank you.
View your license options:
Thank you.
If you'd like to speak to our licensing team:
View Licensing
Schedule a call
Have a question? Get in touch with our development team.
Have a question? Get in touch with our development team.
15 1000 1
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
15 1000 1
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
15 1000 1
Your Trial License Key has been emailed to you.
Not ready to buy?
Download IronXL free to apply
your Trial Licenses Key
Thank you.
If you'd like to speak to our licensing team:
Install with NuGet View Licensing
Schedule a call
Licenses from $749. Have a question? Get in touch.
Have a question? Get in touch with our development team.
15 1000 1
Your Trial License Key has been emailed to you.
Not ready to buy?
Download IronXL free to apply
your Trial Licenses Key
Thank you.
If you'd like to speak to our licensing team:
Install with NuGet View Licensing
Schedule a call
Licenses from $749. Have a question? Get in touch.
Have a question? Get in touch with our development team.
ironxl_for_dotnet

Get started for FREE

No credit card required

Test in a live environment

Test in production without watermarks.
Works wherever you need it to.

bullet_test

Fully-functional product

Get 30 days of fully functional product.
Have it up and running in minutes.

bullet_calendar

24/5 technical support

Full access to our support engineering team during your product trial

bullet_support
ironxl_for_dotnet

Get your free 30-day Trial Key instantly.

bullet_checkedNo credit card or account creation required

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

Trusted by Over 2 Million Engineers Worldwide

  • aetna_logo
  • wwf_logo
  • nasa_logo
  • usda_logo
  • 3m_logo
  • tesla_logo
ironxl_for_dotnet

Get started for FREE

No credit card required

Test in a live environment

Test in production without watermarks.
Works wherever you need it to.

bullet_test

Fully-functional product

Get 30 days of fully functional product.
Have it up and running in minutes.

bullet_calendar

24/5 technical support

Full access to our support engineering team during your product trial

bullet_support
ironxl_for_dotnet

Get your free 30-day Trial Key instantly.

bullet_checkedNo credit card or account creation required

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

Trusted by Over 2 Million Engineers Worldwide

  • aetna_logo
  • wwf_logo
  • nasa_logo
  • usda_logo
  • 3m_logo
  • tesla_logo
ironxl_for_dotnet

Get started for FREE

No credit card required

Test in a live environment

Test in production without watermarks.
Works wherever you need it to.

bullet_test

Fully-functional product

Get 30 days of fully functional product.
Have it up and running in minutes.

bullet_calendar

24/5 technical support

Full access to our support engineering team during your product trial

bullet_support
ironxl_for_dotnet

Get your free 30-day Trial Key instantly.

Install with NuGet
View Licensing

Licenses from $749. Have a question? Get in touch.

Trusted by Over 2 Million Engineers Worldwide

  • aetna_logo
  • wwf_logo
  • nasa_logo
  • usda_logo
  • 3m_logo
  • tesla_logo
Start for Free Free NuGet Download

Fully-functional product, get the key instantly

PM > Install-Package IronXL.Excel

IronXL for .NET

The Excel API you need, without the Office Interop hassle.

Search

CtrlK

Documentation

  • Code Examples
  • API Reference
  • How-Tos
  • Features
  • Blog
  • Credits
  • Product Brochure

Tutorials

  • Get Started
  • Read an Excel File in C#
  • Create Excel Files in .NET

Licensing

  • Buy a License
  • Support Extensions
  • Resellers
  • License Keys
  • EULA

Try IronXL Free

  • Download on NuGet
  • Download DLL

  • Start Free Trial

When you need your PDF to look like HTML, fast.

Tesseract 5 OCR in the languages you need, We support 127+.

The Excel API you need, without the Office Interop hassle.

When you need to zip and unzip archives, fast.

When you need to read, write, and style QR codes, fast.

When you need to read, write, and style Barcodes, fast.

The power you need to scrape & output clean, structured data.

The complete .NET Suite for your office.

  • IRONSUITE
  • |
  • IRONPDF
  • IRONOCR
  • IRONXL
  • IRONZIP
  • IRONQR
  • IRONBARCODE
  • IRONWEBSCRAPER
IronSoftware
205 N. Michigan Ave. Chicago, IL 60611 USA +1 (312) 500-3060
  • About Us
  • News
  • Customers
  • Careers
  • Contact Us
  • Join Iron Slack

Supporting Teamseas

Copyright © Iron Software LLC 2013-2023

  • Terms
  • Privacy

Thank you!

Your license key has been delivered to the email provided. Contact us

24-Hour Upgrade Offer:

Save 50% on a
Professional Upgrade

Go Professional to cover 10 developers
and unlimited projects.

hours

:

minutes

:

seconds

Upgrade to Professional

Upgrade

Professional

$600 USD

$299 USD


  • 10 developers
  • 10 locations
  • 10 projects
TODAY ONLY
Iron Suite

5 .NET Products for the Price of 2

IronPDF IronOCR IronXL IronBarcode IronWebscraper

Total Suite Value:

$7,192 USD

Upgrade price

TODAY
ONLY

$499 USD

After 24 Hrs

$1,098 USD