Show / Hide Table of Contents

Namespace OfficeOpenXml

Classes

CalculationExtension

Extentions methods for formula calculation.

ExcelAddress

Range address with the address property readonly

ExcelAddressBase

A range address

ExcelBackgroundImage

An image that fills the background of the worksheet.

ExcelCellAddress

A single cell address

ExcelCellBase

Base class containing cell address manipulating methods.

ExcelChartsheet

Represents an Excel Chartsheet and provides access to its properties and methods

ExcelColumn

Represents one or more columns within the worksheet

ExcelComment

An Excel Cell Comment

ExcelCommentCollection

Collection of Excel Comment objects

ExcelEncryption

How and if the workbook is encrypted ExcelProtection ExcelSheetProtection

ExcelErrorValue

Represents an Excel error.

ExcelErrorValue.Values

Handles the convertion between eErrorType and the string values used by Excel.

ExcelFormulaAddress

Range address used in the formula parser

ExcelHeaderFooter

Represents the Header and Footer on an Excel Worksheet

ExcelHeaderFooterText

Print header and footer

ExcelHyperLink

HyperlinkClass

ExcelIgnoredError

Error ignore options for a worksheet

ExcelIgnoredErrorCollection

A collection of ignored errors per range for a worksheet

ExcelNamedRange

A named range.

ExcelNamedRangeCollection

Collection for named ranges

ExcelOutputTextFormat

Describes how to split a CSV text. Used by the ExcelRange.SaveFromText method

ExcelPackage

Represents an Excel 2007/2010 XLSX file package.
This is the top-level object to access all parts of the document.

ExcelPrinterSettings

Printer settings

ExcelProtectedRange

A protected range in a worksheet ExcelProtection ExcelSheetProtection ExcelEncryption

ExcelProtectedRangeCollection

A collection of protected ranges in the worksheet. ExcelProtection ExcelSheetProtection ExcelEncryption

ExcelProtection

Sets protection on the workbook level ExcelEncryption ExcelSheetProtection

ExcelRange

A range of cells.

ExcelRangeBase

A range of cells

ExcelRow

Represents an individual row in the spreadsheet.

ExcelSheetProtection

Sheet protection ExcelEncryption ExcelProtection

ExcelStyleCollection<T>

Base collection class for styles.

ExcelStyles

Containts all shared cell styles for a workbook

ExcelTableAddress

Extended address information for a table address

ExcelTextFormat

Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method

ExcelTextFormatBase

Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormat and ExcelOutputTextFormat ExcelTextFormat ExcelOutputTextFormat

ExcelWorkbook

Represents the Excel workbook and provides access to all the document properties and worksheets within the workbook.

ExcelWorkbookView

Access to workbook view properties

ExcelWorksheet

Represents an Excel worksheet and provides access to its properties and methods

ExcelWorksheet.MergeCellsCollection

Collection containing merged cell addresses

ExcelWorksheets

The collection of worksheets for the workbook

ExcelWorksheetView

Represents the different view states of the worksheet

ExcelWorksheetView.ExcelWorksheetPanes

The worksheet panes after a freeze or split.

FontSize

A collection of fonts and there size in pixels used when determining auto widths for columns. This is used as .NET and Excel does not measure font widths in pixels in a similar way.

FontSizeInfo

Defines font size in pixels for different font families and sized used when determining auto widths for columns. This is used as .NET and Excel does not measure font widths in pixels in a similar way.

LicenseException

An exception thrown when the license context of EPPlus hasn't been set.

OfficeProperties

Provides access to the properties bag of the package

XmlHelper

Abstract helper class containing functionality to work with XML inside the package.

Enums

CompressionLevel

Maps to DotNetZips CompressionLevel enum

eDataTypes

Discribes a column when reading a text using the ExcelRangeBase.LoadFromText method

eErrorType

Represents the errortypes in excel

EncryptionAlgorithm

Encryption Algorithm

EncryptionVersion

The major version of the Encryption

eOrientation

Printer orientation

ePageOrder

Specifies printed page order

ePaperSize

Papersize

eShiftTypeDelete

Tells how cells should be shifted in a delete operation

eShiftTypeInsert

Tells how cells should be shifted in a insert operation

eWorkSheetHidden

Worksheet hidden enumeration

ExcelCalcMode

How the application should calculate formulas in the workbook

ExcelRangeCopyOptionFlags

Flag enum, specify all flags that you want to exclude from the copy.

LicenseContext

Specifies with license EPPlus is used under. Licensetype must be specified in order to use the library LicenseContext

PictureAlignment

How a picture will be aligned in the header/footer

Back to top Generated by DocFX