All Classes and Interfaces
类
说明
Specifies if the values are above or below average.
Represents an array literal in the syntax tree.
Specifies the length of the arrowhead at the end of a line.
Specifies the style of the arrowhead at the end of a line.
Specifies the width of the arrowhead at the end of a line.
Specifies the operator to use to associate two criteria applied by a filter.
Specifies the shape type for an AutoShape object.
Specifies the point on the specified axis where the other axis crosses.
Specifies the type of axis group.
Specifies the axis type.
Specifies the shape used with the 3-D bar or column chart.
Represents the base class for the other cell type classes.
Specifies how the horizontal axis of the histogram chart is formatted.
Specifies the line style for the border.
Specifies the border to be retrieved.
Represents a button cell.
Specifies the calculation error.
Represents an area in a spreadsheet.
Specifies the type of the category axis.
Specifies the interior sort.
Provide some helper functions.
Gets or sets the cell padding.
Specifies the checkbox or radio list's orders.
Specifies the text alignment for checkbox/radiolist cells.
Specifies the values displayed in the second chart in a pie chart or a bar of the pie chart.
Specifies the chart type.
Specifies the text alignment for check box cells.
Represents a check box cell.
Creates the color structure.
Specifies the color of a selected feature such as border, font, or fill.
Specifies the type of color scale rule.
Represents an comboBox item.
Represents an editable combo box cell.
Specifies the types of condition values that can be used.
Specifies a type of connector.
Specifies the subtotal function.
Represents a constant node in the syntax tree.
Specifies the operator used in a function.
Option class for opening csv file.
Represents the CSV parse context of the current cell.
Represents the parsed result(value and number format).
Option class for saving csv file.
Represents the base type for custom 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 where the data label is positioned.
Represents the DataValidation error in the json.
Specifies how to shift cells to replace deleted cells.
Represents some settings when deserialize workbook or worksheet from JSON.
Specifies the direction in which to move.
Specifies how blank cells are plotted on a chart.
Specifies the display unit label for an axis.
Represents the document properties of pdf.
Specifies how pictures are displayed on a column, bar picture chart, or legend key.
Represents an item of
IDropDown.Specifies whether duplicate or unique values should be displayed.
Specifies the filter type.
A value that represents which ecc mode.
Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values.
Represents an empty node.
Specifies the end style for error bars.
Specifies the error bar direction.
Specifies which error-bar parts to include.
Specifies the range marked by error bars.
Represents an error literal node in the syntax tree.
Specifies a shape's fill type.
Specifies the type of data to search.
Wraps all optional parameters of the IRange.Find function.
Represents the color sort.
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.
Defines the different orientations that a control or layout can have.
Represents the type of form controls.
Defines possible values of GrapeCity.Documents.Pdf.Actions.ActionSubmitForm.SubmitFormat property.
Represents the formula error in the json.
Represents a formula.
Represents a function invocation expression in the syntax tree.
Specifies the value type of parameter or result.
Specifies the type of gradient fill being used, either linear or path.
Specifies the style for a gradient fill.
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.
Option class for saving html file.
Represents the hyperlink cell.
Specifies the hyperlink's target type.
Represents an above average visual of a conditional formatting rule.
Represents a collection of adjustment values for the specified AutoShape or connector.
Represents a collection of ranges, each of which represent a single contiguous range of one or more cells.
Represents an author of threaded comment.
Contains AutoCorrect attributes.
Represents autofiltering for the specified worksheet.
Represents a collection of all the
IAxis objects in the specifiedchart.Represents a single axis in a chart.
Represents a chart axis title.
Represents an picture object which will be used as the background picture.
A collection of all the
IBackgroundPicture objects on the specified sheet.All types of barcode inherits this interface
Represents the border of an object.
A collection of built-in document properties.
The button control.
Represents the context of the calclation.
A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
Represents a cascade sparkLine.
Gets an individual cell by its reference string.
Represents the sort field by cell color.
Common members of controls that have CellLink property
Common members of controls that have CellLink property
Gets or sets the cell padding.
Represents a chart object in a worksheet.
Represents the chart area of a chart.
Represents the up bars in a chart group.
Provides access to the Office Art formatting for chart elements.
Represents one or more series plotted in a chart with the same format.
Represents a collection of all the
IChartGroup objects in thespecified chart.Represents series lines in a chart group.
Represents the chart title.
The check box control.
Codabar is a barcode that uses alphanumeric characters including : A B C D + - : . / $ and all numbers.A screenshot depicting Codabar sparkline is shared below.
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).
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 ("%" , "*", "$", "/", "." , "-", "+").
Code 49 is a two dimensional, high-density stacked barcode with two to eight rows (having eight characters each).
Code93 barcode is a barcode that uses uppercase characters and numeric characters along with some special characters ("%" , "*", "$", "/", "." , "-", "+").
Represents the color of a one-color object, the color of an object with a gradient or patterned fill, or the pointer 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.
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 thespecified series.Represents a cell comment.
Represents a collection of cell comments.
Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
Represents properties and methods that apply to connectors.
Specifies the type of icon set.
Represents sorting by icon.
Represents a floating container in a sheet.
Common members of controls that have text content to display.
The base of form controls.
Common members of form control collections
Generic type members of form controls
Specifies the icon for a criterion in an icon set conditional formatting rule.
Represents an object used to remove a portion of an image.
Represents the customized parser.
A collection of custom document properties.
Represents a custom workbook view.
A collection of custom workbook views.
Represents a data bar conditional formating rule.
Represents the border of the data bars specified by a conditional formatting rule.
Represents the data label on a chart point or trendline.
Represents a collection of all the
IDataLabel objects for thespecified series.DataMatrix barcode is a high density, two-dimensional barcode with square modules typically arranged in a square or a rectangular matrix pattern.
Represents the options related to data import and data analysis.
Represents the display settings for an associated Range object.
Represents a unit label on an axis in the specified chart.
Represents a custom or built-in document property.
Represents a collection of document properties.
The drop down control.
Prevents generic type parameter erasure for
IItemList< DropDownItem> .EAN-13 barcode is a code that makes use of numeric characters (twelve numbers) and a check digit.
EAN-8 barcode is a barcode that uses only numeric characters and a check digit.
Represents the error bars in a chart series.
Represents the option for working with Excel.
Represents fill formatting for a shape.
Represents a filter for a single column.
Represents a collection of Filter objects that represents all the filters in an autofiltered range.
Represents the floor of a 3-D chart.
Contains the font attributes (font name, font size, color, and so on) for an object.
Represents the sort field by font color.
Represents font attributes (for example, font name, font size, and color) for an object.
Font option
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 options related to formula calculation, performance, and error handing.
Represents one gradient stop.
Represents a collection of
IGradientStop objects.Represents the picture field included in the specified header or footer.
Provides graphics information
Represents major or minor gridlines on a chart axis.
The group box control.
Represents the information of a group
Represents the individual shapes within a grouped shape.
GS1-128 is a barcode that uses a series of application Identifiers in order to encode data.
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.
Represents a single icon in an icon set used in a conditional formatting rule.
Represents the collection of IconCriterion objects.
Represents the criterion for an individual icon in an icon set.
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.
Holds the collection of items that constitute the content of an
ISelector.Holds the list of items that constitute the content of an
ISelector.Represents a serializer/deserializer for custom type in from/to json.
The label control.
Barcode lable option
Indicates the cell label options.
Represents leader lines on a chart.
Represents the legend in a chart.
Represents a collection of all the
ILegendEntry objects in thespecified chart legend.Represents a legend entry in a chart legend.
Represents a legend key in a chart legend.
Represents the
ILinearGradient object that transitions through aseries of colors in a linear manner along a specific angle.Represents line and arrowhead formatting.
The list box control.
Prevents generic type parameter erasure for
IItemCollection< ListBoxItem> .Prevents generic type parameter erasure for
IItemList< ListBoxItem> .Specifies the way an image how to be stretched to fill the destination rectangle.
Options for exporting image file.
Represents the image source.
Specifies the image type.
Specifies the description of the Japanese input rules.
Options for reading data
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.Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
Specifies the direction in which to shift cells during an insertion.
Specifies the invalid formula exception.
The option button control.
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.
PDF417 barcode is a popular high-density, two-dimensional barcode with symbology that possesses the capability to encode up to 1108 bytes of information.
Represents properties and methods that apply to pictures.
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.
Represents a collection of all the PivotField objects in a PivotTable report.
An object representing the order in which custom formulas are calculated in a PivotTable
Represents the collection of IPivotFormula
Represents an item in a PivotTable field.
A collection of all the PivotItem objects in the specified PivotTable.
Represents a collection of all the PivotItem objects in a PivotTable field.
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.
Represents the options whether to display pivot chart bottons.
Represents a PivotTable report on a 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 plot area of a chart.
Represents a single point in a chart series.
Represents a collection of all the
IPoint objects in the specifiedseries in a chart.Represents the various types of protection options available for a worksheet.
QRCode is a two dimensional barcode representing symbology that enables effective handling of numeric, alphanumeric and byte data.
Represents the IRange object.
Represents an element that has a value within a specific range.
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 ofcolors in a linear manner along a specific angleRepresents the rich text class for a cell.
The scrollbar control.
Represents a control that allows a user to select items from among its child elements.
Represents a control that allows a user to select items from among its child elements.
Represents a series in a chart.
Represents a collection of all the
ISeries objects in the specifiedchart.Represents an object in the drawing layer, such as an AutoShape, chart, or picture.
Represents a shape range, which is a set of shapes on a document.
A collection of all the
IShape objects on the specified sheet.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 aISlicerCache object.Represents information about the collection of
IPivotTablesassociated 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.
The spinner control.
Represents a style description for a range.
Represents a collection of all the
IStyle objects in the specified oractive workbook.Represents a table object on a worksheet.
Represents a column in a table.
Represents a collection of all the
ITableColumn objects in thespecified ITable object.Represents a row in the
ITable object.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 the text frame in the
com.grapecity.documents.excel.IShape object.Represents the text frame in the
com.grapecity.documents.excel.IShape.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 shape's three-dimensional formatting.
Represents the tick mark labels associated with tick marks on a chart axis.
Represents a top ten visual of a conditional formatting rule.
Represents a trendline in a chart.
Represents a collection of all
ITrendline objects for the specifiedseries.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 the walls of a 3-D chart.
Represents an IWorkbook object.
Represents the view settings of this workbook.
Represents a worksheet.
Represents a collection of all the sheets in the workbook.
Represents worksheet view options.
The json datasource for the template.
The base class for all the json error classes..
Specifies the cell label position.
Specifies the cell label visibility.
Specifies the way the specified PivotTable items appear—in table format or in outline format.
Specifies the type of layout row.
Specifies the position of the legend on a chart.
Specifies the cap type for a line.
Specifies the dash style for a line.
Specifies the corners style of two intersecting lines.
Specifies the style for a line.
Represents an item of
IListBox.Represents a logical literal node in the syntax tree.
Specifies whether a match is made against the whole of the search text or any part of the search text.
Gets or sets the watermark margin in pixels relative to the cell.
Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
Represents a name node in the syntax tree.
Represents a non-terminal node in the syntax tree.
Throws when unable to set the NumberFormat property of the Range class.
Represents a number node in the syntax tree.
Specifies the display mode when date or number data width is longer than the column width.
Represents the format in which the workbook is opened.
Base option class for opening.
Represents formula operators.
Represents an operator invocation expression in the syntax tree.
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.
Represent a page content info.
Represent the page information.
Represents the portrait or landscape printing mode.
Provides data for the PagePrinted event.
Provides data for the PagePrinting and PagePrinted events.
Provides data for the PagePrinting event.
Represent the settings of the page.
Represents the type of the page.
Represents the size of the paper.
Represents the parameter of a function.
Specifies the parent data label option for the specified series within the chart group.
Represents a parenthesis expression in the syntax tree.
Contains options for converting
string to FormulaSyntaxTree.Wraps all optional parameters in IRange.Copy(IRange, PasteType)
Specifies the type of paste.
Specifies the type for a gradient fill.
Specifies the interior pattern of a chart or interior object.
Specifies the fill pattern used in a shape.
Option class for saving csv file.
Represents the security setting.
Specifies the color transformation applied to a picture.
Specifies the PivotTable entity the cell corresponds to.
Specifies the subtotal function.
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.
Specifies the way an object is attached to its underlying cells.
Indicates the effects camera type used by the specified object.
Specifies which predefined gradient to use to fill a shape.
Specifies texture to be used to fill a shape.
Specifies an extrusion (three-dimensional) format.
Represents an PrintErrors contstant specifying the type of print error displayed.
Represents the way comments are printed with the sheet.
Represents a print settings class.
Represents print quality of this page.
Specifies data type of a document property.
Specifies EventArgs that contain a IRange object.
RangeTemplate provide a template from a range of referenced worksheet, it can apply to a cell.
Specified the text reading order.
Represents a rectangle class.
Represents a reference in formula.
Represents an reference node in the syntax tree.
Specifies whether to use A1 style or R1C1 style for cell references.
Represents the repeat settings of a range.
Wraps all optional parameters in IRange.Replace(object, object, ReplaceOptions) to be consistent with the Java edition.
Specifies whether the values that correspond to a particular data series are in rows or columns.
Represents the format in which the workbook is saved.
Base option class for saving.
Specifies the scale type of the value axis.
Specifies the search direction when searching a range.
Specifies the order in which to search the range.
Represents an checkBoxList/radioList item.
The selection mode of list box
Provides a base class for item types in a selection control.
Represents some settings when serialize workbook or worksheet to JSON.
Specifies the type of shape or range of shapes.
Represents EventArgs which contain a Worksheet object;
Represents the sheet type.
Provides signature details for application developers to implement the "Sign" button on "Signature Details" dialog.
Represents a Size class.
Specifies what the bubble size represents on a bubble chart.
Specifies the slicer sort order.
Specifies the color type
Specifies how to sort text.
Represents the sort base class.
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 cells with a particular type of value to include in the result.
Specifies the type of cells.
Specifies the position of the tab strip relative to the workbook.
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.
Represents a node in the syntax tree.
Represents a table item in the syntax tree.
Represents parts of a table.
Specifies the table style element used.
Represents a terminal node in the syntax tree.
Describes font and layout options for drawing text.
Represents a string literal node in the syntax tree.
Specifies the type of ITextRange.
Indicates the type of underline for text.
Specifies the alignment (the origin of the coordinate grid) for the tiling of the texture fill.
Specifies the texture type for the selected fill.
Specifies the theme color.
Specifies the theme font to use.
Represents the theme manager.
Specifies the text orientation for tick-mark labels.
Specifies the position of tick-mark labels on the specified axis.
Specifies the position of major and minor tick marks for an axis.
Specifies the time period.
Specifies the unit of time for chart axis and data series.
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 how the trendline that smoothes out fluctuations in the data is calculated.
This type supports the digital signature feature and is not intended to be used in your code directly.
Specifies the underline style of text.
Contains options for converting
FormulaSyntaxTree to string.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.
Represents the sort by value field.
Specifies the vertical alignment of text.
Specifies the vertical alignment of text in a text frame.
Represents the view type of the worksheet.
Specifies whether the object is visible.
Represents a workbook.
Represents a reference to an external workbook.
Provides access to the workbook write protection options.
Option class for opening xlsm file.
Option class for saving xlsm file.
Option class for opening xlsx file.
Option class for saving xlsx file.
Option class for opening xltx file.
Option class for saving xltx file.
Specifies where in the z-order a shape should be moved relative to other shapes.