Documents for Excel .NET Edition | GCDocuments
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 Gets or sets the cell padding.
    Class Represents a check box cell.
    Class Represents an editable CheckBoxList 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 Represents some settings when deserialize workbook or worksheet from json.
    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 Option class for saving html file.
    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 A static class used to set license
    Class Gets or sets the watermark margin in pixels relative to the cell.
    Class 
    Class Option class for opening
    Class Base option class for opening.
    Class Represent a page content info.
    Class Represent the page information.
    ClassProvides data for the PdfSaveOptions.PagePrinted event.
    ClassProvides data for the PdfSaveOptions.PagePrinting and PdfSaveOptions.PagePrinted events.
    ClassProvides data for the PdfSaveOptions.PagePrinting event.
    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.
    Class Represents an editable radio button list cell.
    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.
    Class Represents an checkBoxList/radioList item.
    Class Represents some settings when serialize workbook or worksheet to json.
    ClassRepresents System.EventArgs which contain a Worksheet object;
    Class Provides signature details for application developers to implement the "Sign" button on "Signature Details" dialog. Represents data of SignatureInfoV1, SignatureInfoV2 and XAdES part in the signature.
    Class Represents the sort base class.
    Class Describes font and layout options for drawing text.
    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 the workbook class. Represents a workbook.
    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 All types of barcode inherits this interface
    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 Gets or sets the cell padding.
    Interface Codabar is a barcode that uses alphanumeric characters including : A B C D + - : . / $ and all numbers.A screenshot depicting Codabar sparkline is shared below.
    Interface 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).
    Interface 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 ("%" , "*", "$", "/", "." , "-", "+").
    Interface 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.
    Interface Code93 barcode is a barcode that uses uppercase characters and numeric characters along with some special characters ("%" , "*", "$", "/", "." , "-", "+").
    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 DataMatrix barcode is a high density, two-dimensional barcode with square modules typically arranged in a square or a rectangular matrix pattern.
    Interface Represents the options related to data import and data analysis.
    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 EAN-13 barcode is a code that makes use of numeric characters (twelve numbers) and a check digit.
    Interface 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.
    Interface Options for working with Excel.
    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 Font option
    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 Represents the options related to formula caculation, performance, and error handing.
    Interface
    Interface Represents the picture field included in the specified header or footer.
    Interface Provides graphics information
    Interface 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.
    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.
    Interface Barcode lable option
    Interface Indicates the cell label options.
    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 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.
    Interface Represents the axis for a PivotTable report.
    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 cell in a PivotTable report.
    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 A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
    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 A PivotLine object is a line of rows or columns in an Excel PivotTable.
    Interface Collection of PivotCell objects for a specific PivotLine.
    Interface 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.
    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 Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.
    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 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.
    Interface Represents the IRange object.
    InterfaceProvides access to the IRange object of cells in the worksheet.
    Interface Represents read-only detail of the signature.
    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.
    Interface Corresponds to a digital signature that is attached to a document.
    Interface A collection of Signature objects that correspond to the digital signature attached to a document.
    Interface Represents the information used to set up a signature packet.
    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
    Enumeration Specifies the line style for the border.
    Enumeration Specifies the border to be retrieved.
    Enumeration Specifies the calculation error.
    Enumeration Specifies the checkbox or radio list's orders.
    Enumeration Specifies the text alignment for checkbox/radiolist cells.
    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
    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
    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 Defines possible values of GrapeCity.Documents.Pdf.Actions.ActionSubmitForm.SubmitFormat property.
    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 Specifies the cell label position.
    Enumeration Specifies the cell label visibility.
    Enumeration Specifies the way the specified PivotTable items appear—in table format or in outline format.
    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 PivotTable entity the cell corresponds to.
    Enumeration Specifies the subtotal function.
    Enumeration Specifies the location of the field in a PivotTable report.
    Enumeration Specifies whether to repeat all field item labels in a PivotTable report.
    Enumeration Specifies the type of the PivotLine.
    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 cells with a particular type of value to include in the result.
    Enumeration Specifies the type of cells.
    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