Document Solutions for Excel, Java Edition | Document Solutions
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
Members
Methods
Overview
ArrowheadLength Enumeration
ArrowheadStyle Enumeration
ArrowheadWidth Enumeration
AsyncCustomFunction Class
Fields
Members
Methods
Overview
Asynchronous Functions
Auto Fit Row Height and Column Width
Auto Merge Cells
Auto-Filter Table with Slicer
AutoFilterOperator Enumeration
AutoMergeDirection Enumeration
AutoMergeMode Enumeration
AutoMergeSelectionMode 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
Members
Overview
BinsType Enumeration
BorderLineStyle Enumeration
BordersIndex Enumeration
Box Whisker
Breaking Changes
ButtonCellType Class
Members
Methods
Overview
CalcError Enumeration
CalcReference Class
Members
Methods
Overview
Calculation Mode
CalculationMode Enumeration
CancellationToken Class
Members
Methods
Overview
CancellationTokenSource Class
Members
Methods
Overview
CategoryType Enumeration
Cell Context
Cell Expansion
Cell Types
Cell Value Rule
CellColorSortField Class
Members
Methods
Overview
CellDecoration Class
Members
Methods
Overview
CellDecorationIcon Class
Members
Methods
Overview
CellInfo Class
Members
Methods
Overview
CellPadding Class
Members
Methods
Overview
CellTypeDirection Enumeration
CellTypeTextAlign Enumeration
Chart
Chart Area
Chart Sheet
Chart Title
Chart Types
Charts
ChartSplitType Enumeration
ChartType Enumeration
CheckBoxAlign Enumeration
CheckBoxCellType Class
Members
Methods
Overview
CheckBoxListCellType Class
Members
Methods
Overview
Codabar
Code128
Code39
Code49
Code93
Color Class
Members
Methods
Overview
Color Scale Rule
ColorDataIndex Enumeration
ColorScaleType Enumeration
ColorUtilities Class
Members
Methods
Overview
Column Chart
com.grapecity.documents.excel Package
Inheritance Hierarchy
Overview
com.grapecity.documents.excel.drawing Package
Inheritance Hierarchy
Overview
com.grapecity.documents.excel.expressions Package
Inheritance Hierarchy
Overview
com.grapecity.documents.excel.forms Package
Inheritance Hierarchy
Overview
Combo Chart
ComboBoxCellItem Class
Members
Methods
Overview
ComboBoxCellType Class
Members
Methods
Overview
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
Members
Methods
Overview
Contacting Sales
ContainsOperator Enumeration
Control Pagination
Control Position of Overlapping Shapes
Convert Table to Range
Convert to Image
CornerFold Class
Members
Methods
Overview
CornerPosition Enumeration
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
Members
Methods
Overview
CsvParseContext Class
Members
Methods
Overview
CsvParseResult Class
Members
Methods
Overview
CsvSaveOptions Class
Members
Methods
Overview
Custom Form Input Types
Custom Functions
CustomBorderStyle Class
Members
Methods
Overview
CustomFunction Class
Fields
Members
Methods
Overview
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
DataImportOptions Class
Members
Methods
Overview
DataImportResult Class
Members
Methods
Overview
DataLabelPosition Enumeration
DataValidationJsonError Class
Members
Methods
Overview
Date and Time Format for a Culture
Date and Time Format for a Culture
Date Occurring Rule
DateInfo Class
Members
Methods
Overview
Default Values in Template Cells
Defined Names
Delete Blank Pages From Middle
Delete Validation
DeleteShiftDirection Enumeration
DeserializationOptions Class
Members
Methods
Overview
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
Members
Methods
Overview
Documents.for.Excel.Java.Edition.Packages Project
Overview
DrawingPictureType Enumeration
DropDownItem Class
Members
Methods
Overview
DsExcel Dependencies
DupeUnique Enumeration
Duplicate Slicer
Dynamic Array Formulas
DynamicFilterType Enumeration
EAN-13
EAN-8
EccMode Enumeration
EditorValueType Enumeration
EmptyNode Class
Members
Methods
Overview
Enable or Disable Calculation Engine
End User License Agreement
EndStyleCap Enumeration
Error Bars
ErrorBarDirection Enumeration
ErrorBarInclude Enumeration
ErrorBarType Enumeration
ErrorCorrectionLevel Enumeration
ErrorNode Class
Members
Methods
Overview
Event<T> Class
Members
Methods
Overview
EventArgs Class
Fields
Members
Overview
EventHandler<T> Interface
Members
Overview
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
Members
Methods
Overview
Fixed Layout
Floor
FontColorSortField Class
Members
Methods
Overview
FontInfo Class
Fields
Members
Methods
Overview
FontLanguageIndex Enumeration
Form Controls
FormatConditionOperator Enumeration
FormatConditionType Enumeration
FormControlOrientation Enumeration
FormControlType Enumeration
FormFieldSubmitFormatType Enumeration
Formula Functions
Formula Parser
FormulaJsonError Class
Members
Methods
Overview
Formulas
FormulaSyntaxTree Class
Members
Methods
Overview
Freeze Panes in a Worksheet
Freeze Trailing Panes in a Worksheet
FunctionNode Class
Members
Methods
Overview
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
Members
Methods
Overview
Hyperlink on Shape
HyperLinkCellType Class
Members
Methods
Overview
Hyperlinks
HyperLinkTargetType Enumeration
IAboveAverage Interface
Members
Methods
Overview
IAdjustments Interface
Members
Methods
Overview
IAreas Interface
Members
Methods
Overview
IAuthor Interface
Members
Methods
Overview
IAutoCorrect Interface
Members
Methods
Overview
IAutoFilter Interface
Members
Methods
Overview
IAutoMergeRangeInfo Interface
Members
Methods
Overview
IAxes Interface
Members
Methods
Overview
IAxis Interface
Members
Methods
Overview
IAxisTitle Interface
Members
Overview
IBackgroundPicture Interface
Members
Methods
Overview
IBackgroundPictures Interface
Members
Methods
Overview
IBarcode Interface
Members
Methods
Overview
IBorder Interface
Members
Methods
Overview
IBorders Interface
Members
Methods
Overview
IBuiltInDocumentPropertyCollection Interface
Members
Methods
Overview
IButton Interface
Members
Methods
Overview
ICalcContext Interface
Members
Methods
Overview
ICalculatedFields Interface
Members
Methods
Overview
ICalculatedItems Interface
Members
Methods
Overview
ICascadeSparkLine Interface
Members
Methods
Overview
ICellCollection Interface
Members
Methods
Overview
ICellColorSortField Interface
Members
Methods
Overview
ICellDecoration Interface
Members
Methods
Overview
ICellDecorationIcon Interface
Members
Methods
Overview
ICellLinkControl Interface
Members
Methods
Overview
ICellLinkControlT<T> Interface
Members
Methods
Overview
ICellPadding 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
ICheckBox Interface
Members
Methods
Overview
ICodabar Interface
Members
Methods
Overview
ICode128 Interface
Members
Methods
Overview
ICode39 Interface
Members
Methods
Overview
ICode49 Interface
Members
Methods
Overview
ICode93 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
IComments Interface
Members
Methods
Overview
ICommentsThreaded Interface
Members
Methods
Overview
ICommentThreaded Interface
Members
Methods
Overview
Icon Sets Rule
IConditionValue Interface
Members
Methods
Overview
IConnectorFormat Interface
Members
Methods
Overview
IconPosition Enumeration
IconSetType Enumeration
IconSortField Class
Members
Methods
Overview
IContainer Interface
Members
Methods
Overview
IContentControl Interface
Members
Methods
Overview
IControl Interface
Members
Methods
Overview
IControlCollection Interface
Members
Methods
Overview
IControlT<T> Interface
Members
Methods
Overview
IconType Enumeration
ICornerFold Interface
Members
Methods
Overview
ICrop Interface
Members
Methods
Overview
ICsvParser Interface
Members
Methods
Overview
ICustomDocumentPropertyCollection Interface
Members
Methods
Overview
ICustomView Interface
Members
Methods
Overview
ICustomViews Interface
Members
Methods
Overview
IDataBar Interface
Members
Methods
Overview
IDataBarBorder Interface
Members
Methods
Overview
IDataLabel Interface
Members
Methods
Overview
IDataLabels Interface
Members
Methods
Overview
IDataMatrix Interface
Members
Methods
Overview
IDataOptions Interface
Members
Methods
Overview
IDataTable Interface
Members
Methods
Overview
IDisplayFormat Interface
Members
Methods
Overview
IDisplayUnitLabel Interface
Members
Methods
Overview
IDocumentProperty Interface
Members
Methods
Overview
IDocumentPropertyCollection Interface
Members
Methods
Overview
IDropDown Interface
Members
Methods
Overview
IDropDownItemList Interface
Members
Overview
IEAN13 Interface
Members
Methods
Overview
IEAN8 Interface
Members
Overview
IErrorBar Interface
Members
Methods
Overview
IExcelOptions 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
IFontOption Interface
Members
Methods
Overview
IFontProvider Interface
Members
Methods
Overview
IFormatColor Interface
Members
Methods
Overview
IFormatCondition Interface
Members
Methods
Overview
IFormatConditions Interface
Members
Methods
Overview
IFormulaOptions Interface
Members
Methods
Overview
IFormulaResolver Interface
Members
Methods
Overview
Ignore Errors in Cell Range
IgnoredErrorType Enumeration
IGradientStop Interface
Members
Methods
Overview
IGradientStops Interface
Members
Methods
Overview
IGraphic Interface
Members
Methods
Overview
IGraphicsInfo Interface
Members
Methods
Overview
IGridlines Interface
Members
Methods
Overview
IGroupBox Interface
Members
Methods
Overview
IGroupInfo Interface
Members
Methods
Overview
IGroupShapes Interface
Members
Methods
Overview
IGS1128 Interface
Members
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
IItemCollection<T> Interface
Members
Methods
Overview
IItemList<T> Interface
Members
Methods
Overview
IJsonSerializer Interface
Members
Methods
Overview
ILabel Interface
Members
Overview
ILabelOption Interface
Members
Methods
Overview
ILabelOptions 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
IListBox Interface
Members
Methods
Overview
IListBoxItemCollection Interface
Members
Overview
IListBoxItemList Interface
Members
Overview
Image Transparency
ImageLayout Enumeration
ImageSaveOptions Class
Members
Methods
Overview
ImageSource Class
Members
Methods
Overview
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
Import Data
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
InsertShiftDirection Enumeration
InsufficientSpaceHandling Enumeration
InvalidFormulaException Class
Members
Overview
IOptionButton Interface
Members
Methods
Overview
IOutline Interface
Members
Methods
Overview
IOutlineColumn Interface
Members
Methods
Overview
IPage Interface
Members
Methods
Overview
IPageSetup Interface
Members
Methods
Overview
IPane Interface
Members
Methods
Overview
IPanes Interface
Members
Methods
Overview
IPDF417 Interface
Members
Methods
Overview
IPDFRenderEngine Interface
Members
Methods
Overview
IPictureFormat Interface
Members
Methods
Overview
IPivotAxis Interface
Members
Methods
Overview
IPivotCache Interface
Members
Methods
Overview
IPivotCaches Interface
Members
Methods
Overview
IPivotCell Interface
Members
Methods
Overview
IPivotField Interface
Members
Methods
Overview
IPivotFields Interface
Members
Methods
Overview
IPivotFilter Interface
Members
Methods
Overview
IPivotFilters Interface
Members
Methods
Overview
IPivotFormula Interface
Members
Methods
Overview
IPivotFormulas Interface
Members
Methods
Overview
IPivotItem Interface
Members
Methods
Overview
IPivotItemList Interface
Members
Methods
Overview
IPivotItems Interface
Members
Methods
Overview
IPivotLine Interface
Members
Methods
Overview
IPivotLineCells Interface
Members
Methods
Overview
IPivotLines Interface
Members
Methods
Overview
IPivotOptions Interface
Members
Methods
Overview
IPivotTable Interface
Members
Methods
Overview
IPivotTables Interface
Members
Methods
Overview
IPivotValueCell Interface
Members
Methods
Overview
IPlotArea Interface
Members
Methods
Overview
IPoint Interface
Members
Methods
Overview
IPoints Interface
Members
Methods
Overview
IProtectionSettings Interface
Members
Methods
Overview
IQRCode Interface
Members
Methods
Overview
IRange Interface
Members
Methods
Overview
IRangeBase Interface
Members
Methods
Overview
IRangeProvider Interface
Members
Methods
Overview
IReadOnlySignatureDetails Interface
Members
Methods
Overview
IRectangularGradient Interface
Members
Methods
Overview
IRichText Interface
Members
Methods
Overview
IScenario Interface
Members
Methods
Overview
IScenarios Interface
Members
Methods
Overview
IScrollBar Interface
Members
Methods
Overview
ISelector Interface
Members
Methods
Overview
ISelectorT<T,TCollection> 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
ISignature Interface
Members
Methods
Overview
ISignatureSet Interface
Members
Methods
Overview
ISignatureSetup Interface
Members
Methods
Overview
ISlicer Interface
Members
Methods
Overview
ISlicerCache Interface
Members
Methods
Overview
ISlicerCaches 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
ISparkLineObject Interface
Members
Methods
Overview
ISparkPoints Interface
Members
Methods
Overview
ISparkVerticalAxis Interface
Members
Methods
Overview
ISpinner Interface
Members
Overview
IStyle Interface
Members
Methods
Overview
IStyleCollection Interface
Members
Methods
Overview
ITable Interface
Members
Methods
Overview
ITableColumn Interface
Members
Methods
Overview
ITableColumns Interface
Members
Methods
Overview
ITableDataSource 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
Iterative Calculation
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
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
IValueSortField Interface
Members
Methods
Overview
IVPageBreak Interface
Members
Methods
Overview
IVPageBreaks Interface
Members
Methods
Overview
IWall Interface
Members
Methods
Overview
IWebRequestHandler Interface
Members
Methods
Overview
IWorkbook Interface
Members
Methods
Overview
IWorkbookView Interface
Members
Methods
Overview
IWorksheet Interface
Members
Methods
Overview
IWorksheets Interface
Members
Methods
Overview
IWorksheetView Interface
Members
Methods
Overview
Java API Documentation
JsonError Class
Members
Methods
Overview
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
Members
Methods
Overview
Localized Formulas
LogicalNode Class
Members
Methods
Overview
LookAt Enumeration
Margin Class
Members
Methods
Overview
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
Members
Methods
Overview
NonTerminalNode Class
Members
Methods
Overview
NumberFormatParseException Class
Members
Overview
NumberNode Class
Members
Methods
Overview
NumbersFitMode Enumeration
Open and Save Workbook
OpenFileFormat Enumeration
OpenOptionsBase Class
Members
Methods
Overview
OperatorKind Enumeration
OperatorNode Class
Members
Methods
Overview
Order Enumeration
Outline Column
Outline Subtotals
PageBreakExtent Enumeration
PageContentInfo Class
Members
Methods
Overview
PageInfo Class
Members
Methods
Overview
PageOrientation Enumeration
PagePrintedEventArgs Class
Fields
Members
Methods
Overview
PagePrintEventArgs Class
Fields
Members
Methods
Overview
PagePrintingEventArgs Class
Fields
Members
Methods
Overview
PageSettings Class
Members
Methods
Overview
Paginated Templates
Pagination Properties and Functions
PaginationOrientation Enumeration
PaperSize Enumeration
Parameter Class
Members
Methods
Overview
ParentDataLabelOptions Enumeration
ParenthesisNode Class
Members
Methods
Overview
Pareto Chart
ParseContext Class
Members
Methods
Overview
Paste or Ignore Data in Hidden Range
PasteOption Class
Members
Methods
Overview
PasteType Enumeration
PathShapeType Enumeration
Pattern Enumeration
PatternType Enumeration
PDF Form Builder
PDF417
PdfSaveOptions Class
Members
Methods
Overview
PdfSecurityOptions Class
Members
Methods
Overview
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
Members
Methods
Overview
PivotFilterType Enumeration
PivotLineType Enumeration
Placement Enumeration
Plot Area
Point Class
Members
Methods
Overview
Precedents and Dependents
PresetCamera Enumeration
PresetGradientType Enumeration
PresetTexture Enumeration
PresetThreeDFormat Enumeration
Print Settings
PrintErrors Enumeration
PrintLocation Enumeration
PrintManager Class
Members
Methods
Overview
PrintQuality Enumeration
PropertyType Enumeration
Protect Cell Range
Protect Workbook
QRCode
Quick Start
Quote Prefix
Radar Chart
RadioButtonListCellType Class
Members
Methods
Overview
Range Operations
Range Template Cell
RangeEventArgs Class
Fields
Members
Methods
Overview
RangeFindReplace Class
Members
Overview
RangeFindReplace.FindReplaceImpl Class
Members
Overview
RangeFindReplace.FindReplaceImpl.FindMatch Interface
Members
Methods
Overview
RangePartialClasses Class
Members
Overview
RangePartialClasses.FindReplaceImpl Class
Members
Overview
RangePartialClasses.FindReplaceImpl.FindMatch Interface
Members
Methods
Overview
RangeTemplateCellType Class
Members
Overview
ReadingOrder Enumeration
Rectangle Class
Members
Methods
Overview
Redistribution
Reference Class
Fields
Members
Methods
Overview
ReferenceNode Class
Members
Methods
Overview
ReferenceStyle Enumeration
Release Notes
Release Notes for Version 2.1.0
Release Notes for Version 2.2.0
Release Notes for Version 3.0.0
Release Notes for Version 3.1.0
Release Notes for Version 3.2.0
Release Notes for Version 4.0.0
Release Notes for Version 4.1.0
Release Notes for Version 4.2.0
Release Notes for Version 5.0.0
Release Notes for Version 5.0.3
Release Notes for Version 5.1.0
Release Notes for Version 5.2.0
Release Notes for Version 6.0.0
Release Notes for Version 6.1.0
Release Notes for Version 6.2.0
Release Notes for Version 7.0.0
Release Notes for Version 7.1.0
Release Notes for Version 7.2.0
Release Notes for Version 8.0.0
Remove a Group
Render Excel Range Inside PDF
RepeatSetting Class
Members
Methods
Overview
ReplaceOptions Class
Members
Methods
Overview
Rich Text
Row or Column Group Information
RowCol Enumeration
Save Multiple Workbooks to Single PDF
SaveFileFormat Enumeration
SaveOptionsBase Class
Members
Methods
Overview
ScaleType Enumeration
Scenarios
SearchDirection Enumeration
SearchOrder Enumeration
SelectFieldItem Class
Members
Methods
Overview
SelectionMode Enumeration
SelectionModeType Enumeration
SelectorItem Class
Members
Methods
Overview
SerializationOptions Class
Members
Methods
Overview
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
Fields
Members
Methods
Overview
SheetType Enumeration
Shrink To Fit With Text Wrap
SignatureDetails Class
Members
Methods
Overview
Size and Position of Image
Size Class
Members
Methods
Overview
SizeRepresents Enumeration
SjsOpenOptions Class
Members
Methods
Overview
SjsSaveOptions Class
Members
Methods
Overview
Slicer
Slicer
Slicer Style
SlicerSortOrder Enumeration
SolidColorType Enumeration
Sort
SortDataOption Enumeration
SortFieldBase Class
Members
Methods
Overview
SortOnType Enumeration
SortOrder Enumeration
SortOrientation Enumeration
Sparkline
SparklineRowCol Enumeration
Sparklines
SparkScale Enumeration
SparkType Enumeration
SpecialCellsValue Class
Fields
Members
Overview
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
Members
Methods
Overview
Table
Table Filters
Table Sort
Table Style
TableItemNode Class
Members
Methods
Overview
TableItemType Class
Fields
Members
Methods
Overview
Tables
TableStyleElementType Enumeration
TableStyleFactory Class
Members
Overview
Tags
Technical Support
Template Configuration
Template Fields
Template Formula Usage
Template Properties
Templates
TerminalNode Class
Members
Methods
Overview
TextAlignmentAnchor Enumeration
TextDirection Enumeration
TextFormatInfo Class
Members
Methods
Overview
TextNode Class
Members
Methods
Overview
TextRangeType Enumeration
TextUnderlineType Enumeration
TextureAlignment Enumeration
TextureType Enumeration
Theme
Theme Class
Members
Methods
Overview
ThemeColor Enumeration
ThemeFont Enumeration
Themes and Colors
Themes Class
Members
Methods
Overview
ThemeStorage Class
Members
Overview
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
Members
Methods
Overview
Use Do Filter Operation
Use JDK 8 Date Time API
UsedRangeType Enumeration
ValidationAlertStyle Enumeration
ValidationOperator Enumeration
ValidationType Enumeration
ValueQuoteType Enumeration
ValueSortField Class
Members
Methods
Overview
VerticalAlignment Enumeration
VerticalAnchor Enumeration
ViewType Enumeration
Visibility Enumeration
Walls
Waterfall Chart
WebRequestResult Class
Members
Methods
Overview
What-If Analysis
Work with Used Range
Work with Worksheets
Workbook
Workbook Class
Fields
Members
Methods
Overview
Workbook Views
WorkbookOptions Class
Members
Methods
Overview
WorkbookReference Class
Fields
Members
Methods
Overview
Working With Page Setup
Worksheet
Worksheet Views
WriteProtection Class
Members
Methods
Overview
XlsmOpenOptions Class
Members
Methods
Overview
XlsmSaveOptions Class
Members
Methods
Overview
XlsxOpenOptions Class
Members
Methods
Overview
XlsxSaveOptions Class
Members
Methods
Overview
XltxOpenOptions Class
Members
Methods
Overview
XltxSaveOptions Class
Members
Methods
Overview
XY (Scatter) chart
ZOrderType Enumeration