# jankallman/epplus architecture

> Architecture diagram of the GitHub repository jankallman/epplus, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jankallman/epplus
- Repository: https://github.com/jankallman/epplus

## Overview

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: [`EPPlus/ExcelPackage.cs`](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelPackage.cs) (Excel Package), [`EPPlus/ExcelRangeBase.cs`](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelRangeBase.cs) (Cell Ranges), [`EPPlus/FormulaParsing/FormulaParserManager.cs`](https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/FormulaParserManager.cs) (Formula Manager), [`EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs`](https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs) (Function Repository)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workbook["Workbook Model"]
  node_package["Excel Package<br/>[ExcelPackage.cs]"]
  node_workbook_model["Workbook<br/>[ExcelWorkbook.cs]"]
  node_worksheet["Worksheet<br/>[ExcelWorksheet.cs]"]
  node_range["Cell Ranges<br/>[ExcelRangeBase.cs]"]
  node_address["Range Addresses<br/>[ExcelAddress.cs]"]
end

subgraph group_features["Spreadsheet Features"]
  node_styles["Cell Styling<br/>[ExcelStyles.cs]"]
  node_validation["Data Validation"]
  node_conditional["Conditional Formatting"]
  node_charts["Charts<br/>[ExcelChart.cs]"]
  node_drawings["Pictures and Shapes<br/>[ExcelDrawings.cs]"]
  node_tables["Tables and Pivots<br/>[ExcelTable.cs]"]
  node_vba["VBA<br/>[ExcelVBAProject.cs]"]
  node_protection["Protection<br/>[ExcelProtection.cs]"]
  node_comments["Comments"]
end

subgraph group_calculation["Formula Calculation"]
  node_formula_manager["Formula Manager"]
  node_function_repo["Function Repository"]
  node_count_function["COUNT Function<br/>[Count.cs]"]
end

subgraph group_persistence["Package Persistence"]
  node_zip_package["OOXML Package<br/>[ZipPackage.cs]"]
  node_encryption["Encryption"]
end

node_user(("Library User"))

node_user -->|"creates or loads"| node_package
node_user -.->|"edits workbook"| node_workbook_model
node_user -.->|"edits sheets"| node_worksheet
node_user -.->|"edits ranges"| node_range
node_user -->|"saves workbook"| node_package
node_package -->|"packages workbook"| node_zip_package
node_package -->|"encrypts output"| node_encryption
node_formula_manager -->|"configures functions"| node_function_repo
node_function_repo -.->|"registers functions"| node_count_function
node_user -.->|"formats cells"| node_styles
node_user -.->|"sets validation"| node_validation
node_user -.->|"sets rules"| node_conditional
node_user -.->|"creates charts"| node_charts
node_user -.->|"adds drawings"| node_drawings
node_user -.->|"creates tables"| node_tables
node_user -.->|"calculates formulas"| node_formula_manager
node_user -.->|"uses VBA"| node_vba
node_user -.->|"protects sheets"| node_protection
node_user -.->|"adds comments"| node_comments
node_range -.->|"uses addresses"| node_address

