ClosedXML 0.103.0-beta

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.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.103.0-beta                

                    
                

            
NuGet\Install-Package ClosedXML -Version 0.103.0-beta
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.103.0-beta" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ClosedXML --version 0.103.0-beta                

                    
                

            
#r "nuget: ClosedXML, 0.103.0-beta"
#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. 
// Install ClosedXML as a Cake Addin
#addin nuget:?package=ClosedXML&version=0.103.0-beta&prerelease

// Install ClosedXML as a Cake Tool
#tool nuget:?package=ClosedXML&version=0.103.0-beta&prerelease

See release notes for 0.103.0-beta: https://github.com/ClosedXML/ClosedXML/releases/tag/0.103.0-beta

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");
}

Performance

Performance matters mostly for large files. For small files, few ms here or there doesn't matter.

Save

Description Rows Columns Time/Memory to insert data Save workbook Total time/memory
Mixed (text/number) workbook.<br>Gist 250 000 15 1.619 sec / 117 MiB 6.343 sec 7.962 sec / 477 MiB
Text only workbook. Gist 1 000 000 10 6.302 sec / 402 MiB 17.134 sec 23.436 sec / 1880 MiB

Load

Description Rows Columns Time to load data Used memory
Load mixed workbook (10 text/5 number columns). 250 000 15 15.648 sec 236 MiB
Text only workbook. 1 000 000 10 49.046 sec 801 MiB
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. 
.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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (397)

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
Microsoft.KernelMemory.Core

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

GitHub repositories (35)

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)
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!
open-rpa/openrpa
Free Open Source Enterprise Grade RPA
Version Downloads Last updated
0.104.2 676,881 11/15/2024
0.104.1 1,262,392 9/30/2024
0.104.0-rc1 44,531 9/17/2024
0.104.0-preview2 337,220 10/26/2023
0.103.0-beta 29,406 9/28/2023
0.102.3 2,161,257 7/18/2024
0.102.2 7,489,104 1/5/2024
0.102.1 4,817,393 8/18/2023
0.102.0 1,882,313 6/24/2023
0.102.0-rc 7,160 6/18/2023
0.101.0 2,997,136 4/9/2023
0.101.0-rc 4,813 4/1/2023
0.100.3 3,830,882 1/12/2023
0.100.2 62,948 1/10/2023
0.100.1 28,060 1/9/2023
0.100.0 131,205 1/9/2023
0.97.0 4,473,228 10/21/2022
0.96.0 6,655,146 6/29/2022
0.95.4 22,725,238 12/16/2020
0.95.3 8,736,603 5/25/2020
0.95.2 728,077 4/26/2020
0.95.1 219,618 4/23/2020
0.95.0 1,196,467 4/15/2020
0.95.0-beta2 104,446 8/21/2019
0.95.0-beta1 44,719 4/4/2019
0.94.2 6,856,669 12/18/2018
0.94.0 71,094 12/12/2018
0.94.0-rc2 5,380 11/29/2018
0.94.0-rc1 8,579 11/11/2018
0.93.1 1,102,352 8/7/2018
0.93.0 511,419 6/25/2018
0.93.0-rc3 8,182 6/7/2018
0.93.0-rc2 4,312 5/31/2018
0.93.0-beta4 4,747 5/14/2018
0.93.0-beta2 5,417 4/26/2018
0.93.0-beta1 2,937 4/19/2018
0.92.1 1,231,254 4/10/2018
0.92.0-beta1 6,038 3/22/2018
0.91.1 63,225 4/4/2018
0.91.0 313,263 1/31/2018
0.91.0-beta3 4,335 1/23/2018
0.91.0-beta2 14,616 12/8/2017
0.91.0-beta1 2,970 11/29/2017
0.90.0 766,284 10/23/2017
0.90.0-beta2 3,274 10/6/2017
0.89.0 402,102 9/12/2017
0.89.0-beta1 5,343 8/23/2017
0.88.0 228,221 7/24/2017
0.88.0-beta1 10,566 7/10/2017
0.87.1 1,792,342 4/3/2017
0.86.0 441,096 1/6/2017
0.85.0 350,050 12/7/2016
0.80.1 751,876 9/15/2016
0.76.0 1,706,452 12/16/2014
0.75.0 216,074 9/17/2014
0.74.0 44,606 8/10/2014
0.73.0 40,363 6/24/2014
0.72.3 29,642 6/4/2014
0.72.2 4,861 6/4/2014
0.72.1 59,105 6/4/2014
0.72.0 11,825 6/4/2014
0.71.1 18,271 5/26/2014
0.70.0 13,628 5/18/2014
0.69.2 168,129 10/3/2013
0.69.1 88,367 8/15/2013
0.69.0 7,808 8/10/2013
0.68.1 107,930 10/20/2012
0.68.0 6,310 10/12/2012
0.67.2 24,480 8/14/2012
0.67.1 4,904 8/13/2012
0.67.0 5,021 8/12/2012
0.66.1 5,697 7/28/2012
0.66.0 5,280 7/18/2012
0.65.2 10,533 4/21/2012
0.64.0 24,789 2/4/2012

See https://github.com/ClosedXML/ClosedXML/releases/tag/0.103.0-beta