IronXL Features for C#.NET

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

There is no use of Office Interop and IronXL.Excel 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

  • C# (Tutorial | API Reference)
    • Read, edit and create spreadsheets in C# with Excel, MVC & ASP.NET
  • VB.NET (Tutorial | API Reference)
    • Read, edit and create spreadsheets in VB.NET with Excel, MVC & ASP.NET
  • F# (API Reference)
    • Read, edit and create spreadsheets in F# with Excel, MVC & ASP.NET

Platforms

  • .NET 5, 6 and 7 (Tutorial | API Reference), .NET Core 2, 3, and 5 (Tutorial | API Reference)
    • IronXL is available for .NET 5, 6 and 7.
    • IronXL is also available for .NET Core 2, 3, and 5.
    • The current .NET Core release supports Linux, Unix and macOS client operating systems as well as Mono and Xamarin.
    • A future release will support Xamarin mobile environments.
  • .NET Standard 2 (API Reference)
    • IronXL is compatible with .NET Standard 2.0 and 2.1.
  • .NET Framework 4x (API Reference)
    • Read, edit and create spreadsheet with .NET Framework 4.5 and upwards.

App Types

  • Console, Web, & Desktop (Tutorial | API Reference)
    • Create apps for Console, Web, and Desktop utilizing IronXL.

OS

Create any application using IronXL on Windows, Linux, macOS, Docker, Azure, and AWS

IDEs

Certification

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

Workbooks

Create or Load Spreadsheets

Create Code Example   Load Code Example

  • XLS
    • Create and load .xls file format for Microsoft Excel versions 97-2003.
  • XLSX
    • Create and load .xlsx file format for Microsoft Excel versions 2007 and later.
  • XLTX
    • Load Excel template file in the format of .xltx
  • XLSM
    • Load Excel Macro-Enabled Workbook file in the format of .xlsm
  • CSV
    • Load Comma-Separated Values file in the format of .csv
  • TSV
    • Load Tab-Separated Values file in the format of .tsv

Save or Export Formats

  • XLS (API Reference)
    • Edit, save, and export Microsoft Excel versions 97-2003 in the format of XLS.
  • XLSX, XSLT, XLSM (API Reference)
    • Edit and save XLSX, XSLT, XLSM at ease. While exporting spreadsheet to XLSX format.
  • CSV (API Reference)
    • Edit, save, and export CSV file format.
  • TSV (API Reference)
    • Edit, save, and export TSV file format.
  • JSON (API Reference)
    • Edit, save, and export JSON file format.
  • XML (API Reference)
    • Edit, save, and export XML file format.
  • HTML (Code Example | API Reference)
    • Export spreadsheet as HTML file format. Convert workbook into in code HTML string. Options to show or hide properties of Excel when converted to HTML:
    • Column header
    • Hidden columns and rows
    • Leading spaces as non-breaking
    • Row numbers
  • Binary (Code Example | API Reference)
    • Convert spreadsheet to binary representation.
  • Byte Array (Code Example | API Reference)
    • Convert spreadsheet to byte array containing spreadsheet file content.

System.Data Objects

Edit Workbooks

  • Metadata (Code Example | API Reference)
    • Add, modify and retrieve granular meta-data such as:
    • Author
    • Comments
    • Last printed date
    • Keywords and Category
    • Created and Modified date
    • Subject and Title
    • Retrieve granular meta-data such as:
    • Application name
    • Custom properties
    • Company
    • Manager
    • Template
  • Permissions & Passwords (How-To | Code Example | API Reference)
    • Open, edit and save password protected spreadsheet.
    • Encrypt Workbook with password.
  • Create Worksheets (API Reference)
  • Remove Worksheets (API Reference)
  • Set Sheet Position (API Reference)
  • Set Active Tab(API Reference)

Worksheets

Edit Formulas

Data Collection

Code Example

  • Range (API Reference)
    • Select, edit, and calculate Range in each worksheets.
  • Column (API Reference)
    • Select, edit, and calculate Column in each worksheets.
  • Row (API Reference)
    • Select, edit, and calculate Row in each worksheets.

Create and Edit Charts

  • Area, Bar, Column, Line, Pie, Scatter (Code Example | API Reference)
    • Create Area, Bar, Column, Line, Pie, and Scatter chart at ease
    • Edit chart configuration such as:
    • Title
    • Legend position

Edit Layout

Edit Worksheets

Cell Ranges

Cell Range Functions

Style Cells:

Maths Functions:

Code Example

  • Average (API Reference)
    • Calculate average of given range, row, or column.
  • Sum (API Reference)
    • Calculate total sum of given range, row, or column.
  • Min (API Reference)
    • Identify minimum number of given range, row, or column.
  • Max (API Reference)
    • Identify maximum number of given range, row, or column.

Set Cell Data Formats:

Code Example | API Reference

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