MiniExcel 1.34.0

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

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

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

Export/Create Excel

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

Documents

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