EPPlus-LGPL is an unofficial EPPlus library which includes bug fixes beyond EPPlus 4.5.3.3 including support for .NET 6+.
$ dotnet add package EPPlus-LGPLEPPlus-LGPL is an unofficial EPPlus library which includes bug fixes beyond EPPlus 4.5.3.3 while retaining a LGPL license, such as support for .NET 8. (The official version of EPPlus v5+ is not available for commercial use without acquiring a license.)
All features are available on Windows. However, System.Drawing.Common support on Linux is deprecated on .NET 6 and removed from .NET 7 and .NET 8. This library currently relies on its support for the following features:
Font classSo long as you do not use these features, you can use this library on .NET 6+ on Linux. Note that
you can set fonts by setting the individual font properties such as Name, Bold, Italic, Size,
and so on.
To use these features on prior versions of .NET Core running on Linux, you will need to install the
libgdiplus package. For example, on Ubuntu, you can run sudo apt install libgdiplus to install it.
To use these features on .NET 6 running on Linux, you must add the below to your project file.
<ItemGroup>
<RuntimeHostConfigurationOption Include="System.Drawing.EnableUnixSupport" Value="true" />
</ItemGroup>
For more information, visit https://learn.microsoft.com/en-us/dotnet/core/compatibility/core-libraries/6.0/system-drawing-common-windows-only
Please note that the auto-sizing columns feature uses font metrics collected from a Windows PC, and may not carry metrics for the fonts you use.
EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx). EPPlus has no dependencies other than .NET.
This project started with the source from ExcelPackage. It was a great project to start from. It had the basic functionality needed to read and write a spreadsheet.
Advantages over other:
Important Notes:
.NET Core uses a preview of System.Drawing.Common, so be aware of that. We will update it as Microsoft releases newer versions. System.Drawing.Common requires libgdiplus to be installed on non-Windows operating systems. Use your favorite package manager to install it. For example:
Homebrew on MacOS:
brew install mono-libgdiplus
apt-get:
apt-get install libgdiplus
EPPlus-A .NET Spreadsheet API
4.5.3.13
4.5.3.11
4.5.3.10
4.5.3.9
4.5.3.8
4.5.3.7
4.5.3.3
4.5.3.2
4.5.3.1
4.5.3
4.5.2.1
4.5.2
4.5.1
4.5.0.3
4.5.0.2 rc
4.5.0.1 Beta 2
4.5.0.0 Beta 1
4.1.1
4.1
4.0.5 Fixes
4.0.4 Fixes
4.0.3 Fixes
4.0.2 Fixes
4.0.1 Fixes
Replaced Packaging API with DotNetZip
New Cell store
Formula Parser
The formula parser does not support Array Formulas
Performance *Of course the performance of the formula parser is nowhere near Excels. Our focus has been functionality.
Agile Encryption (Office 2012-)
Minor new features
Beta 2 Changes
Release Candidate changes
The project is licensed under the GNU Library General Public License (LGPL).
Glory to Jehovah, Lord of Lords and King of Kings, creator of Heaven and Earth, who through his Son Jesus Christ, has reedemed me to become a child of God. -Shane32