Documents for Excel, .NET 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
API Reference
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
AutoFilterOperator Enumeration
AutoShapeType Enumeration
Axis and Other Lines
AxisCrosses Enumeration
AxisGroup Enumeration
AxisType Enumeration
Bar Chart
BarShape Enumeration
BaseCellType Class
Members
Overview
BinsType Enumeration
BorderLineStyle Enumeration
BordersIndex Enumeration
Box Whisker
ButtonCellType Class
Members
Overview
CalcError Enumeration
CalcReference Class
Members
Overview
CategoryType Enumeration
Cell Context
Cell Expansion
Cell Rules
CellColorSortField Class
Members
Overview
CellInfo Class
Members
Overview
Chart
Chart Area
Chart Sheet
Chart Title
ChartSplitType Enumeration
ChartType Enumeration
CheckBoxAlign Enumeration
CheckBoxCellType Class
Members
Overview
ColorDataIndex Enumeration
ColorScaleType Enumeration
Column Chart
Combo Chart
ComboBoxCellItem Class
Members
Overview
ComboBoxCellType Class
Members
Overview
Comments
Conditional Format
ConditionValueTypes Enumeration
Configure Chart
Configure Chart Axis
Configure Chart Series
Configure Columns to Repeat at Left and Right
Configure Fonts and Set Style
Configure Page Breaks
Configure Page Header and Footer
Configure Page Settings
Configure Paper Settings
Configure Print Area
Configure Print Settings via Page Setup
Configure Rows to Repeat at Top and Bottom
Configure Sheet Print Settings
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
Overview
CsvSaveOptions Class
Members
Overview
CustomFunction Class
Members
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
Data Label
Data Source Binding
Data Validation
DataBarAxisPosition Enumeration
DataBarBorderType Enumeration
DataBarDirection Enumeration
DataBarFillType Enumeration
DataBarNegativeColorType Enumeration
DataLabelPosition Enumeration
DateTimeConverter Class
Members
Overview
Delete Blank Pages From Middle
Delete Validation
DeleteShiftDirection Enumeration
Direction Enumeration
DisplayBlanksAs Enumeration
DisplayUnit Enumeration
DocumentProperties Class
Members
Overview
DrawingPictureType Enumeration
DupeUnique Enumeration
DynamicFilterType Enumeration
EditorValueType Enumeration
Enable or Disable Calculation Engine
End User License Agreement
EndStyleCap Enumeration
Export Charts
Export Custom Page Information
Export Different Headers On Different Pages
Export Last Page Without Headers
Export Multiple Sheets To One Page
Export Pivot Table Styles And Format
Export Shapes
Export Slicers
Export Specific Pages To PDF
Export to a PDF File
Export Vertical Text
Features
FillType Enumeration
Find and Replace Data
FindLookIn Enumeration
FindOptions Class
Members
Overview
Floor
FontColorSortField Class
Members
Overview
FontInfo Structure
FontLanguageIndex Enumeration
FormatConditionOperator Enumeration
FormatConditionType Enumeration
Formula
Formula Functions
Freeze Panes in a Worksheet
FunctionValueType Enumeration
Funnel
GcExcel .NET Overview
Get Range and Range Area
Get Row and Column Count
Get Started
GradientFillType Enumeration
GradientStyle Enumeration
GrapeCity.Documents.Excel Assembly
Overview
GrapeCity.Documents.Excel Namespace
Overview
GrapeCity.Documents.Excel.Drawing Namespace
Overview
GraphicColorType Enumeration
Group
Group or Ungroup Shapes
Hide Rows and Columns
Histogram
HorizontalAlignment Enumeration
Hyperlink on Shape
HyperLinkCellType Class
Members
Overview
Hyperlinks
HyperLinkTargetType Enumeration
IAboveAverage Interface
IAdjustments Interface
IAreas Interface
IAutoFilter Interface
IAxes Interface
IAxis Interface
IAxisTitle Interface
IBorder Interface
IBorders Interface
ICalcContext Interface
ICellCollection Interface
ICellColorSortField 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
IConditionValue Interface
IConnectorFormat Interface
IconSetType Enumeration
IconSortField Class
Members
Overview
IContainer Interface
IconType Enumeration
ICrop Interface
IDataBar Interface
IDataBarBorder Interface
IDataLabel Interface
IDataLabels Interface
IDisplayFormat Interface
IDisplayUnitLabel Interface
IFillFormat Interface
IFilter Interface
IFilters Interface
IFloor Interface
IFont Interface
IFontColorSortField Interface
IFontFormat Interface
IFormatColor Interface
IFormatCondition Interface
IFormatConditions Interface
IFormulaResolver Interface
IGradientStop Interface
IGradientStops Interface
IGraphic Interface
IGridlines Interface
IGroupShapes 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
IJsonSerializer Interface
ILegend Interface
ILegendEntries Interface
ILegendEntry Interface
ILinearGradient Interface
ILineFormat Interface
ImageType Enumeration
IMEModeType Enumeration
Import and Export .xlsx Document
Import and Export CSV File
Import and Export CSV File with Delimiters
Import and Export JSON Stream
Import and Export Macros
Import and Export OLE Objects
ImportFlags Enumeration
IName Interface
INames Interface
INegativeBarFormat Interface
Insert And Delete Cell Ranges
Insert and Delete Rows and Columns
InsertShiftDirection Enumeration
InvalidFormulaException Class
Members
Overview
IOutline Interface
IPage Interface
IPageSetup Interface
IPane Interface
IPanes Interface
IPictureFormat Interface
IPivotCache Interface
IPivotCaches Interface
IPivotField Interface
IPivotFields Interface
IPivotItem Interface
IPivotItems Interface
IPivotTable Interface
IPivotTables Interface
IPlotArea Interface
IPoint Interface
IPoints Interface
IProtectionSettings Interface
IRange Interface
IRangeProvider Interface
IRectangularGradient Interface
IRichText Interface
ISeries Interface
ISeriesCollection Interface
IShape Interface
IShapeRange Interface
IShapeRangeProvider Interface
IShapes Interface
IShrinkToFitSettings 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
ISparkPoints Interface
ISparkVerticalAxis Interface
IStyle Interface
IStyleCollection Interface
ITable Interface
ITableColumn Interface
ITableColumns Interface
ITableRow Interface
ITableRows Interface
ITables Interface
ITableStyle Interface
ITableStyleCollection Interface
ITableStyleElement Interface
ITableStyleElements Interface
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
IWorkbook Interface
IWorkbookView Interface
IWorksheet Interface
IWorksheets Interface
IWorksheetView Interface
JsonContentType Enumeration
JsonOptions Class
Members
Overview
Keep Rows Together Over Page Breaks
Key Features
LayoutRowType Enumeration
LegendPosition Enumeration
Legends
License Information
LicenseManager Class
Members
Overview
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
NumberFormatParseException Class
Members
Overview
Open and Save Workbook
OpenFileFormat Enumeration
OpenOptions Class
Members
Overview
OpenOptionsBase Class
Members
Overview
Order Enumeration
Page Setup
PageBreakExtent Enumeration
PageContentInfo Class
Members
Overview
PageInfo Class
Members
Overview
PageOrientation Enumeration
PageSettings Class
Members
Overview
PageType Enumeration
PaperSize Enumeration
Parameter Class
Members
Overview
ParentDataLabelOptions Enumeration
Pareto Chart
PasteType Enumeration
Pattern Enumeration
PatternType Enumeration
PDF Export
PdfSaveOptions Class
Members
Overview
PdfSecurityOptions Class
Members
Overview
PictureColorType Enumeration
Pie Chart
Pivot Table Settings
PivotFieldOrientation Enumeration
Placement Enumeration
Plot Area
Precedents and Dependents
PresetCamera Enumeration
PresetGradientType Enumeration
PresetTexture Enumeration
PresetThreeDFormat Enumeration
PrintErrors Enumeration
PrintLocation Enumeration
PrintManager Class
Members
Overview
PrintQuality Enumeration
Protect Workbook
Radar Chart
Range Operations
RangeEventArgs Class
Members
Overview
ReadingOrder Enumeration
Redistribution
ReferenceStyle Enumeration
Remove a Group
Render Excel Range Inside PDF
RepeatSetting Class
Members
Overview
ReplaceOptions Class
Members
Overview
Rich Text
RowCol Enumeration
Save Multiple Workbooks to Single PDF
SaveFileFormat Enumeration
SaveOptions Class
Members
Overview
SaveOptionsBase Class
Members
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
ShapeType Enumeration
SheetEventArgs Class
Members
Overview
SheetType Enumeration
Shrink To Fit With Text Wrap
SizeRepresents Enumeration
Slicer
SlicerSortOrder Enumeration
SolidColorType Enumeration
SortDataOption Enumeration
SortFieldBase Class
Members
Overview
SortOnType Enumeration
SortOrder Enumeration
SortOrientation Enumeration
Sparkline
SparklineRowCol Enumeration
SparkScale Enumeration
SparkType Enumeration
Specialized Chart
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
Tags
Technical Support
Template
Template Layout
Templates
TextRangeType Enumeration
TextUnderlineType Enumeration
TextureAlignment Enumeration
TextureType Enumeration
Theme
Theme Class
Members
Overview
ThemeColor Enumeration
ThemeFont Enumeration
Themes Class
Members
Overview
TickLabelOrientation Enumeration
TickLabelPosition Enumeration
TickMark Enumeration
TimePeriods Enumeration
TimeUnit Enumeration
TopBottom Enumeration
TotalsCalculation Enumeration
TreeMap
TrendlineType Enumeration
UnderlineType Enumeration
Upgrade to Latest Version
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
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
Members
Overview
Working With Page Setup
XlsxOpenOptions Class
Members
Overview
XlsxSaveOptions Class
Members
Overview
XY (Scatter) Chart