IronXL.Excel
2024.10.2
Prefix Reserved
dotnet add package IronXL.Excel --version 2024.10.2
NuGet\Install-Package IronXL.Excel -Version 2024.10.2
<PackageReference Include="IronXL.Excel" Version="2024.10.2" />
paket add IronXL.Excel --version 2024.10.2
#r "nuget: IronXL.Excel, 2024.10.2"
// Install IronXL.Excel as a Cake Addin #addin nuget:?package=IronXL.Excel&version=2024.10.2 // Install IronXL.Excel as a Cake Tool #tool nuget:?package=IronXL.Excel&version=2024.10.2
IronXL - The C# Excel Library
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
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
Licensing & Support available
For code examples, tutorials and documentation visit https://ironsoftware.com/csharp/excel/
For support please email us at support@ironsoftware.com
Documentation Links
- Code Examples : (https://ironsoftware.com/csharp/excel/examples/
- API Reference : https://ironsoftware.com/csharp/excel/object-reference/api/
- Tutorials : https://ironsoftware.com/csharp/excel/tutorials/how-to-read-excel-file-csharp/
- Licensing : https://ironsoftware.com/csharp/excel/licensing/
- Live Chat Support : https://ironsoftware.com/csharp/excel/#helpscout-support
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 | Versions 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. |
-
.NETStandard 2.0
- IronSoftware.Common (>= 2024.9.27)
- IronSoftware.System.Drawing (>= 2024.9.11)
-
.NETStandard 2.1
- IronSoftware.Common (>= 2024.9.27)
- IronSoftware.System.Drawing (>= 2024.9.11)
NuGet packages (3)
Showing the top 3 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 |
|
DYMO.LabelAPI.Mac
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
2024.10.2 | 7,591 | 10/3/2024 |
2024.9.3 | 6,360 | 9/9/2024 |
2024.8.5 | 19,141 | 7/30/2024 |
2024.7.1 | 9,034 | 7/5/2024 |
2024.6.1 | 11,841 | 6/4/2024 |
2024.5.5 | 17,057 | 5/2/2024 |
2024.4.4 | 19,333 | 4/4/2024 |
2024.3.20 | 12,173 | 3/11/2024 |
2024.2.25 | 23,937 | 1/29/2024 |
2024.1.21 | 18,297 | 12/29/2023 |
2023.12.19 | 12,352 | 12/1/2023 |
2023.11.12 | 15,911 | 10/27/2023 |
2023.10.8 | 11,688 | 10/6/2023 |
2023.9.29 | 14,243 | 8/31/2023 |
2023.8.19 | 21,514 | 7/31/2023 |
2023.7.4 | 29,338 | 7/6/2023 |
2023.6.4 | 31,370 | 5/29/2023 |
2023.5.4 | 31,134 | 5/1/2023 |
2023.4.13 | 48,590 | 3/29/2023 |
2023.2.5 | 28,859 | 2/27/2023 |
2023.1.14 | 19,962 | 1/31/2023 |
2022.12.11262 | 30,248 | 12/29/2022 |
2022.12.10926 | 20,403 | 12/8/2022 |
2022.11.10251 | 66,295 | 11/2/2022 |
2022.9.9454 | 31,612 | 9/29/2022 |
2022.8.8357 | 8,707 | 8/23/2022 |
2022.7.7362 | 41,645 | 7/13/2022 |
2022.6.6825 | 17,149 | 6/23/2022 |
2022.3.0 | 96,293 | 3/10/2022 |
2021.12.0 | 39,358 | 12/21/2021 |
2021.11.0 | 13,693 | 10/29/2021 |
2021.9.0 | 32,535 | 8/24/2021 |
2020.12.2 | 100,096 | 12/8/2020 |
2020.9.1 | 18,609 | 9/21/2020 |
2020.9.0 | 5,917 | 9/3/2020 |
2020.6.0 | 23,428 | 6/2/2020 |
2020.5.0 | 4,974 | 5/1/2020 |
2019.5.2 | 30,937 | 9/10/2019 |
2019.5.0 | 4,140 | 7/22/2019 |
2019.3.2.1 | 6,507 | 5/21/2019 |
* Updates IronSoftware.System.Drawing to version 2024.9.11