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
ExcelColumnCollection
A collection of columns in a 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
ExcelImageSettings
This class contains settings for text measurement.
ExcelInitializationError
This class represents an error/Exception that has occured during initalization.
ExcelNamedRange
A named range.
ExcelNamedRangeCollection
Collection for named ranges
ExcelNamedStyleCollection<T>
A collection of named styles in the workbooks styles.
ExcelOutputTextFormat
Describes how to split a CSV text. Used by the ExcelRange.SaveFromText method
ExcelPackage
Represents an Excel XLSX file package.
This is the top-level object to access all parts of the document.
ExcelPackageSettings
Package generic settings
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
ExcelRangeColumn
Represents a range of columns
ExcelRangeRow
Represents a range of rows
ExcelRow
Represents an individual row in the spreadsheet.
ExcelRowsCollection
A collection of rows in a worksheet.
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
ExcelTextSettings
This class contains settings for text measurement.
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 selection properties for panes after a freeze or split.
ExcelWorksheetView.ExcelWorksheetViewPaneSettings
Defines general properties for the panes, if the worksheet is frozen or split.
ExcelWriteProtection
File sharing settings for the workbook.
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.
JsonExportSettings
Base class for settings used when exporting a range or a table as Json.
JsonRangeExportSettings
Settings used when exporting a range to Json
JsonTableExportSettings
Settings used when exporting a table to Json
LicenseException
An exception thrown when the license context of EPPlus hasn't been set.
OfficeProperties
Provides access to the properties bag of the package
ToCollectionOptions
Base class for settings to the ToCollection method. ToCollection<T>() ToCollection<T>()
ToCollectionRangeOptions
Settings for the ToCollection method. ToCollection<T>()
ToCollectionTableOptions
Settings for the ToCollection method. ToCollection<T>()
XmlHelper
Abstract helper class containing functionality to work with XML inside the package.
Enums
CompressionLevel
Maps to DotNetZips CompressionLevel enum
eCalculationMethod
Calculation Method for number fill operations
eCrossFilter
How the items that are used in slicer cross filtering are displayed
eDataTypeOn
How to set the data type when exporting json.
eDataTypes
Discribes a column when reading a text using the ExcelRangeBase.LoadFromText method
eDateTimeUnit
The date units for date fill operations
eErrorType
Represents the errortypes in excel
eFillDirection
If the fill is performed Down/Up (Column) or Left/Right (Row). Also see eFillStartPosition
eFillStartPosition
If the fill starts from the top-left cell or the bottom-right cell. Also see eFillDirection
eHtmlRangeTableInclude
How to handle a range when it is a table.
EncryptionAlgorithm
Encryption Algorithm
EncryptionVersion
The major version of the Encryption
eOrientation
Printer orientation
ePageOrder
Specifies printed page order
ePanePosition
The position of the pane.
ePaneState
The state of the pane.
ePaperSize
Papersize
eShiftTypeDelete
Tells how cells should be shifted in a delete operation
eShiftTypeInsert
Tells how cells should be shifted in a insert operation
eSlicerSourceType
The source of the slicer data
eSlicerStyle
Buildin slicer styles
eSortOrder
Sorting
eTableNamedStyleAppliesTo
Defines if a table style applies to a Table / PivotTable or Both
eVmlDashStyle
Dash style for a line used in VML drawings
eVmlLineStyle
The line style of a vml drawing
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