| | Interface | Description |
|---|
 | IAboveAverage |
Represents an above average visual of a conditional formatting rule. Applies a color or fill to a range or selection to help you see the value of a cell
relative to other cells.
|
| IAreas |
Represents a collection of ranges, each of which represent a single contiguous range of one or more cells.
|
| IAuthor |
Represents a author of threaded comment.
|
| IAutoFilter |
Represents autofiltering for the specified worksheet.
|
| IBarcode |
All types of barcode inherits this interface
|
| IBorder |
Represents the border of an object.
|
| IBorders | Represents a collection of four IBorder objects that represent the four borders of an IRange or IStyle object. |
| IBuiltInDocumentPropertyCollection |
A collection of built-in document properties.
|
| ICalcContext |
Represents the context of the calclation.
|
| ICalculatedFields | A collection of IPivotField objects that represents all the calculated fields in the specified PivotTable report. |
| ICalculatedItems |
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
|
| ICascadeSparkLine |
Represents a cascade sparkLine.
|
| ICellCollection |
Gets an individual cell by its reference string.
|
| ICellColorSortField |
Represents the sort field by cell color.
|
| ICellPadding |
Gets or sets the cell padding.
|
| ICodabar |
Codabar is a barcode that uses alphanumeric characters including : A B C D + - : . / $
and all numbers.A screenshot depicting Codabar sparkline is shared below.
|
| ICode128 |
The Code 128 barcode is a linear barcode that represents high-density linear symbology to
encode text, numbers, various functions and the entire 128 ASCII character set (from ASCII 0 to ASCII 128).
|
| ICode39 |
Code 39 is a linear barcode that uses a total of nine bars to represent each symbol
which includes numeric characters, upper case characters and some special characters ("%" , "*", "$", "/", "." , "-", "+").
|
| ICode49 |
Code 49 is a two dimensional, high-density stacked barcode with two to eight rows (having eight characters each).
Each row has a start code and a stop code. This barcode is especially used to encodes the complete ASCII character set.
|
| ICode93 |
Code93 barcode is a barcode that uses uppercase characters and numeric characters along with
some special characters ("%" , "*", "$", "/", "." , "-", "+").
|
| IColorScale |
Represents a color scale conditional formatting rule.
|
| IColorScaleCriteria |
Represents a collection of ColorScaleCriterion objects that represent all of the criteria for a color scale conditional format.
Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.
|
| IColorScaleCriterion |
Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
|
| IColorStop |
Represents the color stop point for a gradient fill in a range or selection.
|
| IColorStops | Represents a collection of all the IColorStop objects for the specified series. |
| IComment |
Represents a cell comment.
|
| IComments | Represents a collection of cell comments. Each comment is represented by an IComment object. |
| ICommentsThreaded | A collection of top-level threaded comment objects in a Worksheet, or a collection of replies in a single threaded comment. Each comment is represented by an ICommentThreaded object. |
| ICommentThreaded |
Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.
|
| IConditionValue |
Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
|
| ICsvParser |
Represents the customized parser.
|
| ICustomDocumentPropertyCollection |
A collection of custom document properties.
|
| ICustomView |
Represents a custom workbook view.
|
| ICustomViews |
A collection of custom workbook views.
|
| IDataBar |
Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.
|
| IDataBarBorder |
Represents the border of the data bars specified by a conditional formatting rule.
|
| IDataMatrix |
DataMatrix barcode is a high density, two-dimensional barcode with
square modules typically arranged in a square or a rectangular matrix pattern.
|
| IDataOptions |
Represents the options related to data import and data analysis.
|
| IDisplayFormat |
Represents the display settings for an associated Range object.
Remark:
Actions such as changing the conditional formatting or table style of a range can cause what is displayed in
the current user interface to be inconsistent with the values in the corresponding properties of the Range object.
Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.
|
| IDocumentProperty |
Represents a custom or built-in document property.
|
| IDocumentPropertyCollection |
A collection of document properties.
|
| IEAN13 |
EAN-13 barcode is a code that makes use of numeric characters (twelve numbers) and a check digit.
|
| IEAN8 |
EAN-8 barcode is a barcode that uses only numeric characters and a check digit. This barcode accepts only seven
numbers as a string to calculate a check digit (CheckSum) and add it to the eighth position.
|
| IExcelOptions |
Options for working with Excel.
|
| IFilter |
Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection
contains all the filters in an autofiltered range.
|
| IFilters |
Represents a collection of Filter objects that represents all the filters in an autofiltered range.
|
| IFont |
Contains the font attributes (font name, font size, color, and so on) for an object.
|
| IFontColorSortField |
Represents the sort field by font color.
|
| IFontOption |
Font option
|
| IFormatColor |
Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.
|
| IFormatCondition |
Represents a conditional format.
|
| IFormatConditions |
Represents the conditional formats associated with a range.
|
| IFormulaOptions |
Represents the options related to formula caculation, performance, and error handing.
|
| IFormulaResolver |
|
| IGraphic |
Represents the picture field included in the specified header or footer.
|
| IGraphicsInfo |
Provides graphics information
|
| IGroupInfo |
Represents the information of a group
|
| IGS1128 |
GS1-128 is a barcode that uses a series of application Identifiers in order to encode data. This barcode
makes use of the complete ASCII character set while also using FNC1 character as the first character position.
|
| IHeaderFooter |
Represents a picture or text how to be aligned in the page header and footer.
|
| IHPageBreak |
Represents the collection of vertical page breaks within the print area.
|
| IHPageBreaks |
Represents the collection of horizontal page breaks within the print area.
|
| IHyperlink |
Represents a hyperlink.
|
| IHyperlinks | Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by the IHyperlink object. |
| IIcon |
Represents a single icon in an icon set used in a conditional formatting rule.
|
| IIconCriteria |
Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for
each icon in an icon set conditional formatting rule.
|
| IIconCriterion |
Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the
icon in an icon set conditional formatting rule.
|
| IIconSet |
Represents a single set of icons that are used in an icon set conditional formatting rule.
|
| IIconSetCondition |
Represents an icon set conditional formatting rule.
|
| IIconSets |
Represents a collection of icon sets used in an icon set conditional formatting rule.
|
| IIconSortField |
Represents the sort field by icon.
|
| IInterior |
Represents the interior of an object.
|
| IJsonSerializer |
Represents a serializer/deserializer for custom type in from/to json.
|
| ILabelOption |
Barcode lable option
|
| ILabelOptions |
Indicates the cell label options.
|
| ILinearGradient | Represents the ILinearGradient object that transitions through a series of colors in a linear manner along a specific angle. |
| IName |
Represents a defined name for a range of cells.
|
| INames | Represents a collection of all the IName objects in the workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names. |
| INegativeBarFormat |
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
|
| IOutline |
Represents an outline on a worksheet.
|
| IOutlineColumn |
Represents the outline column for the worksheet.
|
| IPage |
Represents the alignment of text on the page of a workbook or section.
|
| IPageSetup |
Represents the page setup description.
|
| IPane |
Worksheet pane.
|
| IPanes |
Worksheet panes.
|
| IPDF417 |
PDF417 barcode is a popular high-density, two-dimensional barcode with symbology that possesses
the capability to encode up to 1108 bytes of information. This barcode comprises a stacked set of
small barcodes and can encode up to 35 alphanumeric characters and 2,710 numeric characters.
|
| IPivotAxis |
Represents the axis for a PivotTable report.
|
| IPivotCache |
Represents the memory cache for a PivotTable report.
|
| IPivotCaches |
Represents the collection of memory caches from the PivotTable reports in a workbook.
|
| IPivotCell |
Represents a cell in a PivotTable report.
|
| IPivotField |
Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields
collection contains all the fields in a PivotTable report, including hidden fields.
|
| IPivotFields | Represents a collection of all the IPivotField objects in a PivotTable report. |
| IPivotFormula |
An object representing the order in which custom formulas are calculated in a PivotTable
|
| IPivotFormulas | Represents the collection of IPivotFormula |
| IPivotItem |
Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems
collection. The PivotItems collection contains all the items in a PivotField.
|
| IPivotItemList |
A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
|
| IPivotItems |
Represents a collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
|
| IPivotLine |
A PivotLine object is a line of rows or columns in an Excel PivotTable.
|
| IPivotLineCells |
Collection of PivotCell objects for a specific PivotLine.
|
| IPivotLines |
The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows
or columns of the pivot. Each line is a set of PivotCells.
|
| IPivotTable |
Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection.
The PivotTables collection contains all the PivotTable objects on a single worksheet.
|
| IPivotTables |
Represents a collection of all the PivotTable objects on the specified worksheet.
|
| IPivotValueCell |
Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.
|
| IProtectionSettings |
Represents the various types of protection options available for a worksheet.
The setting action will take effect only if the worksheet is under protection.
|
| IQRCode |
QRCode is a two dimensional barcode representing symbology that enables effective handling of numeric,
alphanumeric and byte data. This barcode can encode up to 7,366 characters.
|
| IRange |
Represents the IRange object.
|
| IRangeProvider | Provides access to the IRange object of cells in the worksheet. |
| IReadOnlySignatureDetails |
Represents read-only detail of the signature.
|
| IRectangularGradient | The IRectangularGradient object transitions through a series of colors in a linear manner along a specific angle |
| IRichText |
Represents the rich text class for a cell.
|
| IShrinkToFitSettings |
Represents the shrink to fit settings of this workbook.
|
| ISignature |
Corresponds to a digital signature that is attached to a document.
|
| ISignatureSet |
A collection of Signature objects that correspond to
the digital signature attached to a document.
|
| ISignatureSetup |
Represents the information used to set up a signature packet.
|
| ISlicer | Represents a slicer in a IWorkbook. |
| ISlicerCache | Represents the current filter state for a slicer and information about which IPivotCache. |
| ISlicerCaches |
Represents the collection of slicer caches associated with the specified workbook.
|
| ISlicerItem |
Represents an item in a slicer.
|
| ISlicerItems | Represents the collection of ISlicerItem objects contained in a ISlicerCache object. |
| ISlicerPivotTables | Represents information about the collection of IPivotTables associated with the specified ISlicerCache object. |
| ISlicers | A collection of ISlicer objects. |
| ISort |
Represents the sort interface.
|
| ISortField |
Represents the sort field.
|
| ISortFields |
Represents the sort condition list.
|
| ISparkAxes |
Represents the settings for the horizontal and vertical axes of a group of sparklines.
|
| ISparkColor |
Represents the color of the markers for points in a sparkline.
|
| ISparkHorizontalAxis |
Represents the settings for the horizontal axes of a group of sparklines.
|
| ISparkline |
Represents a single sparkline.
|
| ISparklineGroup |
Represents a group of sparklines.
|
| ISparklineGroups |
Represents a collection of sparkline groups.
|
| ISparkPoints |
Represents the settings of the markers for points of data on a sparkline.
|
| ISparkVerticalAxis |
Represents the settings for the vertical axes of a group of sparklines.
|
| IStyle |
Represents a style description for a range.
|
| IStyleCollection | Represents a collection of all the IStyle objects in the specified or active workbook. |
| ITable |
Represents a table object on a worksheet.
|
| ITableColumn | Represents a column in a table. The ITableColumn object is a member of the ITableColumns collection. The ITableColumns collection contains all the columns in a table (ITable object). |
| ITableColumns | Represents a collection of all the ITableColumn objects in the specified ITable object. Each ITableColumn object represents a column in the table. |
| ITableRow | Represents a row in the ITable object. The ITableRow object is a member of the ITableRows collection. The ITableRows collection contains all the rows in a list object. |
| ITableRows | Represents a collection of all the ITableRow objects in the specified ITable object. Each ITableRow object represents a row in the table. |
| ITables | Represents a collection of all the ITable objects on a worksheet. Each ITable object represents a list in the worksheet. |
| ITableStyle |
Represents a single style that can be applied to a table.
|
| ITableStyleCollection |
Represents a collection of table styles contained in the workbook.
|
| ITableStyleElement |
Represents a single table style element.
|
| ITableStyleElements |
Represents table style elements.
|
| ITextRun | Represents a range of characters in a IRichText object. |
| ITheme |
Contains the theme information.
|
| IThemeColor |
Represents the theme color information.
|
| IThemeColorScheme |
Represents the theme color.
|
| IThemeFont |
Represents the theme font.
|
| IThemeFonts |
Contains the theme fonts in different language.
|
| IThemeFontScheme |
Specifies the font theme to use.
|
| ITop10 |
Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
|
| IUniqueValues |
The UniqueValues object uses the UniqueValues.DupeUnique property to return or set an enumeration that determines whether the rule should
look for duplicate or unique values in the range.
|
| IValidation |
Represents data validation for a worksheet range.
|
| IValueSortField |
Represents the sort field by cell value (ascending or descending or custom value list).
|
| IVPageBreak |
Represents a vertical page break.
|
| IVPageBreaks |
Represents the collection of vertical page breaks within the print area.
|
| IWorkbook |
Represents an IWorkbook object.
|
| IWorkbookView |
Represents the view settings of this workbook.
|
| IWorksheet |
Represents a worksheet.
|
| IWorksheets |
Represents a collection of all the sheets in the workbook.
|
| IWorksheetView |
Represents worksheet view options.
|
