package-summary
Package com.grapecity.documents.excel
package com.grapecity.documents.excel
-
ClassDescriptionSpecifies if the values are above or below average.Represents the base type for async custom function.Specifies the operator to use to associate two criteria applied by a filter.Indicates the auto merge direction.Indicates the auto merge mode.Specifies the auto merge selection mode.Specifies how a background image should be stretched to fill the destination rectangle.Specifies the type of barcode.Represents the base class for the other cell type classes.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.Excel calculation mode.Token that propagates notification that an operation should be cancelled.A
CancellationTokenSourceallows you to issue cancellation requests to one or more methods.To use a token source: Create a token source. Attach the token to one or more operations by passing the return value ofCancellationTokenSource.getToken()as parameter. Later, you can cancel the associated operations by callingCancellationTokenSource.cancel()on this token source.Specifies the interior sort.Indicates the cell decoration.Indicates the icon of cell decoration.Provide some helper functions.Gets or sets the cell padding.Specifies direction of the checkbox or radio list.Specifies the text alignment for checkbox/radiolist cells.Specifies the text alignment for check box cells.Represents a check box cell.Represents a check-box-list cell type.Creates the color structure.Specifies the color of a selected feature such as border, font, or fill.Specifies the type of color scale rule.Provides utility methods for colors.Represents an comboBox item.Represents an editable combo box cell.Specifies the types of condition values that can be used.Specifies the subtotal function.Specifies the operator used in a function.Indicates the corner fold of cell decoration.Describe the position of the corner fold in a cell.CSS export type.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.Option class for customising border when saving to PDF.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.The options for importing data to a range.Contains information of imported range.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.Represents the document properties of pdf.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 the error correction level of QRCode.Event<T>Represents an event.EventHandler<T extends EventArgs>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 possible values of GrapeCity.Documents.Pdf.Actions.ActionSubmitForm.SubmitFormat property.Represents the formula error in the json.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.Represents the hyperlink cell.Specifies the hyperlink's target type.Represents an above average visual of a conditional formatting rule.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 the auto merge range information.All types of barcode inherits this interface.Represents the border of an object.A collection of built-in document properties.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.Indicates the cell decoration.Indicates the icon of cell decoration.Gets or sets the cell padding.Codabar is a barcode that uses alphanumeric characters including : A B C D + - : .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 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 theIColorStopobjects for thespecified series.Represents a cell comment.Represents a collection of cell comments.A collection of top-level threaded comment objects in a Worksheet, or a collection of replies in a single threaded comment.Represents a cell's threaded comment.Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.Describe the position of the icon based on a cell.Specifies the type of icon set.Represents sorting by icon.Specifies the icon for a criterion in an icon set conditional formatting rule.Indicates the corner fold of cell decoration.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.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 custom or built-in document property.Represents a collection of document properties.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 option for working with Excel.Represents a filter for a single column.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.Font option.Provides the font provider.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.The types of errors that can occur in cell.Represents the picture field included in the specified header or footer.Provides graphics information.Represents the information of a group.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 a horizontal page break.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.Represents a serializer/deserializer for custom type in from/to json.Barcode lable optionIndicates the cell label options.Represents theILinearGradientobject that transitions through aseries of colors in a linear manner along a specific angle.Options for exporting image file.Represents the image source.Specifies the description of the Japanese input rules.Options for reading dataRepresents a defined name for a range of cells.Represents a collection of all theINameobjects 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.Determines how to handle insufficient space when importing data.Specifies the invalid formula exception.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 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.Represents a pivot filter in the PivotFilters collection.Represents a collection of all the pivot filters in the pivot field.An object representing the order in which custom formulas are calculated in a PivotTableRepresents the collection of IPivotFormulaRepresents 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 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 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.Provides access to theIRangeobject of cells in the worksheet.Represents read-only detail of the signature.TheIRectangularGradientobject transitions through a series ofcolors in a linear manner along a specific angleRepresents the rich text class for a cell.A scenario is a group of input values (called changing cells) that's named and saved.Represents the collection ofIScenarioobjects in the worksheet.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 aIWorkbook.Represents the current filter state for a slicer and information about whichIPivotCache.Represents the collection of slicer caches associated with the specified workbook.Represents an item in a slicer.Represents the collection ofISlicerItemobjects contained in aISlicerCacheobject.Represents information about the collection ofIPivotTablesassociated with the specifiedISlicerCacheobject.A collection ofISlicerobjects.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.SparkLine Object.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 theIStyleobjects in the specified oractive workbook.Represents a table object on a worksheet.Represents a column in a table.Represents a collection of all theITableColumnobjects in thespecifiedITableobject.Classes that implement this interface can be regarded asResultSetdata sourcesRepresents a row in theITableobject.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 aIRichTextobject.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.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.Defines an interface for handling web requests asynchronously.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 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 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.Throws when unable to set the NumberFormat property of the Range class.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 the order 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.Wraps all optional parameters in IRange.Copy(IRange, PasteType).Specifies the type of paste.Specifies the interior pattern of a chart or interior object.Option class for saving PDF file.Represents the security setting.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.Pivot filter optional settings, contains some special settings for Value filter, date filter, and top 10 filter.The type of pivot filterSpecifies 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 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.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.Represents the format in which the workbook is saved.Base option class for saving.Specifies the search direction when searching a range.Specifies the order in which to search the range.Represents an checkBoxList/radioList item.Specifies the selection mode of Button List CellType.Represents some settings when serialize workbook or worksheet to JSON.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.Option class for opening SpreadJS .sjs file.Option class for saving SpreadJS file.Specifies the slicer sort order.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.Specifies the table style element used.Describes font and layout options for drawing text.Specifies the theme color.Specifies the theme font to use.Represents the theme manager.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.Represents the sort by value field.Specifies the vertical alignment of text.Represents the view type of the worksheet.Specifies whether the object is visible.Represents the result of a web request, including the success status, the response content, any connection failure, and the HTTP status code.Represents a workbook.Options class for creating the 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.