ClosedXML 0.95.0-beta1
Prefix ReservedSee the version list below for details.
dotnet add package ClosedXML --version 0.95.0-beta1
NuGet\Install-Package ClosedXML -Version 0.95.0-beta1
<PackageReference Include="ClosedXML" Version="0.95.0-beta1" />
paket add ClosedXML --version 0.95.0-beta1
#r "nuget: ClosedXML, 0.95.0-beta1"
// Install ClosedXML as a Cake Addin #addin nuget:?package=ClosedXML&version=0.95.0-beta1&prerelease // Install ClosedXML as a Cake Tool #tool nuget:?package=ClosedXML&version=0.95.0-beta1&prerelease
Breaking changes
- Range strings, e.g.
A1:B2
are now always treated as absolute, i.e. relative toA1
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
andXLCellUsedOptions
'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 missingr
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
andXLRanges
Thanks to @Pankraty for many PRs, as usual.
- @igitur
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 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. |
-
.NETFramework 4.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
-
.NETFramework 4.6
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
-
.NETStandard 2.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
- System.Drawing.Common (>= 4.5.0)
NuGet packages (387)
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 (33)
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.2 | 159,448 | 11/15/2024 |
0.104.1 | 887,804 | 9/30/2024 |
0.104.0-rc1 | 34,216 | 9/17/2024 |
0.104.0-preview2 | 314,965 | 10/26/2023 |
0.103.0-beta | 27,241 | 9/28/2023 |
0.102.3 | 1,825,643 | 7/18/2024 |
0.102.2 | 6,884,293 | 1/5/2024 |
0.102.1 | 4,598,077 | 8/18/2023 |
0.102.0 | 1,816,450 | 6/24/2023 |
0.102.0-rc | 6,561 | 6/18/2023 |
0.101.0 | 2,923,394 | 4/9/2023 |
0.101.0-rc | 4,727 | 4/1/2023 |
0.100.3 | 3,719,408 | 1/12/2023 |
0.100.2 | 60,910 | 1/10/2023 |
0.100.1 | 26,981 | 1/9/2023 |
0.100.0 | 127,527 | 1/9/2023 |
0.97.0 | 4,348,094 | 10/21/2022 |
0.96.0 | 6,361,906 | 6/29/2022 |
0.95.4 | 22,211,998 | 12/16/2020 |
0.95.3 | 8,664,174 | 5/25/2020 |
0.95.2 | 720,580 | 4/26/2020 |
0.95.1 | 218,094 | 4/23/2020 |
0.95.0 | 1,168,971 | 4/15/2020 |
0.95.0-beta2 | 102,389 | 8/21/2019 |
0.95.0-beta1 | 44,395 | 4/4/2019 |
0.94.2 | 6,733,352 | 12/18/2018 |
0.94.0 | 70,388 | 12/12/2018 |
0.94.0-rc2 | 5,324 | 11/29/2018 |
0.94.0-rc1 | 8,544 | 11/11/2018 |
0.93.1 | 1,092,221 | 8/7/2018 |
0.93.0 | 505,804 | 6/25/2018 |
0.93.0-rc3 | 8,162 | 6/7/2018 |
0.93.0-rc2 | 4,252 | 5/31/2018 |
0.93.0-beta4 | 4,735 | 5/14/2018 |
0.93.0-beta2 | 5,406 | 4/26/2018 |
0.93.0-beta1 | 2,927 | 4/19/2018 |
0.92.1 | 1,184,494 | 4/10/2018 |
0.92.0-beta1 | 5,975 | 3/22/2018 |
0.91.1 | 61,937 | 4/4/2018 |
0.91.0 | 308,580 | 1/31/2018 |
0.91.0-beta3 | 4,258 | 1/23/2018 |
0.91.0-beta2 | 14,576 | 12/8/2017 |
0.91.0-beta1 | 2,960 | 11/29/2017 |
0.90.0 | 756,981 | 10/23/2017 |
0.90.0-beta2 | 3,264 | 10/6/2017 |
0.89.0 | 399,814 | 9/12/2017 |
0.89.0-beta1 | 5,315 | 8/23/2017 |
0.88.0 | 225,933 | 7/24/2017 |
0.88.0-beta1 | 10,556 | 7/10/2017 |
0.87.1 | 1,760,571 | 4/3/2017 |
0.86.0 | 435,396 | 1/6/2017 |
0.85.0 | 346,382 | 12/7/2016 |
0.80.1 | 743,168 | 9/15/2016 |
0.76.0 | 1,691,183 | 12/16/2014 |
0.75.0 | 213,750 | 9/17/2014 |
0.74.0 | 43,244 | 8/10/2014 |
0.73.0 | 40,071 | 6/24/2014 |
0.72.3 | 28,935 | 6/4/2014 |
0.72.2 | 4,700 | 6/4/2014 |
0.72.1 | 58,599 | 6/4/2014 |
0.72.0 | 11,472 | 6/4/2014 |
0.71.1 | 17,835 | 5/26/2014 |
0.70.0 | 13,300 | 5/18/2014 |
0.69.2 | 166,683 | 10/3/2013 |
0.69.1 | 87,171 | 8/15/2013 |
0.69.0 | 7,635 | 8/10/2013 |
0.68.1 | 106,419 | 10/20/2012 |
0.68.0 | 6,158 | 10/12/2012 |
0.67.2 | 24,084 | 8/14/2012 |
0.67.1 | 4,741 | 8/13/2012 |
0.67.0 | 4,867 | 8/12/2012 |
0.66.1 | 5,540 | 7/28/2012 |
0.66.0 | 5,120 | 7/18/2012 |
0.65.2 | 10,370 | 4/21/2012 |
0.64.0 | 23,969 | 2/4/2012 |