jankallman/epplus

★ 3,778C#Audience · developerComplexity · 2/5LicenseSetup · easy

Mindmap

mindmap
  root((EPPlus))
    What It Does
      Create Excel files
      Read and edit xlsx
      No Office required
    Features
      Charts and shapes
      Pivot tables
      Formula calculation
      Conditional formatting
    Setup
      .NET library
      NuGet package
    License Note
      LGPL version here
      New version needs paid license

mindmap root((EPPlus)) What It Does Create Excel files Read and edit xlsx No Office required Features Charts and shapes Pivot tables Formula calculation Conditional formatting Setup .NET library NuGet package License Note LGPL version here New version needs paid license

Click or tap to explore — scroll the page freely

Things people build with this

USE CASE 1

Generate Excel reports from application data in a .NET app without requiring Office or COM automation installed on the server

USE CASE 2

Read and modify existing xlsx files programmatically to extract, update, or reformat data

USE CASE 3

Add charts, pivot tables, or conditional formatting to Excel files generated by a C# backend service

USE CASE 4

Use the last free LGPL-licensed version of EPPlus in a commercial project that cannot adopt the newer paid commercial license

Tech stack

C#.NET

Getting it running

Difficulty · easy Time to first run · 30min

This repo contains the last LGPL-licensed release, active development is at EPPlusSoftware/EPPlus under a commercial license for business use.

This version is LGPL, you can use it in commercial software as long as you do not modify the EPPlus library code itself, modifications to the library must be published under LGPL.

In plain English

EPPlus is a .NET library that lets developers create and read Excel spreadsheet files entirely through code, without needing Microsoft Office installed on the machine running the software. It reads and writes the standard xlsx file format (the same format used by Excel 2007 and later) and has no external dependencies beyond .NET itself. The library covers a wide range of Excel features: cell ranges and styling (borders, colors, fonts, number formats, alignment), charts, pictures, shapes, comments, tables, pivot tables, data validation rules, conditional formatting, password protection, encryption, and even VBA macros. It also includes a formula calculation engine, so formulas written into cells can be evaluated without opening the file in Excel. A note on the current state of this repository: this archive represents the last version of EPPlus released under the GNU Library General Public License (LGPL), which allowed free use in commercial software. Starting with version 5, development moved to a new repository at EPPlusSoftware/EPPlus and the license changed to Polyform Noncommercial 1.0.0. Under the new license, EPPlus is free for non-commercial use but requires a paid commercial license for use in a business context. No further updates will appear here. If you are looking for the actively maintained version of EPPlus, you should go to the EPPlusSoftware organization on GitHub. If you specifically need the older LGPL-licensed code for an existing project that cannot adopt a commercial license, this repository contains that final release. Support resources include Stack Overflow (tagged epplus), a wiki with tutorials, and sample projects that shipped alongside each version.

Copy-paste prompts

Prompt 1

Help me use the EPPlus LGPL library in a C# console app to create an Excel file with three worksheets, column headers, and cells formatted with bold text and background colors

Prompt 2

Show me how to use EPPlus to open an existing xlsx file in .NET and read all values from a specific named column into a List

Prompt 3

I want to generate a bar chart in an Excel file using EPPlus, walk me through adding a chart to a worksheet based on a data table range

Prompt 4

Help me use EPPlus in a .NET project to create a pivot table that summarizes sales data by region and product category

Open on GitHub → Explain another repo

← jankallman on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.