ClosedXML 0.95.0-beta1

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.0 This package targets .NET Framework 4.0. The package is compatible with this framework or higher.
This is a prerelease version of ClosedXML.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ClosedXML --version 0.95.0-beta1
                    


                    

                
NuGet\Install-Package ClosedXML -Version 0.95.0-beta1
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="ClosedXML" Version="0.95.0-beta1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="ClosedXML" Version="0.95.0-beta1" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="ClosedXML" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add ClosedXML --version 0.95.0-beta1
                    


                    

                
#r "nuget: ClosedXML, 0.95.0-beta1"
#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. 
#:package ClosedXML@0.95.0-beta1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=ClosedXML&version=0.95.0-beta1&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=ClosedXML&version=0.95.0-beta1&prerelease
                    


                            Install as a Cake Tool

Breaking changes

  • Range strings, e.g. A1:B2 are now always treated as absolute, i.e. relative to A1 instead of relative to the top left cell of a given range.
  • IXLSheetProtection has been totally refactored and now uses a flag based enum to control the elements that are allowed or locked.
  • Removed IXLSheetProtection.IsProtected setter
  • XLClearOptions and XLCellUsedOptions 's flags are now aligned

Enhancements

  • #1015 Text join func enhancement (Thanks @James-Whitfield)
  • #1038 IXLSheetProtection refactoring
  • #1054 Implement workbook FileSharing and a few of the properties
  • #1058 Dont recalculate formula cached values after load
  • #1077 Refactor digit and letter parsing to allow Unicode characters
  • #1109 Don't automatically adjust columns width to contents when inserting datatable. Some users want to opt out because of PlatformNotSupportedException
  • #1129 Implementation pivot table formats (Thanks @b0bi79)
  • #1130 Enhance TRUNC function for additional parameter
  • #1136 Implement NUMBERVALUE function
  • #1151 Performance improvement to delete entire columns
  • #1158 Check that print titles are valid row ranges or column ranges
  • #1170 Remove IXLSheetProtection.IsProtected public setter

Bug fixes

  • #1063 Copy comment style correctly when shifting ranges
  • #1108 Correctly save empty cell with quote prefix (do not treat as empty)
  • #1132 <c> elements with missing r attribute: XLAddress constructor had parameters swapped
  • #1133 Enumerate ranges in a deterministic order
  • #1134 Correctly propagate worksheet style to cells from a worksheet
  • #1135 Correctly load column-wide styles
  • #1137 Fix changing inner borders of the range
  • #1150 Correctly clear inline string when required
  • #1153 Correctly throw DivisionByZeroException when denominator is zero.
  • #1155 Ignore _X (capital X) as XML escaping char
  • #1161 Avoid creation of new item in Internals.RowsCollection when adding comment
  • #1168 Fix initialization of default styles for XLCells, XLRows, XLColumns and XLRanges

Thanks to @Pankraty for many PRs, as usual.

  • @igitur
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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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 was computed. 
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 is compatible.  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)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (514)

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
OO.Data

Data Entity base types and declarations for EasyDataCore infrastructure
Microsoft.KernelMemory.Core

The package contains the core logic and abstractions of Kernel Memory, not including extensions.

GitHub repositories (42)

