Version

Infragistics.Documents.Excel Namespace

Classes
 ClassDescription
ClassAnyValueDataValidationRule 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.
ClassArrayFormula Represents an array formula for a group of cells.
ClassCellFill Abstract base class for the fill of a cell.
ClassCellFillGradient Abstract base class for a gradient fill of a cell.
ClassCellFillGradientStop Immutable class which describes a color transition in a cell fill gradient.
ClassCellFillLinearGradient An immutable object which represents a linear gradient fill for a cell.
ClassCellFillPattern An immutable object which represents a solid or pattern fill for a cell.
ClassCellFillRectangularGradient An immutable object which represents a rectangular gradient fill for a cell.
ClassChartsheet A sheet in a Mirosoft Excel workbook that displays a single chart.
ClassComboChartGroup Exposes chart-level properties for Infragistics.Documents.Excel.Charts.Series which appear within a combo chart.
ClassComboChartGroupCollection A collection of ComboChartGroup objects for a WorksheetChart
ClassCustomDataValidationRule Represents a data validation rule which allows any formula to be used to validate the value applied to a cell.
ClassCustomTableStyleCollection A collection of custom WorksheetTableStyle instances which can be applied to a WorksheetTable in the Workbook.
ClassCustomView Represents a custom view in Microsoft Excel.
ClassCustomViewCollection A collection of CustomView instances in a workbook.
ClassCustomViewDisplayOptions Class which exposes the worksheet display options which can only be controlled through the custom view.
ClassCustomViewWindowOptions Represents the workbook window options which are saved with custom views.
ClassDataValidationRule Base class for all data validations rules which can be applied to a cell.
ClassDataValidationRuleCollection A collection of DataValidationRule instances in a worksheet.
ClassDisplayOptions 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.
ClassDisplayOptionsBase Abstract base class which exposes the various display options available for a sheet which can be saved with both a sheet and its custom view.
ClassDisplayValueCollection A collection of display text values.
ClassDocumentProperties Class which exposes the document level properties for a Microsoft Excel file.
ClassErrorValue Represents an error value in Microsoft Excel.
ClassExcelResourceCustomizer Class used to provide the ability to customize resource strings.
ClassFormattedFontBase Abstract base class which controls the formatting of a range of characters in a FormattedString or FormattedText.
ClassFormattedString Represents a string with mixed formatting in a cell or cell comment.
ClassFormattedStringFont Controls the formatting of a range of characters in a FormattedString.
ClassFormattedText Represents text with multiple paragraphs and mixed formatting in a shape.
ClassFormattedTextFont Controls the formatting of a range of characters in FormattedText.
ClassFormattedTextParagraph Represents a paragraph in FormattedText.
ClassFormattedTextParagraphCollection A collection of FormattedTextParagraph instances in FormattedText.
ClassFormula Represents a formula for a cell or group of cells.
ClassFormulaParseException The exception thrown when a formula parse error occurs.
ClassFrozenPaneSettings Class which controls the way frozen panes are arranged and used for a worksheet.
ClassHiddenColumnCollection A collection of hidden WorksheetColumn instances.
ClassHiddenRowCollection A collection of hidden WorksheetRow instances.
ClassHorizontalPageBreak Represents a horizontal page break in a Worksheet.
ClassHorizontalPageBreakCollection A collection of horizontal page breaks on a Worksheet.
ClassLimitedValueDataValidationRule Base class for all data validations rules which prevent certain values form being applied to a cell.
ClassListDataValidationRule Represents a data validation rule which allows a value from a list of accepted values to be applied to a cell.
ClassNamedReference Represents a named reference defined in the workbook.
ClassNamedReferenceBase Abstract base class for a named reference defined in the workbook.
ClassNamedReferenceCollection A collection of NamedReference instances in a workbook.
ClassOneConstraintDataValidationRule Represents a data validation rule which can validate the cell value against a single constraint value or formula.
ClassPageBreak Base class for horizontal and vertical page breaks in a Worksheet.
ClassPageBreakCollection<T> Base class for the collections of horizontal and vertical page breaks on a Worksheet.
ClassPaneSettingsBase Abstract base class for classes which control pane settings.
ClassPrintAreasCollection Gets the collection of print areas in a Worksheet or a worksheet's print settings in a CustomView.
ClassPrintOptions Class which exposes the various print options available for a worksheet which can be saved with both a worksheet and a custom view.
ClassPrintOptionsBase Base class which exposes the various print options available for a sheet which can be saved with both a sheet and its custom view.
ClassRelativeIndex Represents an index relative to a region
ClassRepeatTitleRange Represents a range of contiguous rows or columns which should be repeated at the top or left or printed pages of the Worksheet.
ClassResources Exposes a ExcelResourceCustomizer instance for this assembly.
ClassRowColumnBase Abstract base class for worksheet row and worksheet column.
ClassRowColumnCollectionBase<T> Base class for row collection and column collection.
ClassShapeFill Abstract base class for the fill of a shape.
ClassShapeFillSolid Represents a shape fill with a solid color.
ClassShapeOutline Abstract base class for the outline of a shape.
ClassShapeOutlineSolid Represents a shape outline with a solid color.
ClassSheet Base class for a sheet in a Microsoft Excel workbook.
ClassSheetCollection A collection of sheets in a workbook.
ClassSheetProtection Provides information about the types of changes that are disabled when the associated Sheet is protected.
ClassStandardTableStyleCollection A collection of standard WorksheetTableStyle instances which can be applied to a WorksheetTable in a Workbook.
ClassTwoConstraintDataValidationRule Represents a data validation rule which can validate the cell value against two constraint values or formulas.
ClassUnfrozenPaneSettings Class which controls the way unfrozen panes are arranged and used for a worksheet.
ClassUnknownShape Represents an unsupported shape which has been loaded from a workbook file.
ClassValueConstraintDataValidationRule 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.
ClassVerticalPageBreak Represents a vertical page break in a Worksheet.
ClassVerticalPageBreakCollection A collection of horizontal page breaks on a Worksheet.
ClassWindowOptions Abstract base class which exposes the various workbook window options available which can be saved with both a workbook and a custom view.
ClassWorkbook Represents a Microsoft Excel workbook.
ClassWorkbookColorInfo An immutable object which represents a color in a Microsoft Excel workbook.
ClassWorkbookColorPalette Represents the color palette used when the saved file is opened in Microsoft Excel 2003 and earlier versions.
ClassWorkbookColorTransform Defines color transforms for a WorkbookColorInfo instance.
ClassWorkbookLoadOptions Contains the options related to loading a workbook from a file or stream.
ClassWorkbookOptionsBase Abstract base class for WorkbookLoadOptions or WorkbookSaveOptions.
ClassWorkbookProtection Provides information about the types of changes that are disabled when the associated Workbook is protected.
ClassWorkbookSaveOptions Contains the options related to saving a workbook to a file or stream.
ClassWorkbookStyle Represents a complex format which can be applied to a cell's format.
ClassWorkbookStyleCollection A collection of workbook styles, or complex formats which can be easily applied to cells in Microsoft Excel.
ClassWorkbookWindowOptions Represents the window options which are saved with the workbook.
ClassWorksheet Represents one worksheet in a Microsoft Excel workbook.
ClassWorksheetCell Represents a cell in a Microsoft Excel worksheet.
ClassWorksheetCellCollection A collection of cells in a row.
ClassWorksheetCellComment Represents a comment for a cell.
ClassWorksheetChart Represents a chart.
ClassWorksheetCollection A collection of worksheets in a workbook.
ClassWorksheetColumn Represents a column in a Microsoft Excel worksheet.
ClassWorksheetColumnCollection A collection of columns in a worksheet.
ClassWorksheetDataTable Represents a data table for a range of cells.
ClassWorksheetDataTableCollection A collection of WorksheetDataTable instances on a worksheet.
ClassWorksheetDisplayOptions Class which exposes the display options which can only be controlled through the worksheet.
ClassWorksheetHyperlink Represents a hyperlink for a cell or region.
ClassWorksheetHyperlinkCollection A collection of WorksheetHyperlink instances in a Worksheet.
ClassWorksheetImage Represents any image on the worksheet except the background image.
ClassWorksheetItemCollection<T> Abstract base class for collections of the main worksheet elements (rows, columns, and cells).
ClassWorksheetMergedCellsRegion Represents a merged region of cells, or cells which share a value and format and appear as one cell when viewed in Microsoft Excel.
ClassWorksheetMergedCellsRegionCollection A collection of WorksheetMergedCellsRegion instances in a Worksheet.
ClassWorksheetProtectedRange Represents a range of cells in a worksheet that may be edited by the end user.
ClassWorksheetProtectedRangeCollection A collection of WorksheetProtectedRange instances in a Worksheet
ClassWorksheetProtection Provides information about the types of changes that are disabled when the associated Worksheet is protected.
ClassWorksheetReferenceCollection A collection of cells or regions which are all on the same Worksheet.
ClassWorksheetRegion Represents a rectangular region of cells on a worksheet.
ClassWorksheetRow Represents a row in a Microsoft Excel worksheet.
ClassWorksheetRowCollection A collection of rows in a worksheet.
ClassWorksheetShape Abstract base class for all shapes (atomic or compound) in a worksheet.
ClassWorksheetShapeCollection A collection of WorksheetShape instances in a Worksheet or WorksheetShapeGroup.
ClassWorksheetShapeGroup 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.
ClassWorksheetShapeGroupBase 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.
ClassWorksheetShapeWithText Abstract base class for all shapes that can display text.
ClassWorksheetTable Represents a region of cells formatted as a table.
ClassWorksheetTableAreaFormatsCollection<TArea> A collection of formats for areas of a WorksheetTable.
ClassWorksheetTableCollection The collection of WorksheetTable instances on a Worksheet.
ClassWorksheetTableColumn Represents a column in a WorksheetTable.
ClassWorksheetTableColumnCollection A read-only collection of all WorksheetTableColumn instances which exist in a WorksheetTable.
ClassWorksheetTableStyle Represents a style which can be applied to a WorksheetTable.
Interfaces
 InterfaceDescription
