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