EPPlus has been widely used in various .NET environments to create/read/update spreadsheets – in SAAS platforms and internal systems, on-premise and in the cloud. It has also made its way into the Docker/Web assembly world.

EPPlus Features

• Workbook
  • Document/Printer settings.
• Worksheets
  • Supports 1,048,576 rows and 16,384 columns.
  • Add, remove, re-order, rename, hide/unhide worksheets in a workbook.
  • Copy worksheets within a workbook or to another workbook with maintained styling and shifting of addresses/references.
  • Print areas.
  • Group/ungroup/collapse/expand rows and columns.
  • Header/Footer.
  • Page breaks.
  • Split/Freeze/unfreeze panes.
  • Merge cells.
  • Autofit columns.
  • Altering worksheet properties such as gridlines, tab colors, etc.
• Cell Ranges
  • Create, modify, delete, hide/unhide cells or entire ranges.
  • Access to Row and Column properties via the EntireRow and EntireColumn properties.
  • Sort ranges
    • Multiple sort params.
    • Sort Top to Bottom (by column).
    • Sort Left to Right (by row).
    • Ascending, Descending or User defined (Custom List) sortorder.
    • Updates Sort State in the Office Open XML.
  • Insert/delete ranges - depending addresses will be shifted.
  • Copy ranges to a new address with maintained styling and addresses/reference shifting within a workbook or to another workbook. Exclude different cell properties in the copy operation.
  • Copy styles only.
  • Fill ranges
    • FillNumber.
    • FillDateTime.
    • FillList.
  • Named ranges.
  • The cell store supports IEnumerable, so Cells/Ranges can be queried with Linq.
• Cell Styling
  • Number.
  • Alignment.
  • Font.
  • Fill.
  • Border.
  • Protection.
  • Wrap text, text rotations and more.
  • Named Styles.
• Formula calculation
  • Built-in calculation engine with no dependency to Excel or any other library.
  • Calculate entire workbook, a worksheet or a single range.
  • Supports 452 functions.
  • Supports dynamic array formulas and legacy arrayformulas.
  • Supports Precision as Displayed in calculations (numeric cell values will be rounded according to the cell's number format).
  • Calculates External links.
  • Support for named ranges and the R1C1 format.
  • Add custom functions in runtime.
• Import/export data to and from worksheets
  • Import data into a formatted table from enumerables of objects, arrays, DataSets, DataReaders, text-files, etc., with just one line of code.
  • Export data to csv files, strings, json, html/css, data tables, IEnumerable<T> or streams with many configuration parameters.
• Supports load and save from/to both files and streams
  • Can create workbooks in a web application and write to the response stream without file access.
  • Get workbook as byte-array.
  • Supports async/await.
• Templates.
• Auto filters/Table Filters
  • Create, read, modify, apply and delete filters of the types below:
    • Value filters.
    • Date/Time filters.
    • Custom filters.
    • Top 10 filters.
    • Dynamic filters.
• Data validation
  • Create, read, modify, delete Data validations.
  • Types of validations supported: Integer (whole in Excel), Decimal, List, Date, Time, Any and Custom.
  • Strongly typed interface for each validation type.
• Conditional Formatting
  • Create, read, modify Conditional formatting.
  • 40+ types of conditional formatting supported.
  • Strongly typed interface for each conditional formatting type.
• Tables
  • 60+ predefined styles.
  • Create and modify custom table styles from scratch or using a built-in style as template.
  • Sort table with updated sort state.
  • Support for adding and deleting rows/columns (with shifting).
  • Total row with predefined functions (supported by the built-in Formula calculation).
  • Adding, modifying and applying filters.
  • Adding, modifying or removing table slicers.
  • Export table to a System.Data.DataTable.
  • Export table to JSON.
  • Export table to html/css.
  • Export table to an IEnumerable<T>.
• Pivot Tables
  • 80+ predefined styles
  • Support for the GETPIVOTDATA function in calculations.
  • Support for Pivot table calculations.
  • Create and modify custom pivot table styles from scratch or using a built-in style as template.
  • Style your pivot table using pivot areas.
  • Add, modify or remove row, column, page and data fields.
  • Support for 12 different data field functions.
  • Support for numeric and date grouping.
  • Adding calculated fields.
  • Support for adding, modifying filters.
  • Adding, modifying or removing pivot table slicers.
• Slicers
  • Adding, modifying or removing table- and pivot table- slicers.
  • 10+ predefined styles.
  • Create and modify custom slicer styles from scratch or using a built-in style as template.
• Hyperlinks
• Comments
  • Create, read, modify and delete comments (in later Excel versions renamed to Notes).
  • Rich-text supported.
  • Threaded comments with support for mentions, resolve/re-open threads.
• Shapes
  • 180+ different types of shapes supported.
  • Position, size, border, text, styling, color/gradient/effect/shadow, etc.
• Pictures
  • Supports adding images from file, stream or a System.Drawing.Image object.
  • Formats: jpg, gif, png, tiff, bmp, emf, wmf, ico, svg, webp
• Form Controls
  • Supports adding, modifying and removing nine different types of form controls.
  • Support to connect controls to VBA macros, link to cells and more.
• Charts
  • Support for all Excel chart types.
  • Full support for modern chart styling.
  • Load charts using crtx-files.
  • Strongly typed classes for the different chart types.
• Sparklines
  • Create, read, modify and delete Sparklines.
  • Line.
  • Column.
  • Win/loss.
• Themes
  • Load themes from thmx-files.
  • Modify current theme.
• External Links
  • Updating the external workbook cache (xlsx, xlsm and xlst).
  • Adding references to external workbooks.
  • Breaking links to external workbooks.
  • Retaining OLE and DDE links (available read only).
  • Formula calculation via the external workbook cache or via loading and calculating the external package directly.
• Protection
  • Protect workbooks with password.
  • Open protected workbooks with password.
  • Protect workbook, worksheets or ranges.
  • Set workbooks to read-only with a password.
• Encryption
  • Encrypt/decrypt workbooks.
  • Supports both Standard (Older office versions) and Agile encryption (Office 2010 and later).
• VBA
  • Create, read, delete, modify VBA code/modules.
  • Sign VBA code with certificates, supports Legacy, Agile and V3 signature. Supports 5 different hash algorithms for the signature.
  • Password protect VBA projects.
• Supported formats
  • Reads and writes xlsx, xlsm. Please note that EPPlus does not support the xlsx Strict format.
  • Reads xltx, crtx, thmx.
  • Reads and writes txt, csv via the LoadFromText and SaveToText methods.