IronXL Features for C# .NET

IronXL is a .NET library providing developers with a fast and intuitive way to work with Excel and other spreadsheet files in C#.

There is no use of Office Interop and IronXL works on .NET Core and Azure with no special dependencies or need to install MS Office.

IronXL is a leading .NET Core and .NET Framework Excel spreadsheet library for C# and VB.NET.

Compatibility

.NET Languages

Tutorial

  • C#
  • VB.NET (Tutorial)
  • F#

Platforms

  • .NET 5 and 6,
  • .NET Core 2 and 3
  • .NET Standard 2
  • .NET Framework 4x

App Types

  • Console, Web, & Desktop

Operating Systems

IDEs

  • Microsoft Visual Studio
  • Jetbrains ReSharper & Rider

Certification

  • Microsoft Authenticode
  • DigiCert Trusted G4 Code Signing RSA4096 SHA384 2021 CA1

Workbooks

Create or Load Spreadsheets

Create Code Example   Load Code Example

Save or Export Formats

Code Example

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

System.Data Objects

Code Example

  • Import and export as DataSet or DataTable

Edit Workbooks

Worksheets

Edit Formulas

  • Works with Excel formulas
  • Recalculation on sheet edit

Sort Data

API Reference

  • Range
  • Column
  • Row

Create and Edit Charts

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

Edit Layout

Edit Worksheets

Cell Ranges

Cell Range Functions

Style Cells:

API Reference

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

Maths Functions:

Set Cell Data Formats:

API Reference

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