Index

AboveBelow Enumeration
Access a Range
Access Areas in a Range
Access Cells, Rows and Columns in a Range
Add and Delete Table Columns and Rows
Add Slicer in Pivot Table
Add Slicer in Table
Add Validations
Adjust Column Width and Row Height
Area Chart
ArrayNode Class

ArrowheadLength Enumeration
ArrowheadStyle Enumeration
ArrowheadWidth Enumeration
AsyncCustomFunction Class

Asynchronous Functions
Auto Fit Row Height and Column Width
Auto-Filter Table with Slicer
AutoFilterOperator Enumeration
AutoShapeType Enumeration
Average Rule
Axis and Other Lines
AxisCrosses Enumeration
AxisGroup Enumeration
AxisType Enumeration
Background Image
BackgroundImageLayout Enumeration
Bar Chart
Barcodes
BarcodeType Enumeration
BarShape Enumeration
BaseCellType Class

BinsType Enumeration
BorderLineStyle Enumeration
BordersIndex Enumeration
Box Whisker
Breaking Changes
ButtonCellType Class

CalcError Enumeration
CalcReference Class

Calculation Mode
CalculationMode Enumeration
CancellationToken Class

CancellationTokenSource Class

CategoryType Enumeration
Cell Context
Cell Expansion
Cell Types
Cell Value Rule
CellColorSortField Class

CellInfo Class

CellPadding Class

CellTypeDirection Enumeration
CellTypeTextAlign Enumeration
Chart
Chart Area
Chart Sheet
Chart Title
Chart Types
Charts
ChartSplitType Enumeration
ChartType Enumeration
CheckBoxAlign Enumeration
CheckBoxCellType Class

CheckBoxListCellType Class

Codabar
Code128
Code39
Code49
Code93
Color Class

Color Scale Rule
ColorDataIndex Enumeration
ColorScaleType Enumeration
Column Chart
com.grapecity.documents.excel Package

com.grapecity.documents.excel.drawing Package

com.grapecity.documents.excel.expressions Package

com.grapecity.documents.excel.forms Package

Combo Chart
ComboBoxCellItem Class

ComboBoxCellType Class

Comments
Conditional Formatting
Conditional Formatting
ConditionValueTypes Enumeration
Configure Chart
Configure Chart Axis
Configure Chart Series
Configure Columns to Repeat at Left and Right
Configure Drafts
Configure Fonts and Set Style
Configure Page Breaks
Configure Page Header and Footer
Configure Page Settings
Configure Paper Settings
Configure Print Area
Configure Print Page Range
Configure Rows to Repeat at Top and Bottom
Configure Sheet Print Settings
Configure Slicer Layout
ConnectorType Enumeration
ConsolidationFunction Enumeration
ConstNode Class

Contacting Sales
ContainsOperator Enumeration
Control Pagination
Control Position of Overlapping Shapes
Convert Table to Range
Convert to Image
Create and Delete Chart
Create and Delete Tables
Create and Set Custom Named Style
Create Excel Report using Template
Create Pivot Table
Create Row or Column Group
Create Workbook
Cross Workbook Formula
CssExportType Enumeration
CsvOpenOptions Class

CsvParseContext Class

CsvParseResult Class

CsvSaveOptions Class

Custom Form Input Types
Custom Functions
CustomBorderStyle Class

CustomFunction Class

Customize Border Style
Customize Chart Objects
Customize Shape Format and Shape Text
Customize Worksheets
Cut or Copy Across Sheets
Cut or Copy Cell Ranges
Cut or Copy Shape, Slicer, Chart and Picture
Cut or Copy Slicer
Data Bar Rule
Data Binding
Data Label
Data Matrix
Data Source Binding
Data Table
Data Validations
DataBarAxisPosition Enumeration
DataBarBorderType Enumeration
DataBarDirection Enumeration
DataBarFillType Enumeration
DataBarNegativeColorType Enumeration
DataLabelPosition Enumeration
DataValidationJsonError Class

Date and Time Format for a Culture
Date and Time Format for a Culture
Date Occurring Rule
DateInfo Class

Default Values in Template Cells
Defined Names
Delete Blank Pages From Middle
Delete Validation
DeleteShiftDirection Enumeration
DeserializationOptions Class

