Classes
| Class | Description | |
|---|---|---|
 | AnyValueDataValidationRule | Represents a data validation rule which allows any value to be set on the target cells. This would be used to provide an input message to the user when the cell was selected. |
| ArrayFormula | Represents an array formula for a group of cells. |
| BIFF8Writer | BIFF8Writer provides static methods for exporting abstract workbook object to concrete Excel file. |
| CustomDataValidationRule | Represents a data validation rule which allows any formula to be used to validate the value applied to a cell. |
| CustomView | Represents a custom view in Microsoft Excel. |
| CustomViewCollection | A collection of CustomView instances in a workbook. |
| CustomViewDisplayOptions | Class which exposes the worksheet display options which can only be controlled through the custom view. |
| CustomViewWindowOptions | Represents the workbook window options which are saved with custom views. |
| DataValidationRule | Base class for all data validations rules which can be applied to a cell. |
| DataValidationRuleCollection | A collection of DataValidationRule instances in a worksheet. |
| DisplayOptions | Abstract base class which exposes the various display options available for a worksheet which can be saved with both a worksheet and a custom view. |
| DocumentProperties | Class which exposes the document level properties for a Microsoft Excel file. |
| ErrorValue | Represents an error value in Microsoft Excel. |
| ExcelResourceCustomizer | Class used to provide the ability to customize resource strings. |
| FormattedString | Represents a string with mixed formatting in a cell, cell comment, or shape. |
| FormattedStringFont | Controls the formatting of a range of characters in a FormattedString. |
| Formula | Represents a formula for a cell or group of cells. |
| FormulaParseException | The exception thrown when a formula parse error occurs. |
| FrozenPaneSettings | Class which controls the way frozen panes are arranged and used for a worksheet. |
| HiddenColumnCollection | A collection of hidden WorksheetColumn instances. |
| HiddenRowCollection | A collection of hidden WorksheetRow instances. |
| HorizontalPageBreak | Represents a horizontal page break in a Worksheet. |
| HorizontalPageBreakCollection | A collection of horizontal page breaks on a Worksheet. |
| LimitedValueDataValidationRule | Base class for all data validations rules which prevent certain values form being applied to a cell. |
| ListDataValidationRule | Represents a data validation rule which allows a value from a list of accepted values to be applied to a cell. |
| NamedReference | Represents a named reference defined in the workbook. |
| NamedReferenceBase | Abstract base class for a named reference defined in the workbook. |
| NamedReferenceCollection | A collection of NamedReference instances in a workbook. |
| OneConstraintDataValidationRule | Represents a data validation rule which can validate the cell value against a single constraint value or formula. |
| PageBreak | Base class for horizontal and vertical page breaks in a Worksheet. |
| PageBreakCollection<T> | Base class for the collections of horizontal and vertical page breaks on a Worksheet. |
| PaneSettingsBase | Abstract base class for classes which control pane settings. |
| PrintAreasCollection | Gets the collection of print areas in a Worksheet or a worksheet's print settings in a CustomView. |
| PrintOptions | Class which exposes the various print options available for a worksheet which can be saved with both a worksheet and a custom view. |
| RepeatTitleRange | Represents a range of contiguous rows or columns which should be repeated at the top or left or printed pages of the Worksheet. |
| Resources | Exposes a ExcelResourceCustomizer instance for this assembly. |
| RowColumnBase | Abstract base class for worksheet row and worksheet column. |
| RowColumnCollectionBase<T> | Base class for row collection and column collection. |
| ShapeFill | Abstract base class for the fill of a shape. |
| ShapeFillSolid | Represents a shape fill with a solid color. |
| ShapeOutline | Abstract base class for the outline of a shape. |
| ShapeOutlineSolid | Represents a shape outline with a solid color. |
| TwoConstraintDataValidationRule | Represents a data validation rule which can validate the cell value against two constraint values or formulas. |
| UnfrozenPaneSettings | Class which controls the way unfrozen panes are arranged and used for a worksheet. |
| UnknownShape | Represents an unsupported shape which has been loaded from a workbook file. |
| ValueConstraintDataValidationRule | Base class for all data validations rules which compare the cell value against one or more constraint when determining the validity of the cell value. |
| VerticalPageBreak | Represents a vertical page break in a Worksheet. |
| VerticalPageBreakCollection | A collection of horizontal page breaks on a Worksheet. |
| WindowOptions | Abstract base class which exposes the various workbook window options available which can be saved with both a workbook and a custom view. |
| Workbook | Represents a Microsoft Excel workbook. |
| WorkbookStyle | Represents a complex format which can be easily applied to a cell in Microsoft Excel. |
| WorkbookStyleCollection | A collection of workbook styles, or complex formats which can be easily applied to cells in Microsoft Excel. |
| WorkbookWindowOptions | Represents the window options which are saved with the workbook. |
| Worksheet | Represents one worksheet in a Microsoft Excel workbook. |
| WorksheetCell | Represents a cell in a Microsoft Excel worksheet. |
| WorksheetCellCollection | A collection of cells in a row. |
| WorksheetCellComment | Represents a comment for a cell. |
| WorksheetChart | Represents a chart shape. This class does not allow for the editing of chart data. It is used for round-tripping chart data between loading and saving a workbook. |
| WorksheetCollection | A collection of worksheets in a workbook. |
| WorksheetColumn | Represents a column in a Microsoft Excel worksheet. |
| WorksheetColumnCollection | A collection of columns in a worksheet. |
| WorksheetDataTable | Represents a data table for a range of cells. |
| WorksheetDataTableCollection | A collection of WorksheetDataTable instances on a worksheet. |
| WorksheetDisplayOptions | Class which exposes the display options which can only be controlled through the worksheet. |
| WorksheetImage | Represents any image on the worksheet except the background image. |
| WorksheetItemCollection<T> | Abstract base class for collections of the main worksheet elements (rows, columns, and cells). |
| WorksheetMergedCellsRegion | Represents a merged region of cells, or cells which share a value and format and appear as one cell when viewed in Microsoft Excel. |
| WorksheetMergedCellsRegionCollection | A collection of WorksheetMergedCellsRegion instances in a Worksheet. |
| WorksheetReferenceCollection | A collection of cells or regions which are all on the same Worksheet. |
| WorksheetRegion | Represents a rectangular region of cells on a worksheet. |
| WorksheetRow | Represents a row in a Microsoft Excel worksheet. |
| WorksheetRowCollection | A collection of rows in a worksheet. |
| WorksheetShape | Abstract base class for all shapes (atomic or compound) in a worksheet. |
| WorksheetShapeCollection | A collection of WorksheetShape instances in a Worksheet or WorksheetShapeGroup. |
| WorksheetShapeGroup | Represents a group of shapes in a worksheet. This group is also a shape which can be positioned and contained within another group or on a worksheet. |
| WorksheetShapeWithText | Abstract base class for all shapes that can display text. |
Interfaces
| Interface | Description | |
|---|---|---|
 | IPackage | Represents a container that can store multiple data objects. |