Showing the top 20 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)
open-rpa/openrpa
Free Open Source Enterprise Grade RPA
serenity-is/Serenity
Business Apps Made Simple with Asp.Net Core MVC / TypeScript
YarnSpinnerTool/YarnSpinner
Yarn Spinner is a tool for building interactive dialogue in games!
phongnguyend/Practical.CleanArchitecture
Full-stack .Net 10 Clean Architecture (Microservices, Modular Monolith, Monolith), Blazor, Angular 20, React 19, Vue 3.5, BFF with YARP, NextJs 15, Domain-Driven Design, CQRS, SOLID, Asp.Net Core Identity Custom Storage, OpenID Connect, EF Core, OpenTelemetry, SignalR, Background Services, Health Checks, Rate Limiting, Clouds (Azure, AWS, GCP), ...
microsoft/kernel-memory
Research project. A Memory solution for users, teams, and applications.
Yu-Core/SwashbucklerDiary
侠客日记是一个开源、跨平台的本地日记app，使用Blazor开发，支持Android，Windows，macOS，Web，Linux。"SwashbucklerDiary" is an open source cross-platform local diary app using Blazor , support Android，Windows，macOS，Web，Linux.
abpframework/abp-samples
Sample solutions built with the ABP Framework
UiPath/CoreWF
WF runtime ported to work on .NET 6
neozhu/CleanArchitectureWithBlazorServer
This repository is designed to create an enterprise Blazor Server application that follows the principles of Clean Architecture and implements Blazor Clean Architecture best practices for scalability, maintainability, and testability.
VladislavAntonyuk/MauiSamples
.NET MAUI Samples
mixcore/mix.core
🚀 A future-proof enterprise web CMS supporting both headless and decoupled approaches. Build any type of app with customizable APIs on ASP.NET Core/.NET Core. Completely open-source and designed for flexibility.
DotNetNext/WebFirst
.NET CORE 代码生成器 ，Web中使用CodeFirst模式， 实体 生成器，UI代码 生成器，在线建表，PostgresSql生成器，达梦生成器，金仓生成器MySql生成器，SQLServere生成器、Oracle生成器、Sqlite生成器、导出文档，模版配置， WEB代码生成器 ，API代码生成器
Implem/Implem.Pleasanter
Pleasanter is a no-code/low-code development platform that runs on .NET. You can quickly create business applications with simple operations.
ClosedXML/ClosedXML.Report
ClosedXML.Report is a tool for report generation with which you can easily export any data from your .NET classes to Excel using a XLSX-template.
sveinungf/spreadcheetah
SpreadCheetah is a high-performance .NET library for generating spreadsheet (Microsoft Excel XLSX) files.
TabBlazor/TabBlazor
Blazor admin template based on Tabler UI
neozhu/visitormanagement
helps in managing visitors visiting the institutions for various reasons. It allows visitors to check-in digitally to eliminate the tedious registeration and other paperwork. Additionally, it also keeps a track of every individual inside the campus and their timings. Institutions has guards who enter their detail in some notebooks to keep a log which are practically impossible to reconcile. It is really unpleasent and hectic for visitor to stand at the gate and give details about the visit. To ease the process of registeration, Entry-In, Entry-Out, time tracking and logging the history, this VMS can be of great use!!
ShapeCrawler/ShapeCrawler
A .NET library for manipulating PowerPoint presentations
Version Downloads Last Updated
0.105.0 7,013,128 5/14/2025
0.105.0-rc 335,926 1/22/2025
0.104.2 14,641,320 11/15/2024
0.104.1 3,845,833 9/30/2024
0.104.0-rc1 79,455 9/17/2024
0.104.0-preview2 476,276 10/26/2023
0.103.0-beta 39,842 9/28/2023
0.102.3 4,491,098 7/18/2024
0.102.2 13,157,593 1/5/2024
0.102.1 6,595,593 8/18/2023
0.102.0 2,501,634 6/24/2023
0.102.0-rc 9,082 6/18/2023
0.101.0 3,645,206 4/9/2023
0.101.0-rc 5,399 4/1/2023
0.100.3 4,826,017 1/12/2023
0.100.2 74,147 1/10/2023
0.100.1 36,825 1/9/2023
0.100.0 171,294 1/9/2023
0.97.0 5,684,729 10/21/2022
0.96.0 9,064,747 6/29/2022
0.95.4 27,407,917 12/16/2020
0.95.3 9,713,002 5/25/2020
0.95.2 796,630 4/26/2020
0.95.1 232,017 4/23/2020
0.95.0 1,431,642 4/15/2020
0.95.0-beta2 114,007 8/21/2019
0.95.0-beta1 46,373 4/4/2019
0.94.2 8,238,337 12/18/2018
0.94.0 80,178 12/12/2018
0.94.0-rc2 5,887 11/29/2018
0.94.0-rc1 9,223 11/11/2018
0.93.1 1,202,139 8/7/2018
0.93.0 563,183 6/25/2018
0.93.0-rc3 8,859 6/7/2018
0.93.0-rc2 4,907 5/31/2018
0.93.0-beta4 5,317 5/14/2018
0.93.0-beta2 6,030 4/26/2018
0.93.0-beta1 3,740 4/19/2018
0.92.1 1,563,046 4/10/2018
0.92.0-beta1 6,657 3/22/2018
0.91.1 74,747 4/4/2018
0.91.0 356,211 1/31/2018
0.91.0-beta3 5,173 1/23/2018
0.91.0-beta2 15,412 12/8/2017
0.91.0-beta1 3,395 11/29/2017
0.90.0 846,148 10/23/2017
0.90.0-beta2 3,689 10/6/2017
0.89.0 434,702 9/12/2017
0.89.0-beta1 5,857 8/23/2017
0.88.0 246,751 7/24/2017
0.88.0-beta1 10,996 7/10/2017
0.87.1 2,216,190 4/3/2017
0.86.0 489,485 1/6/2017
0.85.0 393,627 12/7/2016
0.80.1 837,433 9/15/2016
0.76.0 1,907,366 12/16/2014
0.75.0 236,868 9/17/2014
0.74.0 48,780 8/10/2014
0.73.0 44,899 6/24/2014
0.72.3 34,133 6/4/2014
0.72.2 6,104 6/4/2014
0.72.1 63,877 6/4/2014
0.72.0 15,226 6/4/2014
0.71.1 21,681 5/26/2014
0.70.0 16,462 5/18/2014
0.69.2 178,030 10/3/2013
0.69.1 103,785 8/15/2013
0.69.0 9,288 8/10/2013
0.68.1 124,053 10/20/2012
0.68.0 7,742 10/12/2012
0.67.2 27,346 8/14/2012
0.67.1 6,187 8/13/2012
0.67.0 6,359 8/12/2012
0.66.1 7,044 7/28/2012
0.66.0 6,587 7/18/2012
0.65.2 12,184 4/21/2012
0.64.0 35,726 2/4/2012

See https://github.com/ClosedXML/ClosedXML/releases/tag/0.95.0-beta1