Digital Signatures
Direction Enumeration
Display #N/A Values
DisplayBlanksAs Enumeration
DisplayUnit Enumeration
Document Properties
Document Solutions Data Viewer
Document Solutions for Excel, Java Edition Overview
DocumentProperties Class

Documents.for.Excel.Java.Edition.Packages Project

DrawingPictureType Enumeration
DropDownItem Class

DsExcel Dependencies
DupeUnique Enumeration
Duplicate Slicer
Dynamic Array Formulas
DynamicFilterType Enumeration
EAN-13
EAN-8
EccMode Enumeration
EditorValueType Enumeration
EmptyNode Class

Enable or Disable Calculation Engine
End User License Agreement
EndStyleCap Enumeration
Error Bars
ErrorBarDirection Enumeration
ErrorBarInclude Enumeration
ErrorBarType Enumeration
ErrorCorrectionLevel Enumeration
ErrorNode Class

Event<T> Class

EventArgs Class

EventHandler<T> Interface

Export Barcodes
Export Borders
Export Charts
Export Conditional Formatting
Export Custom Page Information
Export Different Headers On Different Pages
Export Fills
Export Form Controls to Form Fields
Export Last Page Without Headers
Export Multiple Sheets To One Page
Export Picture
Export Pivot Table Styles And Format
Export Shapes
Export Signature Lines
Export Slicers
Export Sparkline
Export Specific Pages to PDF
Export Table
Export Text
Export to HTML
Export to PDF
Export Vertical Text
Export Worksheet to PDF
Expression Rule
Features
File Operations
FillType Enumeration
Filter
Find and Replace Data
FindLookIn Enumeration
FindOptions Class

Fixed Layout
Floor
FontColorSortField Class

FontInfo Class

FontLanguageIndex Enumeration
Form Controls
FormatConditionOperator Enumeration
FormatConditionType Enumeration
FormControlOrientation Enumeration
FormControlType Enumeration
FormFieldSubmitFormatType Enumeration
Formula Functions
Formula Parser
FormulaJsonError Class

Formulas
FormulaSyntaxTree Class

Freeze Panes in a Worksheet
Freeze Trailing Panes in a Worksheet
FunctionNode Class

FunctionValueType Enumeration
Funnel
Get Address of Cell Range
Get Intersection, Union and Offset Range
Get Range and Range Area
Get Row and Column Count
Get Special Cell Ranges
Getting Started
Global Settings
Goal Seek Operation
GradientFillType Enumeration
GradientStyle Enumeration
GraphicColorType Enumeration
Group
Group or Ungroup Shapes
GS1- 128
HeaderFooterPosition Enumeration
HeaderFooterType Enumeration
Hide Rows and Columns
Histogram
HorizontalAlignment Enumeration
HorizontalAnchor Enumeration
HtmlSaveOptions Class

Hyperlink on Shape
HyperLinkCellType Class

Hyperlinks
HyperLinkTargetType Enumeration
IAboveAverage Interface

IAdjustments Interface

IAreas Interface

IAuthor Interface

IAutoCorrect Interface

IAutoFilter Interface

IAxes Interface

IAxis Interface

IAxisTitle Interface

IBackgroundPicture Interface

IBackgroundPictures Interface

IBarcode Interface

IBorder Interface

IBorders Interface

IBuiltInDocumentPropertyCollection Interface

IButton Interface

ICalcContext Interface

ICalculatedFields Interface

ICalculatedItems Interface

ICascadeSparkLine Interface

ICellCollection Interface

ICellColorSortField Interface

ICellLinkControl Interface

ICellLinkControlT<T> Interface

ICellPadding Interface

IChart Interface

IChartArea Interface

IChartBars Interface

IChartFormat Interface

IChartGroup Interface

IChartGroups Interface

IChartLines Interface

IChartTitle Interface

IColorFormat Interface

IColorScale Interface

IColorScaleCriteria Interface

IColorScaleCriterion Interface

IColorStop Interface

IColorStops Interface

IComment Interface

IComments Interface

ICommentsThreaded Interface

ICommentThreaded Interface

Icon Sets Rule
IConditionValue Interface

IConnectorFormat Interface

IconSetType Enumeration
IconSortField Class

IContainer Interface

IContentControl Interface

IControl Interface

IControlCollection Interface

