MiniExcel 1.41.2

Prefix Reserved

.NET 8.0 .NET Standard 2.0 .NET Framework 4.5

dotnet add package MiniExcel --version 1.41.2

NuGet\Install-Package MiniExcel -Version 1.41.2

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="MiniExcel" Version="1.41.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="MiniExcel" Version="1.41.2" />
                    

                            Directory.Packages.props

<PackageReference Include="MiniExcel" />
                    

                            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 MiniExcel --version 1.41.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: MiniExcel, 1.41.2"

#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.

#addin nuget:?package=MiniExcel&version=1.41.2
                    

                            Install MiniExcel as a Cake Addin

#tool nuget:?package=MiniExcel&version=1.41.2
                    

                            Install MiniExcel as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

This project is part of the .NET Foundation and operates under their code of conduct.

Introduction

MiniExcel is simple and efficient to avoid OOM's .NET processing Excel tool.

At present, most popular frameworks need to load all the data into the memory to facilitate operation, but it will cause memory consumption problems. MiniExcel tries to use algorithm from a stream to reduce the original 1000 MB occupation to a few MB to avoid OOM(out of memory).

Features

Low memory consumption, avoid OOM (out of memory) and full GC
Support real-time operation of each row of data
Support LINQ deferred execution, it can do low-consumption, fast paging and other complex queries
Lightweight, without Microsoft Office installed, no COM+, DLL size is less than 150KB
Easy API style to read/write/fill excel

Installation

You can install the package from NuGet

Release Notes

Please Check Release Notes

TODO

Please Check TODO

Performance

Benchmarks logic can be found in MiniExcel.Benchmarks , and test cli

dotnet run -p .\benchmarks\MiniExcel.Benchmarks\ -c Release -f netcoreapp3.1 -- -f * --join

Output from the latest run is :

BenchmarkDotNet=v0.12.1, OS=Windows 10.0.19042
Intel Core i7-7700 CPU 3.60GHz (Kaby Lake), 1 CPU, 8 logical and 4 physical cores
  [Host]     : .NET Framework 4.8 (4.8.4341.0), X64 RyuJIT
  Job-ZYYABG : .NET Framework 4.8 (4.8.4341.0), X64 RyuJIT
IterationCount=3  LaunchCount=3  WarmupCount=3

Benchmark History : Link

Import/Query Excel

Logic : Test1,000,000x10.xlsx as performance test basic file, 1,000,000 rows * 10 columns "HelloWorld" cells, 23 MB file size

Library	Method	Max Memory Usage	Mean
MiniExcel	'MiniExcel QueryFirst'	0.109 MB	0.0007264 sec
ExcelDataReader	'ExcelDataReader QueryFirst'	15.24 MB	10.66421 sec
MiniExcel	'MiniExcel Query'	17.3 MB	14.17933 sec
ExcelDataReader	'ExcelDataReader Query'	17.3 MB	22.56508 sec
Epplus	'Epplus QueryFirst'	1,452 MB	18.19801 sec
Epplus	'Epplus Query'	1,451 MB	23.64747 sec
OpenXmlSDK	'OpenXmlSDK Query'	1,412 MB	52.00327 sec
OpenXmlSDK	'OpenXmlSDK QueryFirst'	1,413 MB	52.34865 sec
ClosedXml	'ClosedXml QueryFirst'	2,158 MB	66.18897 sec
ClosedXml	'ClosedXml Query'	2,184 MB	191.43412 sec

Export/Create Excel

Logic : create a total of 10,000,000 "HelloWorld" excel

Library	Method	Max Memory Usage	Mean
MiniExcel	'MiniExcel Create Xlsx'	15 MB	11.53181 sec
Epplus	'Epplus Create Xlsx'	1,204 MB	22.50971 sec
OpenXmlSdk	'OpenXmlSdk Create Xlsx'	2,621 MB	42.47399 sec
ClosedXml	'ClosedXml Create Xlsx'	7,141 MB	140.93992 sec

Documents

https://github.com/mini-software/MiniExcel

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 is compatible. 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 is compatible. 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	net45 is compatible. net451 was computed. net452 was computed. net46 was computed. 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.

.NETFramework 4.5
- No dependencies.
.NETStandard 2.0
- Microsoft.Bcl.AsyncInterfaces (>= 9.0.0)
net8.0
- No dependencies.
net9.0
- No dependencies.

NuGet packages (125)

Showing the top 5 NuGet packages that depend on MiniExcel:

Package	Downloads
GuoKun.CPS 国坤CPS库	219.1K
BootstrapBlazor.TableExport Bootstrap UI components extensions of export	149.5K
DH.MiniExcel 基于DH框架的Excel处理库。基于https://github.com/mini-software/MiniExcel	127.3K
TXQ.Utils Package Description	64.0K
Wologic.SYS.Application 公司内部自用	56.5K

GitHub repositories (10)

Showing the top 10 popular GitHub repositories that depend on MiniExcel:

