PanoramicData.EPPlus
10.1.9
dotnet add package PanoramicData.EPPlus --version 10.1.9
NuGet\Install-Package PanoramicData.EPPlus -Version 10.1.9
<PackageReference Include="PanoramicData.EPPlus" Version="10.1.9" />
<PackageVersion Include="PanoramicData.EPPlus" Version="10.1.9" />
<PackageReference Include="PanoramicData.EPPlus" />
paket add PanoramicData.EPPlus --version 10.1.9
#r "nuget: PanoramicData.EPPlus, 10.1.9"
#:package PanoramicData.EPPlus@10.1.9
#addin nuget:?package=PanoramicData.EPPlus&version=10.1.9
#tool nuget:?package=PanoramicData.EPPlus&version=10.1.9
Continuous Version of EPPlus Free Edition 4.5.3.3
The JanKallman/EPPlus repository has been archived by the owner. So I fork it to my repository and continue to maintain the source code.
This repository has moved to https://github.com/EPPlusSoftware/EPPlus.
The code in this archive represents the final version of EPPlus under LGPL. There will be no more activity here.
EPPlus will from version 5 switch license from LGPL to Polyform Noncommercial 1.0.0 license.
With the new license EPPlus is still free to use in some cases, but will require a commercial license to be used in a commercial business.
More information on the license change on our website
PanoramicData fork additions
AddPicture(name, imageBytes, widthPixels, heightPixels)(plus a hyperlink overload) - add pictures to a worksheet from raw image bytes (PNG, JPEG, GIF or BMP) without System.Drawing, enabling picture support on platforms where GDI+ is unavailable (System.Drawing.Common 7 and later is Windows-only, so this is the only route on e.g. Linux containers). The content type is sniffed from the byte signature and the display size is supplied in pixels at 96 DPI.
Create advanced Excel spreadsheets using .NET, without the need of interop.
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.
EPPlus supports:
- Cell Ranges
- Cell styling (Border, Color, Fill, Font, Number, Alignments)
- Data validation
- Conditional formatting
- Charts
- Pictures
- Shapes
- Comments
- Tables
- Pivot tables
- Protection
- Encryption
- VBA
- Formula calculation
- Many more...
Overview
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: EPPlus uses dictionaries to access cell data, making performance a lot better. Complete integration with .NET
Support
All support is currently referred to Stack overflow. A tutorial is available in the wiki and the sample project can be downloaded with each version. The old site at Codeplex also contains material that can be helpful. Bugs and new feature requests can be added to the issues tracker.
License
The project is licensed under the GNU Library General Public License (LGPL).
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. 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. |
-
net10.0
- Microsoft.Extensions.Configuration.Json (>= 9.0.0)
- System.Drawing.Common (>= 9.0.0)
- System.Security.Cryptography.Pkcs (>= 9.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
# Panoramic Data's EPPlus Free Edition
# LGPL License continue
Large workbooks can now be saved. A workbook that exceeded the classic ZIP limits, being 4 GB of size or offset or 65,534 internal entries, previously threw while saving, after all of its content had been built. Zip64 is now used automatically when, and only when, a workbook needs it, so files that fit the classic format are written exactly as before and remain readable by older tools.
This release targets .NET 10. The previous release, 10.1.1, targeted .NET 9.