package-summary
Package com.grapecity.documents.excel
package com.grapecity.documents.excel
-
ClassDescriptionSpecifies how a rule evaluates values against the average or standard deviation.Represents a message in a conversation with an AI model.Represents a request to an AI model.Represents the result of an AI model request.Represents the base type for an asynchronous custom function.Specifies the operator or filter type used by AutoFilter criteria.Specifies the direction for auto merge operations.Specifies the auto merge mode.Specifies the selection mode when auto merge is applied to a range.Specifies how a background image is laid out within the destination rectangle.Specifies the type of barcode.Represents the base class for all cell type classes.Specifies the line style for the border.Specifies which border of a cell or range to retrieve.Represents a button cell type.Specifies a calculation error value.Represents an area in a spreadsheet.Specifies the calculation mode used by Microsoft Excel when the exported workbook is opened.A token that propagates notification that operations should be canceled.Allows you to send cancellation requests to one or more operations.Specifies the type of cell element attribute used when exporting to HTML.Represents a sort field that sorts data by cell fill.Specifies the type of cell control applied to a range.Represents a cell decoration.Represents a cell decoration icon.Provides helper functions for converting between cell addresses and row/column indices.Represents the cell padding for a range.Represents a picture embedded in a cell (Picture-In-Cell).Specifies the layout direction of a checkbox list or radio button list cell type.Specifies the text alignment for checkbox/radiolist cells.Specifies the text alignment for check box cells.Represents a checkbox cell type.Represents a checkbox list cell type.Represents a color value used by GcExcel.Represents special color index values available for color index properties of borders, fonts, or fills.Specifies the type of color scale rule.Provides utility methods for working with colors.Represents a combo box item.Represents an editable combo box cell.Specifies the types of condition values that can be used.Specifies the subtotal function.Specifies the text matching operator used by a
FormatConditionType.TextStringconditional formatting rule.Represents corner fold decoration settings that can be applied to a cell.Specifies the position of a folded corner in a cell decoration.CSS export type.Represents options for opening a CSV file.Represents the context for parsing the current CSV cell.Represents the parsed CSV value and its number format.Represents options for saving a workbook as a CSV file.Represents custom border rendering options for PDF export.Represents the base type for a 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 negative data bars use a dedicated color or the same color as positive data bars.Represents options that control how data is imported into a range.Contains information about an imported range.Represents a JSON import error related to data validation.Provides helper methods for converting between OADate values and Java date-time types.Specifies how to shift cells to replace deleted cells.Represents options that control how workbook or worksheet content is deserialized from JSON.Specifies the direction in which to move.Specifies how blank cells are plotted on a chart.Represents the document properties of a PDF document.Specifies whether a unique values conditional formatting rule evaluates unique values or duplicate values.Specifies the filter type.Specifies the error correction mode used by a DataMatrix barcode.Specifies what is written to the data model when a user selects an item from a cell type that supports multiple choices.Represents the error correction level of a QR code.Event<T>Represents a lightweight event container for registering and enumerating listeners.Represents the base class for event data.EventHandler<T extends EventArgs>Represents a handler method for an event.Specifies the type of data to search in when usingIRange.find(Object,IRange,FindOptions).Wraps the optional parameters used by range search operations.Represents a sort field that sorts data by font color.Contains information about a font used in a workbook.Specifies the font language type.Specifies the operator used by a conditional formatting rule to compare a formula with a cell value, or, forFormatConditionOperator.BetweenandFormatConditionOperator.NotBetween, to compare two formulas.Specifies the type of a conditional formatting rule.Represents a formula-related error in imported JSON content.Specifies the value type of a custom function parameter or result.Specifies the type of gradient fill.Specifies the horizontal alignment of a cell or object.Represents a hyperlink cell type.Specifies the target location where a hyperlink is opened.Represents a conditional formatting rule that evaluates cell values by comparing them with the range average or a standard deviation threshold.Provides an abstraction for sending asynchronous requests to AI models and receiving structured responses.Represents a collection of range areas.Represents the author of a threaded comment.Represents autofiltering for the specified worksheet.Represents the auto merge range information.Represents the common interface for all barcode types.Represents the border of an object.Represents a collection of border objects for a range or style.A collection of built-in document properties.Represents the context of the calculation.A collection ofIPivotFieldobjects that represents all the calculated fields in the specified PivotTable report.A collection ofIPivotItemobjects that represent all the calculated items in the specified PivotTable report.Represents a cascade sparkLine.Represents the sort field by cell color.Represents the cell control.Represents a cell decoration.Represents the icon of a cell decoration.Represents the cell padding.Represents a Codabar barcode.Represents a Code 128 barcode.Represents a Code 39 barcode.Represents a Code 49 barcode.Represents a Code 93 linear barcode.Represents a color scale conditional formatting rule.Represents a collection ofIColorScaleCriterionobjects that define all criteria for a color scale conditional format.Represents the criteria for the minimum, midpoint, or maximum thresholds for a color scale conditional format.Represents a gradient stop in a gradient fill for a range or selection.Represents a collection ofIColorStopobjects for a linear or rectangular gradient fill.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.Specifies the position of an icon relative to a cell.Specifies the built-in icon set types used in icon set conditional formatting rules.Represents a sort field that sorts data by a specified conditional-formatting icon.Specifies the icon for a criterion in an icon set conditional formatting rule.Indicates the corner fold of cell decoration.Represents a custom CSV parser.A collection of custom document properties.Represents a custom workbook view.A collection of custom workbook views.Represents a Custom XML part in a workbook.Represents a collection of Custom XML parts in a workbook.Represents a data bar conditional formatting 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 associatedIRange.Represents a custom or built-in document property.Represents a collection of document properties.Represents an EAN-13 barcode.Represents an EAN-8 barcode.Represents options for processing Excel workbooks.Represents a filter for a single column.Represents a collection ofIFilterobjects that represent all filters in an autofiltered range.Represents font formatting for a range, style, or text run.Represents the sort field by font color.Represents font options for barcode label text.Provides font files as streams for AutoFit, PDF export, and image export.Represents a format color item, such as a color scale threshold color, a data bar color, a data bar axis color, a negative data bar fill color or border color, or a sparkline color.Represents a conditional format.Represents the conditional formats associated with a range.Represents the options related to formula calculation, performance, and error handling.Provides custom name resolution used by formulas.Specifies the types of errors that can be ignored in cells.Represents the picture field included in the specified header or footer.Provides graphics measurement information required for workbook layout calculations.Represents information about a worksheet outline group.Represents a GS1-128 barcode.Represents one section of a page header or footer that can contain text or a picture.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, range, or shape.Represents a single icon in an icon set used in a conditional formatting rule.Represents the collection ofIIconCriterionobjects.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 and deserializer for custom types used in JSON import and export.Represents label display options for a barcode.Indicates the cell label options.Represents theILinearGradientobject that transitions through a series of colors in a linear manner along a specific angle.Represents options for exporting a worksheet, range, or shape to an image file.Represents an image source.Specifies the input method editor (IME) mode used by a data validation rule.Specifies which parts of a worksheet are imported when a workbook is opened.Represents a defined name for a range of cells.Represents a collection ofINameobjects that store defined names.Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.Specifies the direction to shift cells when inserting a cell or a range of cells into a worksheet.Specifies how GcExcel handles insufficient destination space when importing data into a range.The exception that is thrown when a formula is invalid.Specifies how invalid formulas are handled.Represents an outline on a worksheet.Represents the outline column for a worksheet.Represents the header and footer sections for a printed page.Represents the page setup description.Represents a worksheet pane.Represents the panes in a worksheet.Represents a PDF417 barcode.Provides a custom rendering engine for saving a workbook as PDF.Represents the axis for a PivotTable report.Represents the memory cache for a PivotTable report.Represents the collection of memory caches for PivotTable reports in a workbook.Represents a cell in a PivotTable report.Represents a field in a PivotTable report.Represents the collection ofIPivotFieldobjects in a PivotTable report.Represents a pivot filter in theIPivotFilterscollection.Represents a collection of all the pivot filters in a pivot field.Represents a custom formula in a PivotTable report.Represents the collection of custom formulas in a PivotTable.Represents a pivot item in a PivotTable field.Represents a collection ofIPivotItemobjects in a PivotTable field.Represents a collection of allIPivotItemobjects in a PivotTable field.Represents a line of rows or columns in a PivotTable.Represents the collection ofIPivotCellobjects in a specificIPivotLine.Represents a collection of lines on the row or column axis of a PivotTable report.Represents a PivotTable report on a worksheet.Represents the collection of allIPivotTableobjects on a specified worksheet.Represents a PivotTable value cell and provides access to its value and relatedIPivotCellwhen an actual cell range is not available.Represents the various types of protection options available for a worksheet.Represents a barcode object created by theBC_QRCODEformula.Represents cells, rows, columns, or cell ranges in a worksheet.Provides access toIRangeobjects in a worksheet.Represents read-only details of a digital signature.Represents a rectangular gradient fill definition.Represents rich text content in 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 a sheet tab.Represents a collection of all sheet tabs in a workbook.Represents the shrink to fit settings of this workbook.Corresponds to a digital signature that is attached to a document.A collection of ISignature objects that correspond to the digital signatures attached to a document.Represents the information used to set up a signature packet.Represents a slicer in a workbook.Represents the current filter state of a slicer cache and information about the data source associated with the slicer.Represents a collection of slicer caches associated with a workbook.Represents an item in a slicer.Represents the collection ofISlicerItemobjects in anISlicerCache.Represents the collection ofIPivotTableobjects associated with a specifiedISlicerCache.Represents a collection ofISlicerobjects.Represents sort settings.Represents a sort field.Represents the sort condition list.Represents the settings for the horizontal and vertical axes of a group of sparklines.Represents color and visibility settings for a sparkline point marker or horizontal axis.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 a single 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 that can be applied to a range.Represents a collection of all theIStyleobjects in a specified workbook or the active workbook.Represents a table object on a worksheet.Represents a column in a table.Represents a collection of allITableColumnobjects in a specifiedITable.Represents a custom table data source.Represents a row in anITable.Represents the collection of allITableobjects in a 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 the collection of table style elements in a table style.Represents a range of characters in aIRichTextobject.Contains the theme information.Represents the theme color information.Represents the theme color scheme.Represents a theme font.Contains the theme fonts in different languages.Specifies the font theme to use.Represents a conditional formatting rule that highlights the top or bottom N values.Represents a conditional formatting rule that highlights duplicate or unique values in a 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.Defines workbook-level APIs for working with spreadsheets.Represents the view settings of this workbook.Represents a worksheet in a workbook.Represents a collection of all worksheets in a workbook.Represents worksheet view options.Represents the base type for JSON-related errors.Specifies the position of a cell label within a range.Specifies the visibility of a cell label watermark.Specifies how PivotTable items are displayed for a field.Specifies the row axis layout type for a pivot table.Specifies whether a search matches against the whole cell content or any part of it.Represents the watermark margin in pixels relative to a cell.Represents an exception thrown when a range number format cannot be parsed.Specifies the display mode when date or number data width is longer than the column width.Represents the file format to use when opening a workbook.Base class for workbook open options.Represents the order uses to number pages when printing a large worksheet.Specifies whether a page break applies to the entire worksheet or only within the print area.Represents the printable content area of a page.Represents information about a printed page.Represents the portrait or landscape printing mode.Provides data for the PagePrinted event.Provides data for the PagePrinting and PagePrinted events.Provides data for thePdfSaveOptions.getPagePrintingEvent()event.Represents page-level print settings.Specifies whether pagination is calculated horizontally or vertically.Represents the size of the paper.Represents a parameter definition for a custom function.Represents options that control how a copied range is pasted.Specifies the type of content to paste during a range copy operation.Represents the fill pattern for the interior area of a cell or range.Represents options for saving a workbook to PDF.Represents PDF security settings.Specifies the PivotTable entity the cell corresponds to.Specifies how a PivotTable data field is calculated.Represents the settings used to create a custom group from PivotItems in a PivotField.Specifies date and time units that can be used to group a PivotField.Represents the settings used to group a PivotField by date or time units.Represents the settings used to group a PivotField into numeric ranges.Specifies the location of a field in a PivotTable report.Specifies whether item labels are repeated in a PivotTable report.Represents optional settings for a pivot filter.Represents filter types that can be applied to a PivotTable field.Specifies the type of a pivot line.Represents a point with x- and y-coordinates.Specifies how cell error values are printed on a worksheet.Represents the way comments are printed with the sheet.Represents a print manager for pagination and PDF print output.Specifies the print quality used for a worksheet page setup.Specifies the data type of a document property.Represents a radio button list cell type.Represents event arguments that contain anIRangeobject.Provides a range template from a referenced worksheet that can be applied to a cell.Specifies the text reading order.Represents a rectangle defined by an upper-left corner and a size.Specifies the cell reference style used in a workbook.Represents the repeat settings of a range.Wraps the optional parameters used byIRange.replace(Object,Object,ReplaceOptions).Represents the format in which the workbook is saved.Base class for save options used by workbook and worksheet save operations.Specifies the direction to search within a range when using theIRange.find(Object,IRange,FindOptions)method.Specifies the order in which to search a range.Represents an item in aCheckBoxListCellTypeorRadioButtonListCellType.Represents options used when serializing a workbook or worksheet to JSON.Represents EventArgs which contain a Worksheet object;Specifies the type of a sheet tab.Represents the type of a sheet.Provides signature details for application developers to implement the "Sign" button on "Signature Details" dialog.Represents a two-dimensional size defined by width and height values.Represents options for opening a SpreadJS.sjsfile.Options for saving a workbook as a SpreadJS `.sjs` file.Specifies the sort order for slicer items.Specifies how text values are handled during sorting.Represents the abstract base class for sort fields.Specifies the criterion used to sort data.Specifies the sort order.Specifies the orientation used when sorting a range.Specifies how sparklines are plotted when the source data is in a square-shaped range.Specifies how the minimum or maximum value of a sparkline vertical axis is scaled relative to other sparklines in the group.Specifies the type of sparkline.Specifies cells with a particular value type to include in the result.Specifies the type of special cells to find within a range.Specifies the position of the SpreadJS tab strip relative to the workbook.Specifies where subtotals are displayed in a PivotTable report.Specifies the type of subtotal for the specified pivot field.Specifies the position of the summary column in an outline.Specifies the position of the summary row in an outline.Specifies the type of a table style element.Describes font and layout options for drawing text.Contains the theme information.Specifies the built-in theme colors in their displayed order.Specifies the theme font to use.Represents a theme manager.Specifies a relative time period used by date-based conditional formatting rules.Specifies whether a top 10 conditional formatting rule evaluates the highest values or the lowest values in a series.Specifies the type of calculation in the totals row of a table column.Specifies the underline style of text.Specifies the feature type used to determine the used range of a worksheet.Specifies the icon used in message boxes displayed during validation.Specifies the operator used by data validation to compare a formula against a cell value or, forValidationOperator.BetweenandValidationOperator.NotBetween, to compare two formulas.Specifies the type of data validation test to apply to cell values.Specifies how values are quoted when a workbook is exported as a text file.Represents a sort field that sorts data by cell values.Specifies the vertical alignment of text.Represents the worksheet view type.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.Represents options used when creating aWorkbook.Provides access to the workbook write protection options.Represents options for opening an XLSM workbook.Represents options for saving a workbook as an XLSM file.Represents options for opening an XLSX file.Represents options for saving a workbook as an .xlsx file.Represents options for opening an XLTX template file.Represents options for saving a workbook as an XLTX template file.