ClosedXML 0.102.2
Prefix ReservedSee the version list below for details.
dotnet add package ClosedXML --version 0.102.2
NuGet\Install-Package ClosedXML -Version 0.102.2
<PackageReference Include="ClosedXML" Version="0.102.2" />
paket add ClosedXML --version 0.102.2
#r "nuget: ClosedXML, 0.102.2"
// Install ClosedXML as a Cake Addin #addin nuget:?package=ClosedXML&version=0.102.2 // Install ClosedXML as a Cake Tool #tool nuget:?package=ClosedXML&version=0.102.2
See release notes for 0.102.0: https://github.com/ClosedXML/ClosedXML/releases/tag/0.102.0
See release notes for 0.102.1: https://github.com/ClosedXML/ClosedXML/releases/tag/0.102.1
See release notes for 0.102.2: https://github.com/ClosedXML/ClosedXML/releases/tag/0.102.2
Description
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
For more information see the documentation or the wiki.
Install ClosedXML via NuGet
If you want to include ClosedXML in your project, you can install it directly from NuGet
To install ClosedXML, run the following command in the Package Manager Console
PM> Install-Package ClosedXML
What can you do with this?
ClosedXML allows you to create Excel files without the Excel application. The typical example is creating Excel reports on a web server.
Example:
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("Sample Sheet");
worksheet.Cell("A1").Value = "Hello World!";
worksheet.Cell("A2").FormulaA1 = "=MID(A1, 7, 5)";
workbook.SaveAs("HelloWorld.xlsx");
}
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
- DocumentFormat.OpenXml (>= 2.16.0 && < 3.0.0)
- ExcelNumberFormat (>= 1.1.0)
- SixLabors.Fonts (>= 1.0.0)
- System.Buffers (>= 4.5.1)
- System.IO.Packaging (>= 6.0.0)
- System.Memory (>= 4.5.4)
- System.Net.Http (>= 4.3.4)
- System.Text.RegularExpressions (>= 4.3.1)
- XLParser (>= 1.5.2)
-
.NETStandard 2.1
- DocumentFormat.OpenXml (>= 2.16.0 && < 3.0.0)
- ExcelNumberFormat (>= 1.1.0)
- SixLabors.Fonts (>= 1.0.0)
- System.IO.Packaging (>= 6.0.0)
- System.Net.Http (>= 4.3.4)
- System.Text.RegularExpressions (>= 4.3.1)
- XLParser (>= 1.5.2)
NuGet packages (373)
Showing the top 5 NuGet packages that depend on ClosedXML:
Package | Downloads |
---|---|
ClosedXML.Report
ClosedXML.Report is a tool for report generation and data analysis in .NET applications through the use of Microsoft Excel. ClosedXML.Report is a .NET-library for report generation Microsoft Excel without requiring Excel to be installed on the machine that's running the code. |
|
CsvHelper.Excel.Core
An implementation of ICsvParser and ICsvSerializer from CsvHelper that reads and writes using the ClosedXml library. |
|
ClosedXML.Extensions.Mvc
MVC extensions for ClosedXML |
|
ClosedXML.Extensions.WebApi
WebApi extensions for ClosedXML |
|
SanteDB.BI
SanteDB Business Intelligence (BI) core logic. Provides structures for data sources, queries, reports, and report controls rendered in all SanteDB software solutions. |
GitHub repositories (32)
Showing the top 5 popular GitHub repositories that depend on ClosedXML:
Repository | Stars |
---|---|
nopSolutions/nopCommerce
ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.
|
|
mini-software/MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
|
|
YarnSpinnerTool/YarnSpinner
Yarn Spinner is a tool for building interactive dialogue in games!
|
|
open-rpa/openrpa
Free Open Source Enterprise Grade RPA
|
|
phongnguyend/Practical.CleanArchitecture
Full-stack .Net 8 Clean Architecture (Microservices, Modular Monolith, Monolith), Blazor, Angular 18, React 18, Vue 3, BFF with YARP, Domain-Driven Design, CQRS, SOLID, Asp.Net Core Identity Custom Storage, OpenID Connect, Entity Framework Core, OpenTelemetry, SignalR, Hosted Services, Health Checks, Rate Limiting, Cloud Services (Azure, AWS, GCP).
|
Version | Downloads | Last updated |
---|---|---|
0.104.0-preview2 | 231,754 | 10/26/2023 |
0.103.0-beta | 21,202 | 9/28/2023 |
0.102.3 | 486,462 | 7/18/2024 |
0.102.2 | 4,879,026 | 1/5/2024 |
0.102.1 | 3,959,869 | 8/18/2023 |
0.102.0 | 1,614,602 | 6/24/2023 |
0.102.0-rc | 5,171 | 6/18/2023 |
0.101.0 | 2,670,596 | 4/9/2023 |
0.101.0-rc | 4,410 | 4/1/2023 |
0.100.3 | 3,387,510 | 1/12/2023 |
0.100.2 | 57,818 | 1/10/2023 |
0.100.1 | 24,530 | 1/9/2023 |
0.100.0 | 118,783 | 1/9/2023 |
0.97.0 | 3,965,337 | 10/21/2022 |
0.96.0 | 5,719,144 | 6/29/2022 |
0.95.4 | 20,922,793 | 12/16/2020 |
0.95.3 | 8,394,039 | 5/25/2020 |
0.95.2 | 697,370 | 4/26/2020 |
0.95.1 | 213,631 | 4/23/2020 |
0.95.0 | 1,087,832 | 4/15/2020 |
0.95.0-beta2 | 97,334 | 8/21/2019 |
0.95.0-beta1 | 43,778 | 4/4/2019 |
0.94.2 | 6,338,875 | 12/18/2018 |
0.94.0 | 68,305 | 12/12/2018 |
0.94.0-rc2 | 5,268 | 11/29/2018 |
0.94.0-rc1 | 8,495 | 11/11/2018 |
0.93.1 | 1,060,843 | 8/7/2018 |
0.93.0 | 493,144 | 6/25/2018 |
0.93.0-rc3 | 8,118 | 6/7/2018 |
0.93.0-rc2 | 4,134 | 5/31/2018 |
0.93.0-beta4 | 4,693 | 5/14/2018 |
0.93.0-beta2 | 5,362 | 4/26/2018 |
0.93.0-beta1 | 2,869 | 4/19/2018 |
0.92.1 | 1,052,868 | 4/10/2018 |
0.92.0-beta1 | 5,688 | 3/22/2018 |
0.91.1 | 59,145 | 4/4/2018 |
0.91.0 | 298,446 | 1/31/2018 |
0.91.0-beta3 | 4,184 | 1/23/2018 |
0.91.0-beta2 | 14,438 | 12/8/2017 |
0.91.0-beta1 | 2,920 | 11/29/2017 |
0.90.0 | 731,640 | 10/23/2017 |
0.90.0-beta2 | 3,227 | 10/6/2017 |
0.89.0 | 388,659 | 9/12/2017 |
0.89.0-beta1 | 5,244 | 8/23/2017 |
0.88.0 | 219,751 | 7/24/2017 |
0.88.0-beta1 | 10,521 | 7/10/2017 |
0.87.1 | 1,664,453 | 4/3/2017 |
0.86.0 | 418,989 | 1/6/2017 |
0.85.0 | 334,560 | 12/7/2016 |
0.80.1 | 718,110 | 9/15/2016 |
0.76.0 | 1,645,574 | 12/16/2014 |
0.75.0 | 208,316 | 9/17/2014 |
0.74.0 | 40,354 | 8/10/2014 |
0.73.0 | 39,514 | 6/24/2014 |
0.72.3 | 27,229 | 6/4/2014 |
0.72.2 | 4,488 | 6/4/2014 |
0.72.1 | 57,529 | 6/4/2014 |
0.72.0 | 10,671 | 6/4/2014 |
0.71.1 | 16,782 | 5/26/2014 |
0.70.0 | 12,553 | 5/18/2014 |
0.69.2 | 163,745 | 10/3/2013 |
0.69.1 | 84,430 | 8/15/2013 |
0.69.0 | 7,325 | 8/10/2013 |
0.68.1 | 101,342 | 10/20/2012 |
0.68.0 | 5,900 | 10/12/2012 |
0.67.2 | 23,149 | 8/14/2012 |
0.67.1 | 4,518 | 8/13/2012 |
0.67.0 | 4,629 | 8/12/2012 |
0.66.1 | 5,319 | 7/28/2012 |
0.66.0 | 4,882 | 7/18/2012 |
0.65.2 | 10,079 | 4/21/2012 |
0.64.0 | 21,231 | 2/4/2012 |