InterfaceIWorkbookFont Represents a font for the cell in the related context.
InterfaceIWorksheetCellFormat Represents the format for the cell.
Structures
 StructureDescription
StructureWorksheetProtectedRangeUserPermission Object used to define a permission to allow or deny editing for a WorksheetProtectedRange
Enumerations
 EnumerationDescription
EnumerationCalculationMode Represents the the ways formulas are recalculated when their referenced values change.
EnumerationCellBorderLineStyle Represents the different cell border line styles.
EnumerationCellReferenceMode Represents the various ways cells can be referenced in a formula.
EnumerationDataValidationCriteria Determines what types of cell values are allowed and how the cell value is validated against the constraint(s).
EnumerationDataValidationErrorStyle 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.
EnumerationDataValidationImeMode Represents the description of the Japanese input rules.
EnumerationDateSystem Represents the various ways a date can be stored internally.
EnumerationDiagonalBorders Represents the diagonal borders which can be displayed in cells.
EnumerationExcelDefaultableBoolean Enumeration for a boolean type property that allows for a default setting. This is used in property override situations.
EnumerationFillPatternStyle Enumeration for fill pattern styles. Default value is used in property override situations.
EnumerationFontSuperscriptSubscriptStyle Enumeration for font superscript or subscript style. Default value is used in property override situations.
EnumerationFontUnderlineStyle Enumeration for font underline styles. Default value is used in property override situations.
EnumerationFormatConditionIcon Identifies the set of icons used by a Infragistics.Documents.Excel.ConditionalFormatting.IconCriterion.
EnumerationFormatConditionIconSet Constants which identify a set of icons for an Infragistics.Documents.Excel.ConditionalFormatting.IconSetConditionalFormat.
EnumerationHorizontalCellAlignment Enumeration for horizontal alignment styles. Default value is used in property override situations.
EnumerationHorizontalTextAlignment Represents the various horizontal text alignment types.
EnumerationObjectDisplayStyle Represents the various way objects and shapes are displayed in the workbook.
EnumerationOneConstraintDataValidationOperator Represents the various operators which can be used when validating the cell value against a constraint.
EnumerationOrientation Represents the page orientations available when a worksheet is printed.
EnumerationPageNumbering Represents the way pages are numbered when printed.
EnumerationPageOrder Represents the ways to order the pages of multiple page worksheets.
EnumerationPaperSize Represents the various paper sizes available for printing.
EnumerationPositioningOptions Represents the options available for getting or setting the bounds of a shape, cell, or region.
EnumerationPrecision Represents the types of precision which can be used when obtaining the value of a cell.
EnumerationPredefinedShapeType Represents the shape types that are predefined in Microsoft Excel.
EnumerationPrintErrors Represents the various ways to print cell errors in a worksheet.
EnumerationPrintNotes Represents the various ways to print cell notes.
EnumerationScalingType Represents the ways to scale a worksheet when it is printed.
EnumerationScrollBars Represents the various scroll bar configurations available for the workbook.
EnumerationShapePositioningMode Represents the ways shapes will be repositioned when rows and columns are resized.
EnumerationSheetType Indicates the type of workbook Sheet
EnumerationSparklineAxisMinMax Determines how the min or max axis is calculated for a
EnumerationSparklineDisplayBlanksAs Determines how blanks are displayed in a sparkline
EnumerationSparklineType Determines the type if sparkline
EnumerationTextFormatMode Represents the various way to combine a cell's value and format string to get its text.
EnumerationTwoConstraintDataValidationOperator Represents the various operators which can be used when validating the cell value against two constraints.
EnumerationVerticalCellAlignment Enumeration for vertical alignment styles. Default value is used in property override situations.
EnumerationVerticalTextAlignment Represents the various vertical text alignment types.
EnumerationWorkbookEncryptionMode Represents the various encryption modes that can be used to encrypt documents saved in the 2007 file formats and later.
EnumerationWorkbookFormat Represents the various file formats in which a workbook can be saved.
EnumerationWorkbookThemeColorType Represents the various theme colors in a workbook.
EnumerationWorksheetCellFormatOptions Flagged enumeration which indicates which groups of formatting properties are used in a format.
EnumerationWorksheetColumnWidthUnit Represents the various units in which a column width can be represented.
EnumerationWorksheetProtectedSelectionMode Enumeration used to indicate which cells may be selected when the Worksheet is protected.
EnumerationWorksheetSortType Determines whether worksheet rows of columns are sorted within the region
EnumerationWorksheetTableArea Represents the various areas which can have a format applied at the table level.
EnumerationWorksheetTableColumnArea Represents the various areas which can have a format applied at the table column level.
EnumerationWorksheetTableStyleArea Represents the various areas which can have a format applied at the table style level.
EnumerationWorksheetView Represents the various views for a worksheet.
EnumerationWorksheetVisibility Represents the various visibilities of a worksheet.
See Also