Documents for Excel, .NET Edition Documentation
Inheritance Hierarchy
In This Topic
    GrapeCity.Documents.Excel Namespace
    In This Topic
    Provides the interfaces, classes and enumerations to work with workbook and worksheets.
    Classes
     ClassDescription
    Class Represents the base class for the other cell type classes.
    Class Represents a button cell.
    Class Represents an area in a spreadsheet.
    Class Specifies the interior sort.
    Class Provide some helper functions.
    Class Represents a check box cell.
    Class Represents an comboBox item.
    Class Represents an editable combo box cell.
    Class Option class for opening csv file.
    Class Option class for saving csv file.
    Class Represents the base type for custom function.
    Class Represents the DataValidation error in the json.
    Class A DateTime helper class for .NetCore framework
    Class Represents the document properties of pdf.
    ClassWraps all optional parameters in IRange.Find .
    Class Represents the color sort.
    Class Represents the formula error in the json.
    Class Represents the hyperlink cell.
    Class Represents sorting by icon.
    Class Represents the image source.
    Class Specifies the invalid formula exception.
    Class The base class for all the json error classes.
    Class 
    Class A static class used to set license
    Class 
    Class Option class for opening
    Class Base option class for opening.
    Class Represent a page content info.
    Class Represent the page information.
    Class Represent the settings of the page.
    Class Represents the parameter of a function.
    Class Option class for saving pdf file.
    Class Represents the security settings of pdf.
    Class Represents a print settings class.
    ClassSpecifies System.EventArgs that contain a IRange object.
    Class Represents the repeat settings of a range.
    ClassWraps all optional parameters in IRange.Replace to be consistent with the Java edition.
    Class Option class for saving.
    Class Base option class for saving.
    ClassRepresents System.EventArgs which contain a Worksheet object;
    Class Represents the sort base class.
    Class 
    Class Represents the theme manager.
    Class Represents the sort by value field.
    Class Represents viewer preferences to be used when displaying the document.
    Class Represents a workbook. Represents the workbook class.
    Class Option class for opening xlsx file.
    Class Option class for saving xlsx file.
    Interfaces
     InterfaceDescription
    Interface 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.
    Interface Represents a collection of ranges, each of which represent a single contiguous range of one or more cells.
    Interface Represents autofiltering for the specified worksheet.
    Interface Represents the border of an object.
    InterfaceRepresents a collection of four IBorder objects that represent the four borders of an IRange or IStyle object.
    Interface Represents the context of the calclation.
    Interface Gets an individual cell by its reference string.
    Interface Represents the sort field by cell color.
    Interface Represents a color scale conditional formatting rule.
    Interface 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.
    Interface Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
    Interface Represents the color stop point for a gradient fill in a range or selection.
    InterfaceRepresents a collection of all the IColorStop objects for the specified series.
    Interface Represents a cell comment.
    InterfaceRepresents a collection of cell comments. Each comment is represented by an IComment object.
    Interface Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
    Interface 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.
    Interface Represents the border of the data bars specified by a conditional formatting rule.
    Interface 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.
    Interface 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.
    Interface Represents a collection of Filter objects that represents all the filters in an autofiltered range.
    Interface Contains the font attributes (font name, font size, color, and so on) for an object.
    Interface Represents the sort field by font color.
    Interface 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.
    Interface Represents a conditional format.
    Interface Represents the conditional formats associated with a range.
    Interface
    Interface Represents the picture field included in the specified header or footer.
    Interface Represents a picture or text how to be aligned in the page header and footer.
    Interface Represents the collection of vertical page breaks within the print area.
    Interface Represents the collection of horizontal page breaks within the print area.
    Interface Represents a hyperlink.
    InterfaceRepresents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by the IHyperlink object.
    Interface Represents a single icon in an icon set used in a conditional formatting rule.
    Interface Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
    Interface 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.
    Interface Represents a single set of icons that are used in an icon set conditional formatting rule.
    Interface Represents an icon set conditional formatting rule.
    Interface Represents a collection of icon sets used in an icon set conditional formatting rule.
    Interface Represents the sort field by icon.
    Interface Represents the interior of an object.
    Interface Represents a serializer/deserializer for custom type in from/to json.
    InterfaceRepresents the ILinearGradient object that transitions through a series of colors in a linear manner along a specific angle.
    Interface Represents a defined name for a range of cells.
    InterfaceRepresents 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.
    Interface Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
    Interface Represents an outline on a worksheet.
    Interface Represents the outline column for the worksheet.
    Interface Represents the alignment of text on the page of a workbook or section.
    Interface Represents the page setup description.
    Interface Worksheet pane.
    Interface Worksheet panes.
    Interface Represents the memory cache for a PivotTable report.
    Interface Represents the collection of memory caches from the PivotTable reports in a workbook.
    Interface 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.
    InterfaceRepresents a collection of all the IPivotField objects in a PivotTable report.
    Interface 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.
    Interface Represents a collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
    Interface 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.
    Interface Represents a collection of all the PivotTable objects on the specified worksheet.
    Interface Represents the various types of protection options available for a worksheet. The setting action will take effect only if the worksheet is under protection.
    Interface Represents the IRange object.
    InterfaceProvides access to the IRange object of cells in the worksheet.
    InterfaceThe IRectangularGradient object transitions through a series of colors in a linear manner along a specific angle
    Interface Represents the rich text class for a cell.
    Interface Represents the shrink to fit settings of this workbook.
    InterfaceRepresents a slicer in a IWorkbook.
    InterfaceRepresents the current filter state for a slicer and information about which IPivotCache.
    Interface Represents the collection of slicer caches associated with the specified workbook.
    Interface Represents an item in a slicer.
    InterfaceRepresents the collection of ISlicerItem objects contained in a ISlicerCache object.
    InterfaceRepresents information about the collection of IPivotTables associated with the specified ISlicerCache object.
    InterfaceA collection of ISlicer objects.
    Interface Represents the sort interface.
    Interface Represents the sort field.
    Interface Represents the sort condition list.
    Interface Represents the settings for the horizontal and vertical axes of a group of sparklines.
    Interface Represents the color of the markers for points in a sparkline.
    Interface Represents the settings for the horizontal axes of a group of sparklines.
    Interface Represents a single sparkline.
    Interface Represents a group of sparklines.
    Interface Represents a collection of sparkline groups.
    Interface Represents the settings of the markers for points of data on a sparkline.
    Interface Represents the settings for the vertical axes of a group of sparklines.
    Interface Represents a style description for a range.
    InterfaceRepresents a collection of all the IStyle objects in the specified or active workbook.
    Interface Represents a table object on a worksheet.
    InterfaceRepresents 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).
    InterfaceRepresents a collection of all the ITableColumn objects in the specified ITable object. Each ITableColumn object represents a column in the table.
    InterfaceRepresents 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.
    InterfaceRepresents a collection of all the ITableRow objects in the specified ITable object. Each ITableRow object represents a row in the table.
    InterfaceRepresents a collection of all the ITable objects on a worksheet. Each ITable object represents a list in the worksheet.
    Interface Represents a single style that can be applied to a table.
    Interface Represents a collection of table styles contained in the workbook.
    Interface Represents a single table style element.
    Interface Represents table style elements.
    InterfaceRepresents a range of characters in a IRichText object.
    Interface Contains the theme information.
    Interface Represents the theme color information.
    Interface Represents the theme color.
    Interface Represents the theme font.
    Interface Contains the theme fonts in different language.
    Interface Specifies the font theme to use.
    Interface 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.
    Interface 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.
    Interface Represents data validation for a worksheet range.
    Interface Represents the sort field by cell value (ascending or descending or custom value list).
    Interface Represents a vertical page break.
    Interface Represents the collection of vertical page breaks within the print area.
    Interface Represents an IWorkbook object.
    Interface Represents the view settings of this workbook.
    Interface Represents a worksheet.
    Interface Represents a collection of all the sheets in the workbook.
    Interface Represents worksheet view options.
    Structures
     StructureDescription
    Structure A struct that contains info of fonts that are used by workbook.
    Enumerations
     EnumerationDescription
    Enumeration Specifies if the values are above or below average.
    Enumeration Specifies the operator to use to associate two criteria applied by a filter.
    Enumeration Specifies the line style for the border.
    Enumeration Specifies the border to be retrieved.
    Enumeration Specifies the calculation error.
    Enumeration Specifies the text alignment for check box cells.
    Enumeration Specifies the color of a selected feature such as border, font, or fill.
    Enumeration Specifies the type of color scale rule.
    Enumeration Specifies the types of condition values that can be used.
    Enumeration Specifies the subtotal function.
    Enumeration Specifies the operator used in a function.
    Enumeration Specifies the axis position for a range of cells with conditional formatting as data bars.
    Enumeration Specifies the border of a data bar.
    Enumeration Specifies the direction of a data bar.
    Enumeration Specifies how a data bar is filled with color.
    Enumeration Specifies whether to use the same border and fill color as postive data bars.
    Enumeration Specifies how to shift cells to replace deleted cells.
    Enumeration Specifies the direction in which to move.
    Enumeration Specifies how blank cells are plotted on a chart.
    Enumeration Specifies whether duplicate or unique values should be displayed.
    Enumeration Specifies the filter type.
    Enumeration Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values.
    Enumeration Specifies the type of data to search.
    Enumeration Specifies the font language type.
    Enumeration Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.
    Enumeration Specifies whether the conditional format is based on a cell value or an expression.
    Enumeration Specifies the value type of parameter or result.
    Enumeration Specifies the type of gradient fill being used, either linear or path.
    Enumeration Represents type of color transformation applied to the specified picture or OLE object.
    Enumeration Specifies the horizontal alignment of a cell or object.
    Enumeration Specifies the hyperlink's target type.
    Enumeration Specifies the type of icon set.
    Enumeration Specifies the icon for a criterion in an icon set conditional formatting rule.
    Enumeration Specifies the description of the Japanese input rules.
    Enumeration Options for reading data
    Enumeration Specifies the direction in which to shift cells during an insertion.
    Enumeration 
    Enumeration Specifies the type of layout row.
    Enumeration Specifies whether a match is made against the whole of the search text or any part of the search text.
    Enumeration Represents the format in which the workbook is opened.
    Enumeration Represents the order that GcExcel uses to number pages when printing a large worksheet.
    Enumeration Specifies whether a page break is full screen or applies only within the print area.
    Enumeration Represents the portrait or landscape printing mode.
    Enumeration Represents the type of the page.
    Enumeration Represents orientation of pagination.
    Enumeration Represents the size of the paper.
    Enumeration Specifies the type of paste.
    Enumeration Specifies the interior pattern of a chart or interior object.
    Enumeration Specifies the location of the field in a PivotTable report.
    Enumeration Represents an PrintErrors contstant specifying the type of print error displayed.
    Enumeration Represents the way comments are printed with the sheet.
    Enumeration Represents print quality of this page. Default is 600 dpi.
    Enumeration Specified the text reading order.
    Enumeration Specifies whether to use A1 style or R1C1 style for cell references.
    Enumeration Represents the format in which the workbook is saved.
    Enumeration Specifies the search direction when searching a range.
    Enumeration Specifies the order in which to search the range.
    Enumeration Represents the sheet type.
    Enumeration Specifies the slicer sort order.
    Enumeration Specifies how to sort text.
    Enumeration Specifies the parameter on which the data should be sorted.
    Enumeration Specifies the sort order.
    Enumeration Specifies the sort orientation.
    Enumeration Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
    Enumeration Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
    Enumeration Specifies the type of sparkline.
    Enumeration Specifies where the subtotal will be displayed on the worksheet.
    Enumeration Specifies the type of subtotal for the specified pivot field.
    Enumeration Specifies the location of the summary columns in the outline.
    Enumeration Specifies the location of the summary rows in the outline.
    Enumeration Specifies the table style element used.
    Enumeration Specifies the theme color. This is the displayed order.
    Enumeration Specifies the theme font to use.
    Enumeration Specifies the time period.
    Enumeration Specifies the top 10 values from the top or bottom of a series of values.
    Enumeration Specifies the type of calculation in the totals row of a table column.
    Enumeration Specifies the underline style of text.
    Enumeration Specifies the type of all supported features.
    Enumeration Specifies the icon used in message boxes displayed during validation.
    Enumeration Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.
    Enumeration Specifies the type of validation test to be performed in conjunction with values.
    Enumeration Gets or sets how to quote values in the exported text file.
    Enumeration Specifies the vertical alignment of text.
    Enumeration Specifies whether the object is visible.
    See Also