MiniExcel 1.41.3

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
• Supports real time operation of each row of data
• Supports 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 400KB
• Easy API style to read/write/fill excel

Get Started

• Import/Query Excel

• Export/Create Excel

• Excel Template

• Excel Column Name/Index/Ignore Attribute

• Examples

Installation

You can install the package from NuGet

Release Notes

Please Check Release Notes

TODO

Please Check TODO

Performance

The code for the benchmarks can be found in MiniExcel.Benchmarks. To run all the benchmarks use:

dotnet run -project .\benchmarks\MiniExcel.Benchmarks -c Release -f net9.0 -filter * --join

Hardware and settings used are the following:

BenchmarkDotNet v0.15.0, Linux Ubuntu 24.04.2 LTS (Noble Numbat)
AMD EPYC 7763, 1 CPU, 4 logical and 2 physical cores
.NET SDK 9.0.300
  [Host]   : .NET 9.0.5 (9.0.525.21509), X64 RyuJIT AVX2
  ShortRun : .NET 9.0.5 (9.0.525.21509), X64 RyuJIT AVX2

Import/Query Excel

The file used to test performance is Test1,000,000x10.xlsx, a 32MB document containing 1,000,000 rows * 10 columns whose cells are filled with the string "HelloWorld".

Export/Create Excel

Logic: create a total of 10,000,000 "HelloWorld" cells Excel document

Warning: these results may be outdated. You can find the benchmarks for the latest release here.

Documents

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