Add Custom Logic to Excel Formulas

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The EPPlus v8.2.0 update introduces support for eight new LAMBDA-based functions, giving developers greater flexibility and control when working with Excel workbook calculations. With these additions, you can now define custom functions directly in the workbook, streamline array transformations, apply operations by row or column, and handle iterative or conditional logic more efficiently. This enhancement reduces the need for repetitive formulas or external code, enabling cleaner, more maintainable spreadsheets that better align with modern programming practices.

To see a full list of what's new in v8.2.0, see our release notes.

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.