IronXL.Excel 2024.2.25

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
dotnet add package IronXL.Excel --version 2024.2.25
NuGet\Install-Package IronXL.Excel -Version 2024.2.25
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="IronXL.Excel" Version="2024.2.25" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add IronXL.Excel --version 2024.2.25
#r "nuget: IronXL.Excel, 2024.2.25"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install IronXL.Excel as a Cake Addin
#addin nuget:?package=IronXL.Excel&version=2024.2.25

// Install IronXL.Excel as a Cake Tool
#tool nuget:?package=IronXL.Excel&version=2024.2.25

Nuget Installs Passed windows macOS linux docker aws microsoftazure livechat

IronXL - The C# Excel Library

IronXL NuGet Trial Banner Image

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

IronXL is a library developed and maintained by Iron Software that helps C# Software Engineers to read, generate and edit Excel (and other Spreadsheet files) in .NET applications & websites.

IronXL is a fast and natural approach to work with Excel and Other Spreadsheet files in C# within .NET. With no utilization of Office Excel Interopm IronXL works well with .NET Framework, .NET Core and Azure. All without extra dependencies or the need to install MS Office.

IronXL excels at:

  • Import Data from XLS/XLSX/CSV/TSV.
  • Export Work Sheets to XLS/XLSX/CSV/TSV/JSON.
  • Encrypt and decrypt XLSX/XLSM/XLTX files with passwords.
  • Work with Spreadsheets as System.Data.DataSet and System.Data.DataTable objects.
  • Excel Formulas recalculated every time a sheet it edited.
  • Intuitive Ranges setting with a WorkSheet["A1:B10"] syntax.
  • Sort Ranges, Columns and Rows.
  • Style Cells - Font, Size, Background pattern, Border, Alignment and Number formats.
Document Formats
  • Load, Read and Edit Data: XLS, XLSX, XLST, XLSM, CSV and TSV
  • Saving and Exporting: XLS, XLSX, XLST, XLSM, CSV, TSV and JSON
  • System.Data Objects: Work with Excel Spreadsheets as System.Data.DataSet and System.Data.DataTable
Sheet Functions
  • Formulas: Works with Excel formulas and formulas recalculated every time a sheet it edited
  • Cell Data Formats: Text, Number, Formulas, Dates, Currency, Percentage, Scientific, Time and Custom Formats
  • Sorting: Ranges, Columns and Rows
  • Cell Styling: Font, Size, Background pattern, Border and Alignment

IronXL has cross platform support compatibility with:

  • .NET 8, .NET 7, .NET 6 and .NET 5, .NET Core, Standard, and Framework
  • Windows, macOS, Linux, Docker, Azure, and AWS

IronXL Cross Platform Compatibility Support Image

Additionally, our API reference and full licensing information can easily be found on our website.

Using IronXL

Installing the IronXL NuGet package is quick and easy, please install the package like this:

PM> Install-Package IronXL.Excel

Once installed, you can get started by adding using IronXL to the top of your C# code. Here is an example to get started:

using IronXL;
using System.Linq;
    
//Supported spreadsheet formats for reading include: XLSX, XLS, CSV and TSV
WorkBook workbook = WorkBook.Load("test.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();

//Select cells easily in Excel notation and return the calculated value
int cellValue = sheet["A2"].IntValue;

// Read from Ranges of cells elegantly.
foreach (var cell in sheet["A2:A10"])
{
	Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

//Calculate aggregate values such as Min, Max and Sum
decimal sum = sheet["A2:A10"].Sum();

//Linq compatible
decimal max = sheet["A2:A10"].Max(c => c.DecimalValue);

Features Table

IronXL Features Table

Licensing & Support available

For code examples, tutorials and documentation visit https://ironsoftware.com/csharp/excel/

For support please email us at support@ironsoftware.com

You can email us at support@ironsoftware.com for support directly from our code team. We offer licensing and extensive support for commercial deployment projects.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on IronXL.Excel:

Package Downloads
Usabit.Framework.Data

Framework to manage database connections and develop repositories pattern.

MepApps.Svr.Internal

Mep Apps Inc. Cloud Internals

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2024.2.25 4,247 1/29/2024
2024.1.21 5,816 12/29/2023
2023.12.19 7,114 12/1/2023
2023.11.12 9,053 10/27/2023
2023.10.8 6,662 10/6/2023
2023.9.29 8,806 8/31/2023
2023.8.19 13,933 7/31/2023
2023.7.4 18,994 7/6/2023
2023.6.4 20,816 5/29/2023
2023.5.4 20,722 5/1/2023
2023.4.13 30,397 3/29/2023
2023.2.5 23,901 2/27/2023
2023.1.14 14,536 1/31/2023
2022.12.11262 17,240 12/29/2022
2022.12.10926 18,860 12/8/2022
2022.11.10251 48,599 11/2/2022
2022.9.9454 25,733 9/29/2022
2022.8.8357 7,301 8/23/2022
2022.7.7362 35,148 7/13/2022
2022.6.6825 15,773 6/23/2022
2022.3.0 86,052 3/10/2022
2021.12.0 33,132 12/21/2021
2021.11.0 12,242 10/29/2021
2021.9.0 28,590 8/24/2021
2020.12.2 91,396 12/8/2020
2020.9.1 16,275 9/21/2020
2020.9.0 5,589 9/3/2020
2020.6.0 20,285 6/2/2020
2020.5.0 3,982 5/1/2020
2019.5.2 28,393 9/10/2019
2019.5.0 3,630 7/22/2019
2019.3.2.1 3,815 5/21/2019

* Updates IronSoftware.Common to version 2024.1.2
* Fixes a bug with a very slow execution of methods loading data from DataSets (namely LoadWorkSheetsFromDataSet methods)
* Performance improvements as a result of the above fix in many other methods that create large numbers of cells
* Fixes a bug where any style changes to a cell would cause a cell foreground color to be set to black
* IronXL.Cell.Int64Value and IronXL.Cell.Int32Value methods are obsolete and will be removed in future. Use IronXL.Cell.IntValue and IronXL.Cell.LongValue instead
* Adds IronXL.Cells.Comment class to represent cell comments wirh setters and getters for all comment properties
* Adds Comment property to IronXL.Cell class with methods to add and remove comments. Comment property is null if cell has no comment. Comments are added as invisible by default