# EPPlus Documentation

> Documentation for EPPlus, the .NET spreadsheet library

Guides for EPPlus, the .NET library for reading, writing and rendering Excel spreadsheets (Office Open XML). The API reference for each version is at https://epplussoftware.com/docs/api/.

## Getting started

- [Introduction](<https://epplussoftware.com/docs/index.md>)
- [Configuration](<https://epplussoftware.com/docs/getting-started/configuration/index.md>)
- [EPPlus and Blazor](<https://epplussoftware.com/docs/getting-started/epplus-and-blazor/index.md>)
- [EPPlus and Docker](<https://epplussoftware.com/docs/getting-started/epplus-and-docker/index.md>)
- [EPPlus and Linux](<https://epplussoftware.com/docs/getting-started/epplus-and-linux/index.md>)
- [Overview](<https://epplussoftware.com/docs/getting-started/index.md>)
- [The Sample Project](<https://epplussoftware.com/docs/getting-started/the-sample-project/index.md>)

## Versions and breaking changes

- [Breaking Changes in EPPlus 5](<https://epplussoftware.com/docs/versions/breaking-changes-in-epplus-5/index.md>)
- [Breaking Changes in EPPlus 6](<https://epplussoftware.com/docs/versions/breaking-changes-in-epplus-6/index.md>)
- [Breaking Changes in EPPlus 7](<https://epplussoftware.com/docs/versions/breaking-changes-in-epplus-7/index.md>)
- [Breaking Changes in EPPlus 8](<https://epplussoftware.com/docs/versions/breaking-changes-in-epplus-8/index.md>)
- [Overview](<https://epplussoftware.com/docs/versions/index.md>)
- [Releases/versioning](<https://epplussoftware.com/docs/versions/releases-versioning/index.md>)

## Worksheets and ranges

- [Addressing a worksheet](<https://epplussoftware.com/docs/worksheet-and-ranges/addressing-a-worksheet/index.md>)
- [Autofit columns](<https://epplussoftware.com/docs/worksheet-and-ranges/autofit-columns/index.md>)
- [Overview](<https://epplussoftware.com/docs/worksheet-and-ranges/comments/index.md>)
- [Comments/Notes](<https://epplussoftware.com/docs/worksheet-and-ranges/comments/notes/index.md>)
- [Threaded Comments](<https://epplussoftware.com/docs/worksheet-and-ranges/comments/threaded-comments/index.md>)
- [Copying ranges/sheets](<https://epplussoftware.com/docs/worksheet-and-ranges/copy-ranges-or-entire-worksheets/index.md>)
- [Data Validation and ExcelFormula](<https://epplussoftware.com/docs/worksheet-and-ranges/data-validation/data-validation-and-excelformula/index.md>)
- [Data validation Examples](<https://epplussoftware.com/docs/worksheet-and-ranges/data-validation/examples/index.md>)
- [Data validation exceptions](<https://epplussoftware.com/docs/worksheet-and-ranges/data-validation/exceptions/index.md>)
- [Overview](<https://epplussoftware.com/docs/worksheet-and-ranges/data-validation/index.md>)
- [Data validation Properties](<https://epplussoftware.com/docs/worksheet-and-ranges/data-validation/properties/index.md>)
- [Dimension/Used range](<https://epplussoftware.com/docs/worksheet-and-ranges/dimension-used-range/index.md>)
- [Filling ranges](<https://epplussoftware.com/docs/worksheet-and-ranges/fill-ranges/index.md>)
- [Freeze and Split Panes](<https://epplussoftware.com/docs/worksheet-and-ranges/freeze-and-split-panes/index.md>)
- [Grouping and Ungrouping Rows and Columns](<https://epplussoftware.com/docs/worksheet-and-ranges/grouping-and-ungrouping-rows-and-columns/index.md>)
- [Header and Footer](<https://epplussoftware.com/docs/worksheet-and-ranges/header-and-footer/index.md>)
- [Hyperlinks](<https://epplussoftware.com/docs/worksheet-and-ranges/hyperlinks/index.md>)
- [Overview](<https://epplussoftware.com/docs/worksheet-and-ranges/index.md>)
- [Insert/Delete](<https://epplussoftware.com/docs/worksheet-and-ranges/insert-and-delete-rows-columns-and-ranges/index.md>)
- [Sorting ranges](<https://epplussoftware.com/docs/worksheet-and-ranges/sorting-ranges/index.md>)
- [Taking and skipping columns/rows](<https://epplussoftware.com/docs/worksheet-and-ranges/taking-and-skipping-columns-from-a-range/index.md>)

## Styling

- [Advanced Color Options Example](<https://epplussoftware.com/docs/styling/conditional-formatting/colors/index.md>)
- [Custom Iconsets Example](<https://epplussoftware.com/docs/styling/conditional-formatting/custom-iconsets/index.md>)
- [Databar Example](<https://epplussoftware.com/docs/styling/conditional-formatting/databars/index.md>)
- [Overview](<https://epplussoftware.com/docs/styling/conditional-formatting/index.md>)
- [Order In the worksheet on Load](<https://epplussoftware.com/docs/styling/conditional-formatting/order-in-the-worksheet/index.md>)
- [Priority Example](<https://epplussoftware.com/docs/styling/conditional-formatting/priority/index.md>)
- [Color Scale example](<https://epplussoftware.com/docs/styling/conditional-formatting/three-color-scale-example/index.md>)
- [Icon Set example](<https://epplussoftware.com/docs/styling/conditional-formatting/three-icon-set-example/index.md>)
- [Formatting and styling](<https://epplussoftware.com/docs/styling/formatting-and-styling/index.md>)
- [Overview](<https://epplussoftware.com/docs/styling/index.md>)
- [The ExcelRange.Text property](<https://epplussoftware.com/docs/styling/the-excelrange-text-property/index.md>)
- [Using Themes](<https://epplussoftware.com/docs/styling/using-themes/index.md>)
- [Working with custom named table- or slicer- styles](<https://epplussoftware.com/docs/styling/working-with-custom-named-table-or-slicer-styles/index.md>)

## Import and export data

- [Overview](<https://epplussoftware.com/docs/import-export-data/export/index.md>)
- [ToJson](<https://epplussoftware.com/docs/import-export-data/export/json-export/index.md>)
- [SaveToText](<https://epplussoftware.com/docs/import-export-data/export/savetotext/index.md>)
- [ToCollection](<https://epplussoftware.com/docs/import-export-data/export/tocollection/index.md>)
- [ToDataTable](<https://epplussoftware.com/docs/import-export-data/export/todatatable/index.md>)
- [ToText (Fixed-width text files)](<https://epplussoftware.com/docs/import-export-data/export/totext-fixed-width-text-files/index.md>)
- [ToText](<https://epplussoftware.com/docs/import-export-data/export/totext/index.md>)
- [External connections &amp; query tables](<https://epplussoftware.com/docs/import-export-data/external-connections-and-query-tables/index.md>)
- [Overview](<https://epplussoftware.com/docs/import-export-data/import/index.md>)
- [LoadFromArrays](<https://epplussoftware.com/docs/import-export-data/import/loadfromarrays/index.md>)
- [LoadFromCollection (attributes)](<https://epplussoftware.com/docs/import-export-data/import/loadfromcollection-using-attributes/index.md>)
- [LoadFromCollection](<https://epplussoftware.com/docs/import-export-data/import/loadfromcollection/index.md>)
- [LoadFromDataReader](<https://epplussoftware.com/docs/import-export-data/import/loadfromdatareader/index.md>)
- [LoadFromDataTable](<https://epplussoftware.com/docs/import-export-data/import/loadfromdatatable/index.md>)
- [LoadFromDictionaries](<https://epplussoftware.com/docs/import-export-data/import/loadfromdictionaries/index.md>)
- [LoadFromText (fixed-width text files)](<https://epplussoftware.com/docs/import-export-data/import/loadfromtext-fixed-width-text-files/index.md>)
- [LoadFromText](<https://epplussoftware.com/docs/import-export-data/import/loadfromtext/index.md>)
- [Overview](<https://epplussoftware.com/docs/import-export-data/index.md>)

## Output formats

- [Configure fonts](<https://epplussoftware.com/docs/output-formats/fonts/configure-fonts/index.md>)
- [Font fallbacks](<https://epplussoftware.com/docs/output-formats/fonts/fallbacks/index.md>)
- [Overview](<https://epplussoftware.com/docs/output-formats/fonts/index.md>)
- [Accessibility](<https://epplussoftware.com/docs/output-formats/html/accessibility/index.md>)
- [Data attributes](<https://epplussoftware.com/docs/output-formats/html/data-attributes/index.md>)
- [Overview](<https://epplussoftware.com/docs/output-formats/html/index.md>)
- [Settings](<https://epplussoftware.com/docs/output-formats/html/settings/index.md>)
- [Overview](<https://epplussoftware.com/docs/output-formats/index.md>)
- [Overview](<https://epplussoftware.com/docs/output-formats/pdf/index.md>)
- [Page setup](<https://epplussoftware.com/docs/output-formats/pdf/page-setup/index.md>)
- [Saving to PDF](<https://epplussoftware.com/docs/output-formats/pdf/saving/index.md>)

## Formulas and filters

- [Working with External Workbooks](<https://epplussoftware.com/docs/formulas-and-filters/external-links/index.md>)
- [Cancelling a calculation](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/cancelling-a-calculation/index.md>)
- [Circular references](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/circular-references/index.md>)
- [Custom functions for calculations](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/custom-functions-for-calculations/index.md>)
- [Dynamic array formulas](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/dynamic-arrayformulas/index.md>)
- [Function prefixes](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/function-prefixes/index.md>)
- [Overview](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/index.md>)
- [Legacy array formulas](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/legacy-arrayformulas/index.md>)
- [Precision as Displayed](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/precision-as-displayed/index.md>)
- [Referencing tables in formulas](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/referencing-tables-in-formulas/index.md>)
- [Regression analysis functions](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/regression-analysis-functions/index.md>)
- [Security considerations](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/security-considerations-when-calculating-formulas/index.md>)
- [Supported Functions](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/supported-functions/index.md>)
- [Trim reference operator](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/trim-reference-operator/index.md>)
- [Lambda functions](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/using-lambda-functions/index.md>)
- [Overview](<https://epplussoftware.com/docs/formulas-and-filters/index.md>)
- [Working with filters](<https://epplussoftware.com/docs/formulas-and-filters/working-with-filters/index.md>)
- [Working with slicers](<https://epplussoftware.com/docs/formulas-and-filters/working-with-slicers/index.md>)

## Charts and drawing objects

- [In-cell pictures](<https://epplussoftware.com/docs/charts-and-drawing-objects/cell-pictures/index.md>)
- [Chart samples](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/chart-samples/index.md>)
- [Overview](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/index.md>)
- [Styling Charts](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/styling-charts/index.md>)
- [Supported Charts](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/supported-charts/index.md>)
- [Using chart templates](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/using-chart-templates/index.md>)
- [Copy Drawings](<https://epplussoftware.com/docs/charts-and-drawing-objects/copy-drawings/index.md>)
- [Form Controls](<https://epplussoftware.com/docs/charts-and-drawing-objects/form-controls/index.md>)
- [Overview](<https://epplussoftware.com/docs/charts-and-drawing-objects/index.md>)
- [OLE Objects](<https://epplussoftware.com/docs/charts-and-drawing-objects/ole-objects/index.md>)
- [Pictures](<https://epplussoftware.com/docs/charts-and-drawing-objects/pictures/index.md>)
- [Shapes](<https://epplussoftware.com/docs/charts-and-drawing-objects/shapes/index.md>)
- [Sparklines](<https://epplussoftware.com/docs/charts-and-drawing-objects/sparklines/index.md>)

## Tables and pivot tables

- [Overview](<https://epplussoftware.com/docs/tables-and-pivot-tables/index.md>)
- [Calculating Pivot tables](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/calculating-pivot-tables/index.md>)
- [Custom pivot table styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/custom-pivot-table-styles/index.md>)
- [Using the Data-field - ShowDataAs property](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/data-field-showdataas/index.md>)
- [Expanding and collapsing Pivot Table items](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/expanding-and-collapsing-pivot-table-items/index.md>)
- [Overview](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/index.md>)
- [Filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-filters-and-slicers/index.md>)
- [Sorting](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-sorting/index.md>)
- [Styling via pivot areas](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-styling-via-pivot-areas/index.md>)
- [Built in Table styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/built-in-table-styles/index.md>)
- [Custom Table Styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/custom-table-styles/index.md>)
- [Overview](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/index.md>)
- [Sorting tables](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/sorting-tables/index.md>)
- [Table filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/table-filters-and-slicers/index.md>)
- [Working with DataRows](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/working-with-datarows/index.md>)

## VBA and protection

- [Signature lines and stamps](<https://epplussoftware.com/docs/vba-and-protection/digital-signatures/digital-signature-lines-and-stamps/index.md>)
- [Overview](<https://epplussoftware.com/docs/vba-and-protection/digital-signatures/index.md>)
- [Encrypt and Protect your workbook](<https://epplussoftware.com/docs/vba-and-protection/encrypt-and-protect-your-workbook/index.md>)
- [Overview](<https://epplussoftware.com/docs/vba-and-protection/index.md>)
- [VBA](<https://epplussoftware.com/docs/vba-and-protection/vba/index.md>)
- [Working with Sensibility Labels](<https://epplussoftware.com/docs/vba-and-protection/working-with-sensibility-labels/index.md>)

## About EPPlus

- [Branching strategy and CI](<https://epplussoftware.com/docs/about-epplus/branching-strategy-and-ci/index.md>)
- [Overview](<https://epplussoftware.com/docs/about-epplus/index.md>)
- [Roadmap](<https://epplussoftware.com/docs/about-epplus/roadmap/index.md>)
- [Security](<https://epplussoftware.com/docs/about-epplus/security/index.md>)
- [Using our develop nuget feed](<https://epplussoftware.com/docs/about-epplus/using-our-develop-nuget-feed/index.md>)