Namespace OfficeOpenXml¶
Namespaces¶
OfficeOpenXml.ConditionalFormatting
OfficeOpenXml.ExternalReferences
OfficeOpenXml.ThreadedComments
Classes¶
Extentions methods for formula calculation.
Range address with the address property readonly
A range address
An image that fills the background of the worksheet.
A single cell address
Base class containing cell address manipulating methods.
Represents an Excel Chartsheet and provides access to its properties and methods
Represents one or more columns within the worksheet
A collection of columns in a worksheet
An Excel Cell Comment
Collection of Excel Comment objects
How and if the workbook is encrypted ExcelProtection ExcelSheetProtection
Represents an Excel error.
Range address used in the formula parser
Represents the Header and Footer on an Excel Worksheet
Print header and footer
HyperlinkClass
Error ignore options for a worksheet
A collection of ignored errors per range for a worksheet
This class contains settings for text measurement.
This class represents an error/Exception that has occured during initalization.
A named range.
Collection for named ranges
A collection of named styles in the workbooks styles.
Describes how to split a CSV text. Used by the ExcelRange.SaveFromText method
Represents an Excel XLSX file package.
This is the top-level object to access all parts of the document.
Package generic settings
Printer settings
A protected range in a worksheet ExcelProtection ExcelSheetProtection ExcelEncryption
A collection of protected ranges in the worksheet. ExcelProtection ExcelSheetProtection ExcelEncryption
Sets protection on the workbook level ExcelEncryption ExcelSheetProtection
A range of cells.
A range of cells
Represents a range of columns
Represents a range of rows
Represents Excel Errors
Represents an individual row in the spreadsheet.
A collection of rows in a worksheet.
Sheet protection ExcelEncryption ExcelProtection
Base collection class for styles.
Containts all shared cell styles for a workbook
Extended address information for a table address
Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method
Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormat and ExcelOutputTextFormat ExcelTextFormat ExcelOutputTextFormat
This class contains settings for text measurement.
Represents the Excel workbook and provides access to all the document properties and worksheets within the workbook.
Access to workbook view properties
Represents an Excel worksheet and provides access to its properties and methods
ExcelWorksheetView.ExcelWorksheetPanes
The selection properties for panes after a freeze or split.
Represents the different view states of the worksheet
ExcelWorksheetView.ExcelWorksheetViewPaneSettings
Defines general properties for the panes, if the worksheet is frozen or split.
The collection of worksheets for the workbook
File sharing settings for the workbook.
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.
Base class for settings used when exporting a range or a table as Json.
Settings used when exporting a range to Json
Settings used when exporting a table to Json
An exception thrown when the license context of EPPlus hasn't been set.
ExcelWorksheet.MergeCellsCollection
Collection containing merged cell addresses
Provides access to the properties bag of the package
Extension methods for ExcelRangeBase
Base class for settings to the ToCollection method. ToCollection ToCollection
Settings for the ToCollection method. ToCollection
Settings for the ToCollection method. ToCollection
Handles the convertion between eErrorType and the string values used by Excel.
Abstract helper class containing functionality to work with XML inside the package.
Enums¶
Maps to DotNetZips CompressionLevel enum
Encryption Algorithm
The major version of the Encryption
How the application should calculate formulas in the workbook
Flag enum, specify all flags that you want to exclude from the copy.
Specifies with license EPPlus is used under. Licensetype must be specified in order to use the library LicenseContext
How a picture will be aligned in the header/footer
Calculation Method for number fill operations
How the items that are used in slicer cross filtering are displayed
How to set the data type when exporting json.
Discribes a column when reading a text using the ExcelRangeBase.LoadFromText method
The date units for date fill operations
Represents the errortypes in excel
If the fill is performed Down/Up (Column) or Left/Right (Row). Also see eFillStartPosition
If the fill starts from the top-left cell or the bottom-right cell. Also see eFillDirection
How to handle a range when it is a table.
Printer orientation
Specifies printed page order
The position of the pane.
The state of the pane.
Papersize
Tells how cells should be shifted in a delete operation
Tells how cells should be shifted in a insert operation
The source of the slicer data
Buildin slicer styles
Sorting
Defines if a table style applies to a Table / PivotTable or Both
Dash style for a line used in VML drawings
The line style of a vml drawing
Worksheet hidden enumeration