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
- ExcelOutputTextFormatFixedWidth
Describes how to output an fixed width text file.
- 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
- ExcelRichDataErrorValue
Represents Excel Errors
- 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
- ExcelTextFileFormat
Describes how to split a text file. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormatBase, ExcelTextFormatFixedWidthBase ExcelTextFormatBase ExcelTextFormatFixedWidthBase
- 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
- ExcelTextFormatFixedWidth
Describes how to split a fixed width text. Used by the ExcelRange.LoadFromText method
- ExcelTextFormatFixedWidthBase
Describes how to import a fixed width text file.
- 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
- 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.
- ExcelWorksheets
The collection of worksheets for the workbook
- 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.
- NumberFormatToTextArgs
Numberformat settings used in the
- OfficeProperties
Provides access to the properties bag of the package
- RangeExtensions
Extension methods for ExcelRangeBase
- 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
- EncryptionAlgorithm
Encryption Algorithm
- EncryptionVersion
The major version of the Encryption
- ExcelCalcMode
How the application should calculate formulas in the workbook
- ExcelRangeCopyOptionFlags
Flag enum, specify all flags that you want to exclude from the copy.
- FixedWidthFormatErrorStrategy
How to handle missmatch with data and column format specifications.
- LicenseContext
Specifies with license EPPlus is used under. Licensetype must be specified in order to use the library LicenseContext
- PaddingAlignmentType
Padding types, can be left, right or auto.
- PictureAlignment
How a picture will be aligned in the header/footer
- 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.
- 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