IControlT<T> Interface

IconType Enumeration
ICrop Interface

ICsvParser Interface

ICustomDocumentPropertyCollection Interface

ICustomView Interface

ICustomViews Interface

IDataBar Interface

IDataBarBorder Interface

IDataLabel Interface

IDataLabels Interface

IDataMatrix Interface

IDataOptions Interface

IDataTable Interface

IDisplayFormat Interface

IDisplayUnitLabel Interface

IDocumentProperty Interface

IDocumentPropertyCollection Interface

IDropDown Interface

IDropDownItemList Interface

IEAN13 Interface

IEAN8 Interface

IErrorBar Interface

IExcelOptions Interface

IFillFormat Interface

IFontColorSortField Interface

IFontFormat Interface

IFontOption Interface

IFontProvider Interface

IFormatColor Interface

IFormatCondition Interface

IFormatConditions Interface

IFormulaOptions Interface

IFormulaResolver Interface

Ignore Errors in Cell Range
IgnoredErrorType Enumeration
IGradientStop Interface

IGradientStops Interface

IGraphic Interface

IGraphicsInfo Interface

IGridlines Interface

IGroupBox Interface

IGroupInfo Interface

IGroupShapes Interface

IGS1128 Interface

IHeaderFooter Interface

IHPageBreak Interface

IHPageBreaks Interface

IHyperlink Interface

IHyperlinks Interface

IIcon Interface

IIconCriteria Interface

IIconCriterion Interface

IIconSet Interface

IIconSetCondition Interface

IIconSets Interface

IIconSortField Interface

IInterior Interface

IItemCollection<T> Interface

IItemList<T> Interface

IJsonSerializer Interface

ILabel Interface

ILabelOption Interface

ILabelOptions Interface

ILeaderLines Interface

ILegend Interface

ILegendEntries Interface

ILegendEntry Interface

ILegendKey Interface

ILinearGradient Interface

ILineFormat Interface

IListBox Interface

IListBoxItemCollection Interface

IListBoxItemList Interface

Image Transparency
ImageLayout Enumeration
ImageSaveOptions Class

ImageSource Class

ImageType Enumeration
IMEModeType Enumeration
Import and Export .sjs Files
Import and Export .xlsx Document
Import and Export CSV File
Import and Export CSV Files with Delimiters
Import and Export Excel Options
Import and Export Excel Templates
Import and Export from JSON string
Import and Export from JSON Without Worksheets
Import and Export JSON Files
Import and Export JSON Stream
Import and Export Macros
Import and Export OLE Objects
Import and Export SpreadJS Files
Import CSV File with Custom Parser
ImportFlags Enumeration
IName Interface

INames Interface

INegativeBarFormat Interface

Insert And Delete Cell Ranges
Insert and Delete Rows and Columns
InsertShiftDirection Enumeration
InvalidFormulaException Class

IOptionButton Interface

IOutline Interface

IOutlineColumn Interface

IPictureFormat Interface

IPivotAxis Interface

IPivotCache Interface

IPivotCaches Interface

IPivotCell Interface

IPivotField Interface

IPivotFields Interface

IPivotFilter Interface

IPivotFilters Interface

IPivotFormula Interface

IPivotFormulas Interface

IPivotItem Interface

IPivotItemList Interface

IPivotItems Interface

IPivotLine Interface

IPivotLineCells Interface

IPivotLines Interface

IPivotOptions Interface

IPivotTable Interface

IPivotTables Interface

IPivotValueCell Interface

IPlotArea Interface

IPoint Interface

IPoints Interface

IProtectionSettings Interface

IQRCode Interface

IRange Interface

IRangeBase Interface

IRangeProvider Interface

IReadOnlySignatureDetails Interface

IRectangularGradient Interface

IRichText Interface

IScrollBar Interface

ISelector Interface

ISelectorT<T,TCollection> Interface

ISeries Interface

ISeriesCollection Interface

IShape Interface

IShapeRange Interface

IShapes Interface

IShrinkToFitSettings Interface

ISignature Interface

ISignatureSet Interface

ISignatureSetup Interface

ISlicer Interface

ISlicerCache Interface

ISlicerCaches Interface

ISlicerItem Interface

ISlicerItems Interface

ISlicerPivotTables Interface

ISlicers Interface

ISort Interface

