ClosedXML 0.94.0
Prefix ReservedSee the version list below for details.
dotnet add package ClosedXML --version 0.94.0
NuGet\Install-Package ClosedXML -Version 0.94.0
<PackageReference Include="ClosedXML" Version="0.94.0" />
<PackageVersion Include="ClosedXML" Version="0.94.0" />
<PackageReference Include="ClosedXML" />
paket add ClosedXML --version 0.94.0
#r "nuget: ClosedXML, 0.94.0"
#addin nuget:?package=ClosedXML&version=0.94.0
#tool nuget:?package=ClosedXML&version=0.94.0
Breaking changes
- This package now depends on
FastMember
instead ofFastMember.Signed
. IDisposable
interface removed fromIXLWorksheet
. See #1049IXLPictures
interface has changed to accept parameters of typeIXLCell
instead ofIXLAddress
. See #930IXLBaseAutoFilter
removed and replaced with the existingIXLAutoFilter
. See #909IXLRange.ToString()
andIXLRangeAddress.ToString()
now return context aware range strings. See #1021
Enhancements
- #856 Clear pivot table rendered range upon loading to avoid conflict on rendered cells when opening the file.
- #877 Add helper property
VisibleRows
for autofilters - #884 Allow pivot tables to have no theme
- #904 Implement the full range of Item subclasses for pivot tables
- #905 Don't choke on pivot table saving when formulas fail
- #908 New methods to append and replace table data
- #909 New method to reapply autofilter
- #926 Disallow table with null
.DataRange
when saving - #930 Store picture markers against a range to allow shifting when inserting and deleting
- #932 Optionally propagate extra table columns when changing data
- #945 Allow
Guid
values to be inserted when dumping data - #962 Add ability to set cell value to an enum value
- #978 Add table helper methods:
IXLTables.TryGetTable()
- #996 Allow table field names consisting of only whitespace
- #999 Allow names to start with backslash
- #1005 Ignore print areas that point to external workbooks
- #1019 Improve
XLCell.TryGetValue
and implement additional tests - #1021 Return simpler range address values
- #1025 Lazy initialize graphics
- #1033 Optimize the performance of searching range intersections on small collections
- #1035 Improve implicit string casting
- #1036 Don't validate named ranges when loading file
- #1044 Add check that data validation value length does not exceed 255 chars
- #1064 Make
TryGetValue_decimal_Good2test
environment-independent
Bug fixes
- #876 Correctly unprotect worksheet without password
- #887 Correctly determine used range when there are merged ranges on a worksheet
- #903 Clear all cell contents (formats too) in pivot table range upon loading.
- #906 Maintain pivot table page field order
- #931 Delete table rows correctly
- #947 Fix pivot table integrity when saving multiple times
- #956 Do not quote worksheet name with whitespace when saving pivot table worksheet source
- #969 Fix ranges consolidation
- #985 Set
XLPivotField.ShowBlankItems
by default to false and fix treatment of defaults from loading file - #988 FIX for
XLConditionalFormat
equality comparer fails forColorScale
- #998 Copies of tables should have
RelId
default tonull
- #1023 Sort ranges to shift before enumerating through them to avoid new target address conflicting with existing range
- #1028 Copy row/column visibility setting
- #1029
CellsUsed
refactoring and fix - #1031 Fix for merging cells
- #1032 Change the way invalid ranges are saved
- #1041 Autofilter with multiple columns with filters
- #1047 String comparisons should be case-insensitive
- #1048 Shift data validation ranges when inserting / delete ranges
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. 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. |
-
.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 (446)
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. |
|
OO.Data
Data Entity base types and declarations for EasyDataCore infrastructure |
|
ClosedXML.Extensions.Mvc
MVC extensions for ClosedXML |
|
Microsoft.KernelMemory.Core
The package contains the core logic and abstractions of Kernel Memory, not including extensions. |
GitHub repositories (36)
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)
|
|
serenity-is/Serenity
Business Apps Made Simple with Asp.Net Core MVC / TypeScript
|
|
open-rpa/openrpa
Free Open Source Enterprise Grade RPA
|
|
YarnSpinnerTool/YarnSpinner
Yarn Spinner is a tool for building interactive dialogue in games!
|
|
phongnguyend/Practical.CleanArchitecture
Full-stack .Net 9 Clean Architecture (Microservices, Modular Monolith, Monolith), Blazor, Angular 19, 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
RAG architecture: index and query any data using LLM and natural language, track sources, show citations, asynchronous memory patterns.
|
|
abpframework/abp-samples
Sample solutions built with the ABP Framework
|
|
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.
|
|
neozhu/CleanArchitectureWithBlazorServer
This is a repository for creating a Blazor Server dashboard application following the principles of Clean Architecture
|
|
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.
|
|
VladislavAntonyuk/MauiSamples
.NET MAUI Samples
|
|
DotNetNext/WebFirst
.NET CORE 代码生成器 ,Web中使用CodeFirst模式, 实体 生成器,UI代码 生成器,在线建表,PostgresSql生成器,达梦生成器,金仓生成器MySql生成器,SQLServere生成器、Oracle生成器、Sqlite生成器、导出文档,模版配置, WEB代码生成器 ,API代码生成器
|
|
KorzhCom/EasyData
Adaptive CRUD for ASP.NET Core. With EasyData you can get both API endpoints and client-side UI for all CRUD operations in a matter of minutes using just your DbContext and a few lines of code.
|
|
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
|
|
axzxs2001/Asp.NetCoreExperiment
原来所有项目都移动到**OleVersion**目录下进行保留。新的案例装以.net 5.0为主,一部分对以前案例进行升级,一部分将以前的工作经验总结出来,以供大家参考!
|
Version | Downloads | Last Updated |
---|---|---|
0.105.0 | 492,864 | 5/14/2025 |
0.105.0-rc | 138,786 | 1/22/2025 |
0.104.2 | 7,431,413 | 11/15/2024 |
0.104.1 | 2,650,518 | 9/30/2024 |
0.104.0-rc1 | 74,126 | 9/17/2024 |
0.104.0-preview2 | 417,828 | 10/26/2023 |
0.103.0-beta | 34,753 | 9/28/2023 |
0.102.3 | 3,467,325 | 7/18/2024 |
0.102.2 | 10,389,287 | 1/5/2024 |
0.102.1 | 5,771,129 | 8/18/2023 |
0.102.0 | 2,202,007 | 6/24/2023 |
0.102.0-rc | 8,511 | 6/18/2023 |
0.101.0 | 3,326,261 | 4/9/2023 |
0.101.0-rc | 5,110 | 4/1/2023 |
0.100.3 | 4,354,220 | 1/12/2023 |
0.100.2 | 69,089 | 1/10/2023 |
0.100.1 | 33,386 | 1/9/2023 |
0.100.0 | 151,241 | 1/9/2023 |
0.97.0 | 5,075,684 | 10/21/2022 |
0.96.0 | 7,932,101 | 6/29/2022 |
0.95.4 | 25,052,267 | 12/16/2020 |
0.95.3 | 9,121,934 | 5/25/2020 |
0.95.2 | 764,749 | 4/26/2020 |
0.95.1 | 226,791 | 4/23/2020 |
0.95.0 | 1,320,991 | 4/15/2020 |
0.95.0-beta2 | 111,133 | 8/21/2019 |
0.95.0-beta1 | 45,816 | 4/4/2019 |
0.94.2 | 7,502,422 | 12/18/2018 |
0.94.0 | 75,974 | 12/12/2018 |
0.94.0-rc2 | 5,591 | 11/29/2018 |
0.94.0-rc1 | 8,864 | 11/11/2018 |
0.93.1 | 1,153,063 | 8/7/2018 |
0.93.0 | 540,345 | 6/25/2018 |
0.93.0-rc3 | 8,455 | 6/7/2018 |
0.93.0-rc2 | 4,603 | 5/31/2018 |
0.93.0-beta4 | 5,015 | 5/14/2018 |
0.93.0-beta2 | 5,702 | 4/26/2018 |
0.93.0-beta1 | 3,281 | 4/19/2018 |
0.92.1 | 1,402,417 | 4/10/2018 |
0.92.0-beta1 | 6,327 | 3/22/2018 |
0.91.1 | 69,374 | 4/4/2018 |
0.91.0 | 339,040 | 1/31/2018 |
0.91.0-beta3 | 4,747 | 1/23/2018 |
0.91.0-beta2 | 15,030 | 12/8/2017 |
0.91.0-beta1 | 3,159 | 11/29/2017 |
0.90.0 | 810,688 | 10/23/2017 |
0.90.0-beta2 | 3,472 | 10/6/2017 |
0.89.0 | 418,403 | 9/12/2017 |
0.89.0-beta1 | 5,612 | 8/23/2017 |
0.88.0 | 238,801 | 7/24/2017 |
0.88.0-beta1 | 10,755 | 7/10/2017 |
0.87.1 | 2,025,542 | 4/3/2017 |
0.86.0 | 466,840 | 1/6/2017 |
0.85.0 | 372,332 | 12/7/2016 |
0.80.1 | 788,764 | 9/15/2016 |
0.76.0 | 1,807,279 | 12/16/2014 |
0.75.0 | 227,378 | 9/17/2014 |
0.74.0 | 47,646 | 8/10/2014 |
0.73.0 | 42,088 | 6/24/2014 |
0.72.3 | 32,354 | 6/4/2014 |
0.72.2 | 5,631 | 6/4/2014 |
0.72.1 | 61,785 | 6/4/2014 |
0.72.0 | 13,587 | 6/4/2014 |
0.71.1 | 20,520 | 5/26/2014 |
0.70.0 | 15,276 | 5/18/2014 |
0.69.2 | 174,394 | 10/3/2013 |
0.69.1 | 96,118 | 8/15/2013 |
0.69.0 | 8,726 | 8/10/2013 |
0.68.1 | 117,286 | 10/20/2012 |
0.68.0 | 7,179 | 10/12/2012 |
0.67.2 | 26,129 | 8/14/2012 |
0.67.1 | 5,693 | 8/13/2012 |
0.67.0 | 5,836 | 8/12/2012 |
0.66.1 | 6,509 | 7/28/2012 |
0.66.0 | 6,072 | 7/18/2012 |
0.65.2 | 11,413 | 4/21/2012 |
0.64.0 | 30,440 | 2/4/2012 |