IronXL - The C# Excel Library

Get Started | Features | Code Examples | Licensing | Free Trial

IronXL is a robust C# library developed by Iron Software for managing and interacting with Excel and other spreadsheet files within .NET projects. It enables developers to read, create, and manipulate spreadsheet documents directly from their applications without needing to install Microsoft Office, and it's fully compatible with .NET, .NET Core, and Azure platforms.

Core Capabilities of IronXL:

• Data import from formats including XLS, XLSX, CSV, and TSV.
• Export data to formats like XLS, XLSX, CSV, TSV, and JSON.
• Excel file encryption and decryption.
• Operate on Excel sheets as System.Data.DataSet and System.Data.DataTable.
• Automatic recalculation of formulas upon modifications.
• Simple cell reference syntax like WorkSheet["A1:B10"].
• Sorting capabilities for ranges, columns, and rows.
• Extensive cell formatting options such as font, background, border styles, and alignment.

Document Management

• Supported Formats for Loading and Editing: XLS, XLSX, XLSM, XLST, CSV, TSV
• Formats for Saving and Exporting: XLS, XLSX, XLSM, XLST, CSV, TSV, JSON
• System.Data Integration: Manage spreadsheets as System.Data.DataSet and System.Data.DataTable

Spreadsheet Operations:

• Formula Management: Seamless integration and automatic updates of Excel formulas.
• Data Formatting: Extensive options including text, number, date, currency, and custom formats.
• Advanced Sorting and Cell Styling: Customize cell appearance and spreadsheet structure.

Cross-Platform Compatibility:

• Supports .NET 8 and earlier versions, .NET Core, Standard, Framework
• Compatible with Windows, macOS, Linux, Docker, Azure, and AWS environments

Discover more about our API and complete licensing details on our website.

Getting Started with IronXL:

To integrate IronXL into your project, simply install the NuGet package:

PM> Install-Package IronXL.Excel

To jumpstart your project, add using IronXL to your C# files. Here’s an initiation example:

using IronXL;
using System.Linq;

// Read various spreadsheet formats:
WorkBook workbook = WorkBook.Load("test.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();

// Fetch a specific cell using Excel-like syntax:
int cellValue = sheet["A2"].IntValue;

// Elegantly access and read range of cells:
foreach (var cell in sheet["A2:A10"]) {
    Console.WriteLine($"Cell {cell.AddressString} has value '{cell.Text}'");
}

// Use LINQ to compute aggregates:
decimal sum = sheet["A2:A10"].Sum();
decimal max = sheet["A2:A10"].Max(c => c.DecimalValue);

Features and Licensing

For more code samples, tutorials and detailed documentation, visit https://ironsoftware.com/csharp/excel/

For detailed support, contact us via [email protected].

Helpful Resources

• Code Samples: https://ironsoftware.com/csharp/excel/examples/
• API Documentation: https://ironsoftware.com/csharp/excel/object-reference/api/
• Tutorials: https://ironsoftware.com/csharp/excel/tutorials/how-to-read-excel-file-csharp/
• Licensing Information: https://ironsoftware.com/csharp/excel/licensing/
• Live Chat Assistance: https://ironsoftware.com/csharp/excel/#helpscout-support

For questions or direct assistance, please email [email protected]. We provide comprehensive support and licensing options for your commercial projects.