ISortField Interface

ISortFields Interface

ISparkAxes Interface

ISparkColor Interface

ISparkHorizontalAxis Interface

ISparkline Interface

ISparklineGroup Interface

ISparklineGroups Interface

ISparkLineObject Interface

ISparkPoints Interface

ISparkVerticalAxis Interface

ISpinner Interface

IStyle Interface

IStyleCollection Interface

ITable Interface

ITableColumn Interface

ITableColumns Interface

ITableDataSource Interface

ITableRow Interface

ITableRows Interface

ITables Interface

ITableStyle Interface

ITableStyleCollection Interface

ITableStyleElement Interface

ITableStyleElements Interface

ITableStyleInfo Interface

Iterative Calculation
ITextFrame Interface

ITextRange Interface

ITextRun Interface

ITheme Interface

IThemeColor Interface

IThemeColorScheme Interface

IThemeFont Interface

IThemeFonts Interface

IThemeFontScheme Interface

IThreeDFormat Interface

ITickLabels Interface

ITop10 Interface

ITrendline Interface

ITrendlines Interface

IUniqueValues Interface

IValidation Interface

IValueSortField Interface

IVPageBreak Interface

IVPageBreaks Interface

IWall Interface

IWebRequestHandler Interface

IWorkbook Interface

IWorkbookView Interface

IWorksheet Interface

IWorksheets Interface

IWorksheetView Interface

Java API Documentation
JsonError Class

Keep Rows Together Over Page Breaks
Key Features
LabelAlignment Enumeration
LabelVisibility Enumeration
LayoutFormType Enumeration
LayoutRowType Enumeration
LegendPosition Enumeration
Legends
License Information
Line Chart
LineCapStyle Enumeration
LineDashStyle Enumeration
LineJoinStyle Enumeration
LineStyle Enumeration
Linked Picture
ListBoxItem Class

Localized Formulas
LogicalNode Class

LookAt Enumeration
Margin Class

MarkerStyle Enumeration
Measure Digital Width
Merge Cells
Modify Slicer with Custom Style
Modify Table Layout
Modify Table Layout for Slicer Style
Modify Table with Custom Style
Modify Tables
Modify Validation
NameNode Class

NonTerminalNode Class

NumberFormatParseException Class

NumberNode Class

NumbersFitMode Enumeration
Open and Save Workbook
OpenFileFormat Enumeration
OpenOptionsBase Class

OperatorKind Enumeration
OperatorNode Class

Order Enumeration
Outline Column
Outline Subtotals
PageBreakExtent Enumeration
PageContentInfo Class

PageInfo Class

PageOrientation Enumeration
PagePrintedEventArgs Class

PagePrintEventArgs Class

PagePrintingEventArgs Class

PageSettings Class

Paginated Templates
Pagination Properties and Functions
PaginationOrientation Enumeration
PaperSize Enumeration
Parameter Class

ParentDataLabelOptions Enumeration
ParenthesisNode Class

Pareto Chart
ParseContext Class

Paste or Ignore Data in Hidden Range
PasteOption Class

PasteType Enumeration
PathShapeType Enumeration
Pattern Enumeration
PatternType Enumeration
PDF Form Builder
PDF417
PdfSaveOptions Class

PdfSecurityOptions Class

PictureColorType Enumeration
Pie Chart
Pivot Chart
Pivot Table
Pivot Table Filter
Pivot Table Settings
Pivot Table Style
PivotCellType Enumeration
PivotFieldCalculation Enumeration
PivotFieldOrientation Enumeration
PivotFieldRepeatLabels Enumeration
PivotFilterOptions Class

PivotFilterType Enumeration
PivotLineType Enumeration
Placement Enumeration
Plot Area
Point Class

Precedents and Dependents
PresetCamera Enumeration
PresetGradientType Enumeration
PresetTexture Enumeration
PresetThreeDFormat Enumeration
Print Settings
PrintErrors Enumeration
PrintLocation Enumeration
PrintManager Class

PrintQuality Enumeration
PropertyType Enumeration
Protect Workbook
QRCode
Quick Start
Quote Prefix
Radar Chart
RadioButtonListCellType Class

Range Operations
Range Template Cell
RangeEventArgs Class

RangeFindReplace Class

RangeFindReplace.FindReplaceImpl Class