Repository	Stars
Scighost/Starward Game Launcher for miHoYo - 米家游戏启动器	3.9K
dotnetcore/Magicodes.IE Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.	2.2K
izhaorui/Zr.Admin.NET 🎉ZR.Admin.NET是一款前后端分离的、跨平台基于RBAC的通用权限管理后台。ORM采用SqlSugar。前端采用Vue、AntDesign，支持多租户、缓存、任务调度、支持统一异常处理、接口限流、支持一键生成前后端代码，支持动态国际化翻译(Vue3)，等诸多黑科技，代码简洁易懂、易扩展让开发更简单、更通用。	1.2K
xunkong/xunkong 记录旅途中发生的事	941
colinin/abp-next-admin 这是基于vue-vben-admin 模板适用于abp vNext的前端管理项目	916
VladislavAntonyuk/MauiSamples .NET MAUI Samples	836
ThingsGateway/ThingsGateway ThingsGateway is a cross platform high-performance edge acquisition gateway based on Net8, providing underlying PLC communication libraries, communication debugging software, and more.	225
842549829/Panda Abp.vNext + EF Core The microservices Open source framework project supports the implementation of message push workflow certification centers based on OAuth2.0	180
zmrid/iMES-Factory iMES工厂管家——您的新一代工厂助手。演示地址：https://imes.625sc.com。一款基于.NetCore3.1和Vue3的MES管理系统。项目亮点：模版打印，Excel模版导出，自定义实体扩展，移动端精美设计，大屏设计等功能。	177
densen2014/BlazorMaui 用 c # 和 Razor 创建本机移动应用和桌面应用。使用 Blazor.BB.Maui，可以快速开发共享代码库运行于 Windows (Winforms/WPF/UWP)、Android、iOS、macOS 的应用。	161

Version	Downloads	Last updated
1.41.2	27,373	5/23/2025
1.41.1	40,719	4/25/2025
1.41.0	23,203	4/20/2025
1.40.1	2,318	4/18/2025
1.40.0	23,954	4/10/2025
1.39.0	59,006	3/18/2025
1.38.0	121,663	2/16/2025
1.37.0	49,119	1/20/2025
1.36.1	15,946	1/15/2025
1.36.0	91,042	12/12/2024
1.35.0	116,301	11/9/2024
1.34.2	280,659	9/14/2024
1.34.1	127,027	8/10/2024
1.34.0	102,799	7/21/2024
1.33.0	59,937	7/7/2024
1.32.1	166,705	5/16/2024
1.32.0	25,284	5/12/2024
1.31.3	510,176	12/27/2023
1.31.2	844,134	8/10/2023
1.31.0	283,176	5/28/2023
1.30.3	105,950	5/1/2023
1.30.2	558,168	2/21/2023
1.30.1	39,430	2/7/2023
1.30.0	194,396	12/27/2022
1.29.0	194,979	11/9/2022
1.28.5	21,067	10/30/2022
1.28.4	3,637	10/29/2022
1.28.2	3,636	10/29/2022
1.28.1	26,182	10/22/2022
1.28.0	72,159	9/19/2022
1.27.0	4,410	9/18/2022
1.26.7	11,763	9/9/2022
1.26.6	11,538	9/4/2022
1.26.5	299,028	6/30/2022
1.26.4	7,480	6/26/2022
1.26.3	229,370	6/7/2022
1.26.2	224,466	4/21/2022
1.26.1	11,143	4/17/2022
1.26.0	219,074	4/12/2022
1.24.2	3,951	3/17/2022
1.24.1	5,536	3/15/2022
1.24.0	15,581	3/9/2022
1.23.2	8,160	3/4/2022
1.23.1	226,866	2/14/2022
1.22.0	3,988	2/12/2022
0.21.5	34,822	2/7/2022
0.21.4	9,082	1/27/2022
0.19.1	280,461	11/15/2021
0.19.0	14,051	10/21/2021
0.18.0	17,620	9/13/2021
0.17.5	248,208	8/20/2021
0.17.4	5,764	8/17/2021
0.17.2	253,320	6/30/2021
0.17.1	6,992	6/23/2021
0.17.0	6,741	6/21/2021
0.16.1	5,280	6/19/2021
0.16.0	3,997	6/19/2021
0.15.5	5,605	6/13/2021
0.15.4	4,134	6/8/2021
0.15.2	10,833	5/20/2021
0.15.1	3,874	5/19/2021
0.14.8	4,342	5/18/2021
0.14.7	4,151	5/17/2021
0.14.6	5,353	5/13/2021
0.14.5	4,298	5/12/2021
0.14.4	3,885	5/12/2021
0.14.3	5,427	5/10/2021
0.14.2	3,887	5/10/2021
0.14.1	5,284	5/7/2021
0.14.0	3,953	5/7/2021
0.13.5	5,542	4/30/2021
0.13.4	5,937	4/26/2021
0.13.3	6,106	4/22/2021
0.13.2	5,630	4/20/2021
0.13.1	4,046	4/18/2021
0.13.0	3,861	4/16/2021
0.12.2	3,746	4/15/2021
0.12.1	3,660	4/14/2021
0.12.0-beta	2,363	4/13/2021
0.11.1	5,481	4/9/2021
0.11.0	3,824	4/8/2021
0.10.3	3,752	4/6/2021
0.10.2	3,719	4/6/2021
0.10.1	3,729	4/4/2021
0.10.0	3,711	4/2/2021
0.9.1	3,756	4/1/2021
0.9.0	3,664	4/1/2021
0.8.0	3,940	3/29/2021
0.7.0	3,721	3/28/2021
0.6.0	3,744	3/26/2021
0.5.0	3,690	3/26/2021
0.4.0	3,706	3/25/2021
0.3.0	3,664	3/21/2021
0.2.3	3,795	3/20/2021
0.2.2	4,013	3/18/2021
0.2.1	3,919	3/17/2021
0.2.0	3,960	3/15/2021
0.1.0-preview	2,549	3/15/2021
0.0.7-beta	2,531	3/14/2021
0.0.6-beta	2,544	3/14/2021
0.0.5-beta	2,656	3/14/2021
0.0.4-beta	2,537	3/14/2021
0.0.3-beta	2,502	3/13/2021
0.0.2-beta	2,462	3/4/2021
0.0.1-beta	2,476	3/3/2021

Please Check [Release Notes](https://github.com/mini-software/MiniExcel/tree/master/docs)