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