The C# Excel Library

IronXL is the leading C# Excel library for generating and editing Excel documents in .NET. Its user friendly API allows developers to add Excel functionality to .NET projects in minutes.

Intuitive C# & VB.NET Excel Document API
No need to install Microsoft Office or Excel Interop
Read, edit & create Excel spreadsheet files
Fully supports .NET 8, 7, 6, Core, Framework, and Azure
REQUEST QUOTE
CONTACT US

Read Excel Files without Interop

  
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;
Explore All 37 Code Examples

A C# Excel Library that prioritizes accuracy, ease of use, and speed.

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

Cross Platform Support

Designed for C#, F#, & VB.NET running on .NET 8, 7, 6, Core, Standard, or Framework

Compatibility

.NET Languages:

  • C#, VB.NET, F#

Platforms:

  • .NET 8, 7, 6 & 5
  • .NET Core 2x & 3x
  • .NET Standard 2
  • .NET Framework 4.6.2+

App types:

  • Console, Web, & Desktop

Operating Systems:

  • Microsoft Windows
  • macOS
  • Linux
  • Docker
  • Azure
  • AWS

IDEs

  • Microsoft Visual Studio
  • JetBrains ReSharper & Rider

Certification

  • Microsoft Authenticode

Workbooks

Create or Load Spreadsheets

  • XLS
  • XLSX, XSLT, XLSM
  • CSV
  • TSV

Save or Export Formats

  • XLS
  • XLSX, XSLT, XLSM
  • CSV
  • TSV
  • JSON
  • HTML
  • Binary
  • Byte Array

System.Data Objects

  • Import and export as DataSet or DataTable

Edit Workbooks

  • Metadata
  • Permissions & Passwords
  • Create and Remove Worksheets
  • Set Sheet Position
  • Set Active Tab

Worksheets

Edit Formulas:

  • Works with Excel formulas
  • Recalculation on sheet edit

Sort Data:

  • Range
  • Column
  • Row

Create and Edit Charts:

  • Area, Bar, Column, Lines, Pie, Scatter

Edit Layout:

  • Freeze Panes
  • Autosize Rows/Columns
  • Add and Remove Rows/Columns

Edit Worksheets:

  • Duplicate Worksheets
  • Protect with Password
  • Group and Ungroup
  • Add , Remove, and Extract Images

Cell Ranges

Cell Range Functions:

  • Sort
  • Trim
  • Clear
  • Copy
  • Find and Replace
  • Set Hyperlinks
  • Merge and Unmerge Cells

Style Cells:

  • Font and Size
  • Border and Alignment
  • Background Pattern
  • Conditional Formatting

Maths Functions:

  • Average and Sum
  • Min and Max

Set Cell Data Formats:

  • Text, Number, Formula, Date, Currency, Scientific, Time, Boolean, Custom Formats