Documents for Excel, Java Edition Documentation
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 Average Rule
Add Cell Value Rule
Add Color Scale Rule
Add Data Bar Rule
Add Date Occurring Rule
Add Expression Rule
Add Icon Sets Rule
Add Slicer in Pivot Table
Add Slicer in Table
Add Top Bottom Rule
Add Unique Rule
Add Validations
Adjust Column Width and Row Height
Allow Sort
Apply Comments
Apply Conditional Formatting
Apply Data Validations
Apply Filters
Apply Grouping
Apply Outline Subtotals
Apply Slicer Style
Apply Style
Apply Style To Pivot Table
Apply Table Sort
Apply Table Style
Apply Theme
Area Chart
ArrowheadLength Enumeration
ArrowheadStyle Enumeration
ArrowheadWidth Enumeration
Auto Fit Row Height and Column Width
Auto-Filter Table with Slicer
AutoFilterOperator Enumeration
AutoShapeType Enumeration
Axis and Other Lines
AxisCrosses Enumeration
AxisGroup Enumeration
AxisType Enumeration
Bar Chart
BarShape Enumeration
BaseCellType Class
Members
Methods
Overview
BaseDataManager<T> Class
Members
Methods
Overview
BinsType Enumeration
BorderLineStyle Enumeration
BordersIndex Enumeration
Box Whisker
ButtonCellType Class
Members
Methods
Overview
CalcError Enumeration
CalcReference Class
Members
Methods
Overview
CategoryType Enumeration
Cell Context
Cell Expansion
Cell Rules
CellColorSortField Class
Members
Methods
Overview
CellRichText Class
Members
Methods
Overview
CellRichTextFont Class
Members
Methods
Overview
CellRichTextRun Class
Members
Methods
Overview
Chart
Chart Area
Chart Sheet
Chart Title
ChartSplitType Enumeration
ChartType Enumeration
CheckBoxAlign Enumeration
CheckBoxCellType Class
Members
Methods
Overview
Color Class
Fields
Members
Methods
Overview
ColorDataIndex Enumeration
ColorScaleType Enumeration
Column Chart
ColumnPageContentInfo Class
Fields
Members
Methods
Overview
ColumnPageInfo Class
Fields
Members
Overview
com.grapecity.documents.excel Package
Inheritance Hierarchy
Overview
com.grapecity.documents.excel.drawing Package
Inheritance Hierarchy
Overview
Combo Chart
ComboBoxCellItem Class
Members
Methods
Overview
ComboBoxCellType Class
Members
Methods
Overview
Comments
CompositeCellRichTextRun Class
Members
Methods
Overview
Conditional Format
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 JDK 8 Date Time API
Configure Page Breaks
Configure Page Header and Footer
Configure Page Settings
Configure Paper Settings
Configure Print Area
Configure Print Page Range
Configure Print Settings via Page Setup
Configure Rows to Repeat at Top and Bottom
Configure Sheet Print Settings
Configure Slicer Layout
ConnectorType Enumeration
ConsolidationFunction Enumeration
ContainsOperator Enumeration
Control Pagination
Create and Delete Chart
Create and Delete Tables
Create and Set Custom Named Style
Create Excel Report using Tempate
Create Pivot Table
Create Row or Column Group
Create Workbook
CsvOpenOptions Class
Members
Methods
Overview
CsvSaveOptions Class
Members
Methods
Overview
CustomCellType Class
Members
Methods
Overview
CustomFunction Class
Fields
Members
Methods
Overview
Customize Chart Objects
Customize Shape Format and Shape Text
Customize User Interaction
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 Label
Data Source Binding
Data Validation
DataBarAxisPosition Enumeration
DataBarBorderType Enumeration
DataBarDirection Enumeration
DataBarFillType Enumeration
DataBarNegativeColorType Enumeration
DataLabelPosition Enumeration
Delete Blank Pages From Middle
Delete Validation
DeleteShiftDirection Enumeration
Direction Enumeration
DisplayBlanksAs Enumeration
DisplayUnit Enumeration
DocumentProperties Class
Members
Methods
Overview
Documents for Excel, Java Edition Packages Project
Overview
DrawingExReader Class
Members
Methods
Overview
DrawingExWriter Class
Fields
Members
Methods
Overview
DrawingPictureType Enumeration
DupeUnique Enumeration
Duplicate Slicer
DynamicFilterType Enumeration
EditorValueType Enumeration
Enable or Disable Calculation Engine
End User License Agreement
EndStyleCap Enumeration
Event<T> Class
Members
Methods
Overview
EventArgs Class
Fields
Members
Overview
EventHandler<T> Interface
Members
Methods
Overview
Export Borders
Export Conditional Formatting
Export Custom Page Information
Export Different Headers On Different Pages
Export Fills
Export Last Page Without Headers
Export Multiple Sheets To One Page
Export Picture
Export Pivot Table Styles And Format
Export Shapes
Export Slicers
Export Sparkline
Export Specific Pages to PDF
Export Table
Export Text
Export to a PDF File
Export Vertical Text
Features
FillType Enumeration
Find and Replace Data
FindLookIn Enumeration
FindOptions Class
Members
Methods
Overview
Floor
FontColorSortField Class
Members
Methods
Overview
FontInfo Class
Fields
Members
Methods
Overview
FontLanguageIndex Enumeration
FormatConditionOperator Enumeration
FormatConditionType Enumeration
Formula
Formula Functions
Freeze Panes in a Worksheet
FunctionValueType Enumeration
Funnel
GcExcel Java Overview
Get Range and Range Area
Get Row and Column Count
Get Started
GradientFillType Enumeration
GradientStyle Enumeration
GraphicColorType Enumeration
Group
Group or Ungroup Shapes
Hide Rows and Columns
Histogram
HorizontalAlignment Enumeration
HyperLink Class
Members
Methods
Overview
Hyperlink on Shape
HyperLinkCellType Class
Members
Methods
Overview
Hyperlinks
Hyperlinks Class
Fields
Members
Methods
Overview
HyperLinkTargetType Enumeration
IAboveAverage Interface
Members
Methods
Overview
IAdjustments Interface
Members
Methods
Overview
IAreas Interface
Members
Methods
Overview
IAutoCorrect Interface
Members
Methods
Overview
IAutoFilter Interface
Members
Methods
Overview
IAxes Interface
Members
Methods
Overview
IAxis Interface
Members
Methods
Overview
IAxisTitle Interface
Members
Overview
IBaseDataManager Interface
Members
Methods
Overview
IBorder Interface
Members
Methods
Overview
IBorders Interface
Members
Methods
Overview
ICalcContext Interface
Members
Methods
Overview
ICellCollection Interface
Members
Methods
Overview
ICellColorSortField Interface
Members
Methods
Overview
IChart Interface
Members
Methods
Overview
IChartArea Interface
Members
Methods
Overview
IChartBars Interface
Members
Methods
Overview
IChartFormat Interface
Members
Methods
Overview
IChartGroup Interface
Members
Methods
Overview
IChartGroups Interface
Members
Methods
Overview
IChartLines Interface
Members
Methods
Overview
IChartTitle Interface
Members
Methods
Overview
IColorFormat Interface
Members
Methods
Overview
IColorScale Interface
Members
Methods
Overview
IColorScaleCriteria Interface
Members
Methods
Overview
IColorScaleCriterion Interface
Members
Methods
Overview
IColorStop Interface
Members
Methods
Overview
IColorStops Interface
Members
Methods
Overview
IComment Interface
Members
Methods
Overview
ICommentForDrawing Interface
Members
Methods
Overview
IComments Interface
Members
Methods
Overview
IConditionValue Interface
Members
Methods
Overview
IConnectorFormat Interface
Members
Methods
Overview
IconSetType Enumeration
IconSortField Class
Members
Methods
Overview
IContainer Interface
Members
Methods
Overview
IconType Enumeration
ICrop Interface
Members
Methods
Overview
IDataBar Interface
Members
Methods
Overview
IDataBarBorder Interface
Members
Methods
Overview
IDataLabel Interface
Members
Methods
Overview
IDataLabels Interface
Members
Methods
Overview
IDisplayFormat Interface
Members
Methods
Overview
IDisplayUnitLabel Interface
Members
Methods
Overview
IFillFormat Interface
Members
Methods
Overview
IFilter Interface
Members
Methods
Overview
IFilters Interface
Members
Methods
Overview
IFloor Interface
Members
Methods
Overview
IFont Interface
Members
Methods
Overview
IFontColorSortField Interface
Members
Methods
Overview
IFontFormat Interface
Members
Methods
Overview
IFormatColor Interface
Members
Methods
Overview
IFormatCondition Interface
Members
Methods
Overview
IFormatConditions Interface
Members
Methods
Overview
IGradientStop Interface
Members
Methods
Overview
IGradientStops Interface
Members
Methods
Overview
IGraphic Interface
Members
Methods
Overview
IGridlines Interface
Members
Methods
Overview
IGroupShapes Interface
Members
Methods
Overview
IHeaderFooter Interface
Members
Methods
Overview
IHPageBreak Interface
Members
Methods
Overview
IHPageBreaks Interface
Members
Methods
Overview
IHyperlink Interface
Members
Methods
Overview
IHyperlinks Interface
Members
Methods
Overview
IIcon Interface
Members
Methods
Overview
IIconCriteria Interface
Members
Methods
Overview
IIconCriterion Interface
Members
Methods
Overview
IIconSet Interface
Members
Methods
Overview
IIconSetCondition Interface
Members
Methods
Overview
IIconSets Interface
Members
Methods
Overview
IIconSortField Interface
Members
Methods
Overview
IInterior Interface
Members
Methods
Overview
IJsonSerializer Interface
Members
Methods
Overview
IJSR310TypeHandler Interface
Members
Methods
Overview
ILeaderLines Interface
Members
Methods
Overview
ILegend Interface
Members
Methods
Overview
ILegendEntries Interface
Members
Methods
Overview
ILegendEntry Interface
Members
Methods
Overview
ILegendKey Interface
Members
Methods
Overview
ILinearGradient Interface
Members
Methods
Overview
ILineFormat Interface
Members
Methods
Overview
ImageType Enumeration
IMEModeType Enumeration
Import and Export .xlsx Document
Import and Export CSV File
Import and Export CSV Files with Delimiters
Import and Export JSON Stream
Import and Export Macros
Import and Export OLE Objects
ImportFlags Enumeration
IName Interface
Members
Methods
Overview
INames Interface
Members
Methods
Overview
INegativeBarFormat Interface
Members
Methods
Overview
Insert And Delete Cell Ranges
Insert and Delete Rows and Columns
InsertDeleteCellsEventArg Class
Fields
Members
Methods
Overview
InsertShiftDirection Enumeration
IOutline Interface
Members
Methods
Overview
IPage Interface
Members
Methods
Overview
IPageSetup Interface
Members
Methods
Overview
IPane Interface
Members
Methods
Overview
IPanes Interface
Members
Methods
Overview
IPictureFormat Interface
Members
Methods
Overview
IPivotCache Interface
Members
Methods
Overview
IPivotCaches Interface
Members
Methods
Overview
IPivotField Interface
Members
Methods
Overview
IPivotFields Interface
Members
Methods
Overview
IPivotItem Interface
Members
Methods
Overview
IPivotItems Interface
Members
Methods
Overview
IPivotTable Interface
Members
Methods
Overview
IPivotTables Interface
Members
Methods
Overview
IPlotArea Interface
Members
Methods
Overview
IPoint Interface
Members
Methods
Overview
IPoints Interface
Members
Methods
Overview
IProtectionSettings Interface
Members
Methods
Overview
IRange Interface
Members
Methods
Overview
IRangeProvider Interface
Members
Methods
Overview
IRectangularGradient Interface
Members
Methods
Overview
IRichText Interface
Members
Methods
Overview
ISeries Interface
Members
Methods
Overview
ISeriesCollection Interface
Members
Methods
Overview
IShape Interface
Members
Methods
Overview
IShapeRange Interface
Members
Methods
Overview
IShapes Interface
Members
Methods
Overview
IShrinkToFitSettings Interface
Members
Methods
Overview
ISlicer Interface
Members
Methods
Overview
ISlicerCache Interface
Members
Methods
Overview
ISlicerCaches Interface
Members
Methods
Overview
ISlicerForDrawing Interface
Members
Methods
Overview
ISlicerItem Interface
Members
Methods
Overview
ISlicerItems Interface
Members
Methods
Overview
ISlicerPivotTables Interface
Members
Methods
Overview
ISlicers Interface
Members
Methods
Overview
ISort Interface
Members
Methods
Overview
ISortField Interface
Members
Methods
Overview
ISortFields Interface
Members
Methods
Overview
ISparkAxes Interface
Members
Methods
Overview
ISparkColor Interface
Members
Methods
Overview
ISparkHorizontalAxis Interface
Members
Methods
Overview
ISparkline Interface
Members
Methods
Overview
ISparklineGroup Interface
Members
Methods
Overview
ISparklineGroups Interface
Members
Methods
Overview
ISparkPoints Interface
Members
Methods
Overview
ISparkVerticalAxis Interface
Members
Methods
Overview
IStyle Interface
Members
Methods
Overview
IStyleCollection Interface
Members
Methods
Overview
IStyleContext Interface
Members
Methods
Overview
ITable Interface
Members
Methods
Overview
ITableColumn Interface
Members
Methods
Overview
ITableColumns Interface
Members
Methods
Overview
ITableRow Interface
Members
Methods
Overview
ITableRows Interface
Members
Methods
Overview
ITables Interface
Members
Methods
Overview
ITableStyle Interface
Members
Methods
Overview
ITableStyleCollection Interface
Members
Methods
Overview
ITableStyleElement Interface
Members
Methods
Overview
ITableStyleElements Interface
Members
Methods
Overview
ITableStyleInfo Interface
Members
Methods
Overview
ITextFrame Interface
Members
Methods
Overview
ITextRange Interface
Members
Methods
Overview
ITextRun Interface
Members
Methods
Overview
ITheme Interface
Members
Methods
Overview
IThemeColor Interface
Members
Methods
Overview
IThemeColorScheme Interface
Members
Methods
Overview
IThemeContext Interface
Members
Methods
Overview
IThemeFont Interface
Members
Methods
Overview
IThemeFonts Interface
Members
Methods
Overview
IThemeFontScheme Interface
Members
Methods
Overview
IThreeDFormat Interface
Members
Methods
Overview
ITickLabels Interface
Members
Methods
Overview
ITop10 Interface
Members
Methods
Overview
ITrendline Interface
Members
Methods
Overview
ITrendlines Interface
Members
Methods
Overview
IUniqueValues Interface
Members
Methods
Overview
IValidation Interface
Members
Methods
Overview
IValues Interface
Members
Methods
Overview
IValueSortField Interface
Members
Methods
Overview
IVPageBreak Interface
Members
Methods
Overview
IVPageBreaks Interface
Members
Methods
Overview
IWall Interface
Members
Methods
Overview
IWorkbook Interface
Members
Methods
Overview
IWorkbookView Interface
Members
Methods
Overview
IWorksheet Interface
Members
Methods
Overview
IWorksheetForDrawing Interface
Members
Methods
Overview
IWorksheets Interface
Members
Methods
Overview
IWorksheetView Interface
Members
Methods
Overview
Java API Documentation
Keep Rows Together Over Page Breaks
Key Features
LayoutRowType Enumeration
LegendPosition Enumeration
Legends
License Information
Line Chart
LineCapStyle Enumeration
LineDashStyle Enumeration
LineJoinStyle Enumeration
LineStyle Enumeration
LookAt Enumeration
Manage Custom Functions
Manage Data
Manage File Operations
Manage Formulas
Manage Hyperlinks
Manage Workbook
Manage Worksheet
MarkerStyle Enumeration
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
Open and Save Workbook
OpenFileFormat Enumeration
OpenOptionsBase Class
Members
Methods
Overview
Order Enumeration
Page Setup
PageBreakExtent Enumeration
PageContentInfo Class
Members
Methods
Overview
PageInfo Class
Members
Methods
Overview
PageOrientation Enumeration
PageSettings Class
Members
Methods
Overview
PageType Enumeration
PaperSize Enumeration
Parameter Class
Members
Methods
Overview
ParentDataLabelOptions Enumeration
Pareto Chart
PasteType Enumeration
Pattern Enumeration
PatternType Enumeration
PDF Export
PdfSaveOptions Class
Members
Methods
Overview
PdfSecurityOptions Class
Members
Methods
Overview
PictureColorType Enumeration
Pie Chart
Pivot Table Settings
PivotFieldAndDataFieldData Class
Members
Methods
Overview
PivotFieldOrientation Enumeration
Placement Enumeration
Plot Area
Precedents and Dependents
PresetCamera Enumeration
PresetGradientType Enumeration
PresetTexture Enumeration
PresetThreeDFormat Enumeration
PrintErrors Enumeration
PrintLocation Enumeration
PrintManager Class
Members
Methods
Overview
PrintQuality Enumeration
Protect Workbook
Radar Chart
Range Operations
Range.Conversions Class
Members
Methods
Overview
Range.Operators Class
Members
Methods
Overview
Range.StringConversion Enumeration
Range.Strings Class
Members
Methods
Overview
Range.WildcardMatcher Class
Members
Methods
Overview
RangeEventArgs Class
Fields
Members
Methods
Overview
ReadingOrder Enumeration
Rectangle Class
Members
Methods
Overview
Redistribution
ReferenceStyle Enumeration
Remove a Group
Render Excel Range Inside PDF
RepeatInfo Class
Fields
Members
Overview
RepeatSetting Class
Members
Methods
Overview
ReplaceOptions Class
Members
Methods
Overview
Rich Text
RowCol Enumeration
RowPageContentInfo Class
Fields
Members
Methods
Overview
RowPageInfo Class
Fields
Members
Overview
Save Multiple Workbooks to Single PDF
SaveFileFormat Enumeration
SaveOptionsBase Class
Members
Methods
Overview
ScaleType Enumeration
SearchDirection Enumeration
SearchOrder Enumeration
Series
Set Array Formula
Set Formula to Range
Set Rich Text in a Cell
Set Row Height and Column Width
Set Sheet Styling
Set Summary Row
Set Table Filters
Set Table Formula
Set Values to a Range
Shape Adjustment
Shape and Picture
ShapeRange Class
Members
Methods
Overview
ShapeShellWrapper Class
Members
Methods
Overview
ShapeTextBoxDivFont Class
Members
Methods
Overview
ShapeType Enumeration
SheetEventArgs Class
Fields
Members
Methods
Overview
SheetType Enumeration
Shrink To Fit With Text Wrap
ShrinkToFitSettings Class
Members
Methods
Overview
Size Class
Members
Methods
Overview
SizeRepresents Enumeration
Slicer
SlicerSortOrder Enumeration
SolidColorType Enumeration
SortDataOption Enumeration
SortFieldBase Class
Members
Methods
Overview
SortOnType Enumeration
SortOrder Enumeration
SortOrientation Enumeration
Sparkline
SparklineRowCol Enumeration
SparkScale Enumeration
SparkType Enumeration
Specialized Chart
ST_PhoneticAlignment Enumeration
ST_PhoneticType Enumeration
Statistical Chart
Stock Chart
Style
SubtotalLocationType Enumeration
SubtotalType Enumeration
SummaryColumn Enumeration
SummaryRow Enumeration
Sunburst
Support Document Properties
Support Security Options
Support Sheet Background Image
Surface Chart
Table
TableStyleElementType Enumeration
TableStyleFactory Class
Members
Methods
Overview
Tags
Technical Support
Template
Template Layout
Templates
TextRangeType Enumeration
TextUnderlineType Enumeration
TextureAlignment Enumeration
TextureType Enumeration
Theme
Theme Class
Members
Methods
Overview
ThemeColor Enumeration
ThemeFont Enumeration
Themes Class
Members
Methods
Overview
TickLabelOrientation Enumeration
TickLabelPosition Enumeration
TickMark Enumeration
TimePeriods Enumeration
TimeUnit Enumeration
TopBottom Enumeration
TotalsCalculation Enumeration
Treemap
TrendlineType Enumeration
UnderlineType Enumeration
Use Chart
Use Do Filter Operation
Use Pivot Table
Use Slicer
Use Sparkline
Use Table
Use Tags
UsedRangeType Enumeration
ValidationAlertStyle Enumeration
ValidationOperator Enumeration
ValidationType Enumeration
ValueQuoteType Enumeration
ValueSortField Class
Members
Methods
Overview
VerticalAlignment Enumeration
Visibility Enumeration
Walls
Waterfall Chart
Work with Cell Types
Work with Chart Types
Work With Custom Functions
Work with Quote Prefix
Work with Shape And Picture
Work with Used Range
Work with Workbook Views
Work with Worksheet Views
Work with Worksheets
Workbook Class
Fields
Members
Methods
Overview
WorkbookCache Class
Members
Methods
Overview
WorkbookDataStorage<T> Class
Members
Methods
Overview
Working With Page Setup
WorksheetCache Class
Members
Methods
Overview
WorksheetCacheCollection Class
Members
Methods
Overview
WorksheetDataManager<T> Class
Fields
Members
Methods
Overview
XlsxOpenOptions Class
Members
Methods
Overview
XlsxSaveOptions Class
Members
Methods
Overview
XY (Scatter) chart