RangeFindReplace.FindReplaceImpl.FindMatch Interface

RangePartialClasses Class

RangePartialClasses.FindReplaceImpl Class

RangePartialClasses.FindReplaceImpl.FindMatch Interface

RangeTemplateCellType Class

ReadingOrder Enumeration
Rectangle Class

Redistribution
Reference Class

ReferenceNode Class

ReplaceOptions Class

Rich Text
Row or Column Group Information
RowCol Enumeration
Save Multiple Workbooks to Single PDF
SaveFileFormat Enumeration
SaveOptionsBase Class

ScaleType Enumeration
SearchDirection Enumeration
SearchOrder Enumeration
SelectFieldItem Class

SelectionMode Enumeration
SelectionModeType Enumeration
SelectorItem Class

SerializationOptions Class

Series
Set Array Formula
Set Cell Background Image for Cell Range
Set Custom Objects to a Range
Set Default Values for Cell Range
Set Formula to Range
Set Row Height and Column Width
Set Sheet Styling
Set Table Formula
Set Values to a Range
Shape Adjustment
Shapes And Pictures
ShapeType Enumeration
SheetEventArgs Class

SheetType Enumeration
Shrink To Fit With Text Wrap
SignatureDetails Class

Size and Position of Image
Size Class

SizeRepresents Enumeration
SjsOpenOptions Class

SjsSaveOptions Class

Slicer
Slicer
Slicer Style
SlicerSortOrder Enumeration
SolidColorType Enumeration
Sort
SortDataOption Enumeration
SortFieldBase Class

SortOnType Enumeration
SortOrder Enumeration
SortOrientation Enumeration
Sparkline
SparklineRowCol Enumeration
Sparklines
SparkScale Enumeration
SparkType Enumeration
SpecialCellsValue Class

SpecialCellType Enumeration
Specialized Chart
SpreadJS Sparklines
SpreadJSTabStripPosition Enumeration
Statistical Chart
Stock Chart
Styles
SubtotalLocationType Enumeration
SubtotalType Enumeration
Summary Row
SummaryColumn Enumeration
SummaryRow Enumeration
Sunburst
Support Background Color Transparency
Support Document Properties
Support for SpreadJS Features
Support Security Options
Support Sheet Background Image
Surface Chart
SyntaxNode Class

Table
Table Filters
Table Sort
Table Style
TableItemNode Class

TableItemType Class

Tables
TableStyleElementType Enumeration
TableStyleFactory Class

Tags
Technical Support
Template Configuration
Template Fields
Template Formula Usage
Template Properties
Templates
TerminalNode Class

TextAlignmentAnchor Enumeration
TextDirection Enumeration
TextFormatInfo Class

TextNode Class

TextRangeType Enumeration
TextUnderlineType Enumeration
TextureAlignment Enumeration
TextureType Enumeration
Theme
Theme Class

ThemeColor Enumeration
ThemeFont Enumeration
Themes Class

ThemeStorage Class

Threaded Comments
TickLabelOrientation Enumeration
TickLabelPosition Enumeration
TickMark Enumeration
TimePeriods Enumeration
TimeUnit Enumeration
Top Bottom Rule
TopBottom Enumeration
TotalsCalculation Enumeration
Track Export Progress
Treemap
TrendlineType Enumeration
UnderlineType Enumeration
Unique Rule
UnParseContext Class

Use Do Filter Operation
Use JDK 8 Date Time API
UsedRangeType Enumeration
ValidationAlertStyle Enumeration
ValidationOperator Enumeration
ValidationType Enumeration
ValueQuoteType Enumeration
ValueSortField Class

VerticalAlignment Enumeration
VerticalAnchor Enumeration
ViewType Enumeration
Visibility Enumeration
Walls
Waterfall Chart
WebRequestResult Class

Work with Used Range
Work with Worksheets
Workbook
Workbook Class

Workbook Views
WorkbookOptions Class

WorkbookReference Class

Working With Page Setup
Worksheet
Worksheet Views
WriteProtection Class

XlsmOpenOptions Class

XlsmSaveOptions Class

XlsxOpenOptions Class

XlsxSaveOptions Class

XltxOpenOptions Class

XltxSaveOptions Class

XY (Scatter) chart
ZOrderType Enumeration