| IPackageFactory | Factory class used to create an IPackage given a stream and a FileMode |
| IPackagePart | Provides a base class for parts stored in a System.IO.Packaging.Package. This class is abstract. |
| IPackageRelationship | Represents an association between a source IPackage or IPackagePart, and a target object which can be a IPackagePart or external resource. |
| IWorkbookFont | Represents a font for the cell in the related context. |
| IWorksheetCellFormat | Represents the format for the cell in the related context. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | CalculationMode | Represents the the ways formulas are recalculated when their referenced values change. |
| CellBorderLineStyle | Represents the different cell border line styles. |
| CellReferenceMode | Represents the various ways cells can be referenced in a formula. |
| CommentDisplayStyle | Defines options for displaying comments in the user interface. |
| DataValidationCriteria | Determines what types of cell values are allowed and how the cell value is validated against the constraint(s). |
| DataValidationErrorStyle | Represents the various styles in which invalid values are handled by Microsoft Excel. When error messages are not shown for invalid values, the error style is ignored and all invalid values are allowed to be set on cells. |
| DateSystem | Represents the various ways a date can be stored internally. |
| ExcelDefaultableBoolean | Enumeration for a boolean type property that allows for a default setting. This is used in property override situations. |
| FillPatternStyle | Enumeration for fill pattern styles. Default value is used in property override situations. |
| FontSuperscriptSubscriptStyle | Enumeration for font superscript or subscript style. Default value is used in property override situations. |
| FontUnderlineStyle | Enumeration for font underline styles. Default value is used in property override situations. |
| HorizontalCellAlignment | Enumeration for horizontal alignment styles. Default value is used in property override situations. |
| ObjectDisplayStyle | Represents the various way objects and shapes are displayed in the workbook. |
| OneConstraintDataValidationOperator | Represents the various operators which can be used when validating the cell value against a constraint. |
| Orientation | Represents the page orientations available when a worksheet is printed. |
| PageNumbering | Represents the way pages are numbered when printed. |
| PageOrder | Represents the ways to order the pages of multiple page worksheets. |
| PaperSize | Represents the various paper sizes available for printing. |
| PositioningOptions | Represents the options available for getting or setting the bounds of a shape, cell, or region. |
| Precision | Represents the types of precision which can be used when obtaining the value of a cell. |
| PredefinedShapeType | Represents the shape types that are predefined in Microsoft Excel. |
| PrintErrors | Represents the various ways to print cell errors in a worksheet. |
| PrintNotes | Represents the various ways to print cell notes. |
| RelationshipTargetMode | Specifies whether the target of an IPackageRelationship is inside or outside the IPackage. |
| ScalingType | Represents the ways to scale a worksheet when it is printed. |
| ScrollBars | Represents the various scroll bar configurations available for the workbook. |
| ShapePositioningMode | Represents the ways shapes will be repositioned when rows and columns are resized. |
| TwoConstraintDataValidationOperator | Represents the various operators which can be used when validating the cell value against two constraints. |
| VerticalCellAlignment | Enumeration for vertical alignment styles. Default value is used in property override situations. |
| WorkbookFormat | Represents the various file formats in which a workbook can be saved. |
| WorkbookPaletteMode | Enum specifying what palette to use when exporting. |
| WorksheetView | Represents the various views for a worksheet. |
| WorksheetVisibility | Represents the various visibilities of a worksheet. |