Namespace OfficeOpenXml¶
Namespaces¶
OfficeOpenXml.ConditionalFormatting
OfficeOpenXml.DigitalSignatures
OfficeOpenXml.ExternalReferences
OfficeOpenXml.SensitivityLabels
OfficeOpenXml.ThreadedComments
Classes¶
Extentions methods for formula calculation.
Represents a class to set the license
License information about a commercial license.
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
ExcelOutputTextFormatFixedWidth
Describes how to output an fixed width text file.
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 spill errors
Represents an individual row in the spreadsheet.
A collection of rows in a worksheet.
Sheet protection ExcelEncryption ExcelProtection
Represents a #SPILL! error
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 text file. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormatBase, ExcelTextFormatFixedWidthBase ExcelTextFormatBase ExcelTextFormatFixedWidthBase
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
Describes how to split a fixed width text. Used by the ExcelRange.LoadFromText method
Describes how to import a fixed width text file.
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.
An exception thrown when the license key cannot be validated.
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
LicenseContextPropertyObsoleteException
An exception thrown when trying to set the obsolete property LicenseContext is set.
Please use the License instead.
To set the license, use SetCommercial(string), SetNonCommercialOrganization(string) or SetNonCommercialPersonal(string)
For more information see http://epplussoftware.com/developers/licensenotsetexception
An exception thrown when the license has expired for the version used.
An exception thrown when the License hasn't been set. To set the license, use SetCommercial(string), SetNonCommercialOrganization(string) or SetNonCommercialPersonal(string)
An exception thrown when the license has expired for the version used.
ExcelWorksheet.MergeCellsCollection
Collection containing merged cell addresses
Numberformat settings used in the NumberFormatToTextHandler
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
The type of commercial license
The source method how a license is set.
Status of a commercial license
The type of license used.
Encryption Algorithm
The major version of the Encryption
How the application should calculate formulas in the workbook
Flags to only copy certain parts of a range.
This provides the options of Excel's "Paste Special"
Simplified enum for oper Fill and Transpose from ExcelRangeCopyOptionFlags
Copy options enum. Specify the flags that you want to exclude from the copy or if you want to transpose the output.
How to handle missmatch with data and column format specifications.
Obsolete: Specified the license EPPlus is used in versions prior to EPPlus 8. License type must be specified in order to use the library LicenseContext
Padding types, can be left, right or auto.
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
Represents the visible state of the workbook window.