click node_package "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelPackage.cs"
click node_workbook_model "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelWorkbook.cs"
click node_worksheet "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelWorksheet.cs"
click node_range "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelRangeBase.cs"
click node_address "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelAddress.cs"
click node_styles "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelStyles.cs"
click node_validation "https://github.com/jankallman/epplus/blob/master/EPPlus/DataValidation/ExcelDataValidationCollection.cs"
click node_conditional "https://github.com/jankallman/epplus/blob/master/EPPlus/ConditionalFormatting/ExcelConditionalFormattingCollection.cs"
click node_charts "https://github.com/jankallman/epplus/blob/master/EPPlus/Drawing/Chart/ExcelChart.cs"
click node_drawings "https://github.com/jankallman/epplus/blob/master/EPPlus/Drawing/ExcelDrawings.cs"
click node_tables "https://github.com/jankallman/epplus/blob/master/EPPlus/Table/ExcelTable.cs"
click node_formula_manager "https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/FormulaParserManager.cs"
click node_function_repo "https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs"
click node_count_function "https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/Excel/Functions/Math/Count.cs"
click node_zip_package "https://github.com/jankallman/epplus/blob/master/EPPlus/Packaging/ZipPackage.cs"
click node_encryption "https://github.com/jankallman/epplus/blob/master/EPPlus/Encryption/EncryptionHandler.cs"
click node_vba "https://github.com/jankallman/epplus/blob/master/EPPlus/VBA/ExcelVBAProject.cs"
click node_protection "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelProtection.cs"
click node_comments "https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelCommentCollection.cs"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_package,node_workbook_model,node_worksheet,node_range,node_address,node_user toneBlue
class node_styles,node_validation,node_conditional,node_charts,node_drawings,node_tables,node_vba,node_protection,node_comments toneAmber
class node_formula_manager,node_function_repo,node_count_function toneMint
class node_zip_package,node_encryption toneRose
```

## Components

### Workbook Model

- [Excel Package](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelPackage.cs): `EPPlus/ExcelPackage.cs`
- [Workbook](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelWorkbook.cs): `EPPlus/ExcelWorkbook.cs`
- [Worksheet](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelWorksheet.cs): `EPPlus/ExcelWorksheet.cs`
- [Cell Ranges](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelRangeBase.cs): `EPPlus/ExcelRangeBase.cs`
- [Range Addresses](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelAddress.cs): `EPPlus/ExcelAddress.cs`

### Spreadsheet Features

- [Cell Styling](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelStyles.cs): `EPPlus/ExcelStyles.cs`
- [Data Validation](https://github.com/jankallman/epplus/blob/master/EPPlus/DataValidation/ExcelDataValidationCollection.cs): `EPPlus/DataValidation/ExcelDataValidationCollection.cs`
- [Conditional Formatting](https://github.com/jankallman/epplus/blob/master/EPPlus/ConditionalFormatting/ExcelConditionalFormattingCollection.cs): `EPPlus/ConditionalFormatting/ExcelConditionalFormattingCollection.cs`
- [Charts](https://github.com/jankallman/epplus/blob/master/EPPlus/Drawing/Chart/ExcelChart.cs): `EPPlus/Drawing/Chart/ExcelChart.cs`
- [Pictures and Shapes](https://github.com/jankallman/epplus/blob/master/EPPlus/Drawing/ExcelDrawings.cs): `EPPlus/Drawing/ExcelDrawings.cs`
- [Tables and Pivots](https://github.com/jankallman/epplus/blob/master/EPPlus/Table/ExcelTable.cs): `EPPlus/Table/ExcelTable.cs`
- [VBA](https://github.com/jankallman/epplus/blob/master/EPPlus/VBA/ExcelVBAProject.cs): `EPPlus/VBA/ExcelVBAProject.cs`
- [Protection](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelProtection.cs): `EPPlus/ExcelProtection.cs`
- [Comments](https://github.com/jankallman/epplus/blob/master/EPPlus/ExcelCommentCollection.cs): `EPPlus/ExcelCommentCollection.cs`

### Formula Calculation

- [Formula Manager](https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/FormulaParserManager.cs): `EPPlus/FormulaParsing/FormulaParserManager.cs`
- [Function Repository](https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs): `EPPlus/FormulaParsing/Excel/Functions/FunctionRepository.cs`
- [COUNT Function](https://github.com/jankallman/epplus/blob/master/EPPlus/FormulaParsing/Excel/Functions/Math/Count.cs): `EPPlus/FormulaParsing/Excel/Functions/Math/Count.cs`

### Package Persistence

- [OOXML Package](https://github.com/jankallman/epplus/blob/master/EPPlus/Packaging/ZipPackage.cs): `EPPlus/Packaging/ZipPackage.cs`
- [Encryption](https://github.com/jankallman/epplus/blob/master/EPPlus/Encryption/EncryptionHandler.cs): `EPPlus/Encryption/EncryptionHandler.cs`

### Other components

- **Library User**

## Connections

- 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 (evidence: `EPPlus/ExcelPackage.cs`)
- Excel Package → OOXML Package: packages workbook (evidence: `EPPlus/ExcelPackage.cs`)
- Excel Package → Encryption: encrypts output (evidence: `EPPlus/ExcelPackage.cs`)
- Formula Manager → Function Repository: configures functions (evidence: `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
