How jankallman/epplus works
EPPlus is a .NET library for reading and writing Excel workbooks in Office Open XML format without Excel interop. The principal workflow is to create or load a package, work with its workbook, worksheets, and cell ranges, then save the result. The library also documents formulas, charts, drawings, validation, formatting, protection, encryption, VBA, and tables. Several feature implementations are unsampled, so their presence is represented from the README, without asserting internal call paths that the excerpts do not establish.
Main entry points: ExcelPackage.cs Excel Package · ExcelRangeBase.cs Cell Ranges · FormulaParserManager.cs Formula Manager · FunctionRepository.cs Function Repository
Components 20
Workbook Model
- Excel Package
EPPlus/ExcelPackage.cs - Workbook
EPPlus/ExcelWorkbook.cs - Worksheet
EPPlus/ExcelWorksheet.cs - Cell Ranges
EPPlus/ExcelRangeBase.cs - Range Addresses
EPPlus/ExcelAddress.cs
Spreadsheet Features
- Cell Styling
EPPlus/ExcelStyles.cs - Data Validation
EPPlus/DataValidation/ExcelDataValidationCollection.cs - Conditional Formatting
EPPlus/ConditionalFormatting/ExcelConditionalFormattingCollection.cs - Charts
EPPlus/Drawing/Chart/ExcelChart.cs - Pictures and Shapes
EPPlus/Drawing/ExcelDrawings.cs - Tables and Pivots
EPPlus/Table/ExcelTable.cs - VBA
EPPlus/VBA/ExcelVBAProject.cs - Protection
EPPlus/ExcelProtection.cs - Comments
EPPlus/ExcelCommentCollection.cs
Formula Calculation
- Formula Manager
EPPlus/FormulaParsing/FormulaParserManager.cs - Function Repository
EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs - COUNT Function
EPPlus/FormulaParsing/Excel/Functions/Math/Count.cs
Package Persistence
- OOXML Package
EPPlus/Packaging/ZipPackage.cs - Encryption
EPPlus/Encryption/EncryptionHandler.cs
Other components
- Library User
Connections 20
- Library User → Excel Package: creates or loads
- Library User → Workbook: edits workbook
- Library User → Worksheet: edits sheets
- Library User → Cell Ranges: edits ranges
- Library User → Excel Package: saves workbook
EPPlus/ExcelPackage.cs - Excel Package → OOXML Package: packages workbook
EPPlus/ExcelPackage.cs - Excel Package → Encryption: encrypts output
EPPlus/ExcelPackage.cs - Formula Manager → Function Repository: configures functions
EPPlus/FormulaParsing/FormulaParserManager.cs - Function Repository → COUNT Function: registers functions
- Library User → Cell Styling: formats cells
- Library User → Data Validation: sets validation
- Library User → Conditional Formatting: sets rules
- Library User → Charts: creates charts
- Library User → Pictures and Shapes: adds drawings
- Library User → Tables and Pivots: creates tables
- Library User → Formula Manager: calculates formulas
- Library User → VBA: uses VBA
- Library User → Protection: protects sheets
- Library User → Comments: adds comments
- Cell Ranges → Range Addresses: uses addresses