Spire.XLS API

Spire.XLS namespace

AlertStyleType Enumeration

AutoFormatOptions Enumeration

AutoFormatType Enumeration

AverageType Enumeration

AxisLineIdentifierType Enumeration

AxisTextDirectionType Enumeration

AxisType Enumeration

AxisTypes Enumeration

BaseFormatType Enumeration

BookmarkHyperlink Class

BordersLineType Enumeration

BubbleSizeType Enumeration

BuiltInPropertyType Enumeration

BuiltInStyles Enumeration

CategoryType Enumeration

CellBorder Class

CellDataType Enumeration

CellFormatType Enumeration

CellRange Class

CellStyle Class

CellStyleFlag Class

CellStyleObject Class

ChartBackgroundMode Enumeration

ChartBaseUnitType Enumeration

ChartDisplayUnitType Enumeration

ChartExPositionAlignment Enumeration

ChartExSidePosition Enumeration

ChartLinePatternType Enumeration

ChartLineWeightType Enumeration

ChartMarkerType Enumeration

ChartParagraphType Enumeration

ChartPieType Enumeration

ChartPlotEmptyType Enumeration

ChartShadow Class

ChartSheet Class

ChartStyleElements Enumeration

CheckState Enumeration

ColorModel Enumeration

ColorScale Class

ColorType Enumeration

CommentHAlignType Enumeration

CommentVAlignType Enumeration

ComparisonOperatorType Enumeration

CompoundLineType Enumeration

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatScope Enumeration

ConditionalFormatType Enumeration

ConditionalFormatWrapper Class

ConditionalTopNType Enumeration

ConditionValue Class

ConditionValuePosition Enumeration

ConditionValueType Enumeration

ConnectionDataSourceType Enumeration

ConverterSetting Class

CopyRangeOptions Enumeration

CustomFontData Class

DataLabelPositionType Enumeration

DataSourceType Enumeration

DBConnection Class

DeleteOption Enumeration

DocumentProperty Class

DropLineStyleType Enumeration

EndLineCap Enumeration

ErrorBarIncludeType Enumeration

ErrorBarType Enumeration

Excel2007DataLabelPos Enumeration

Excel2016Charttype Enumeration

ExcelAddInFunction Class

ExcelCalculationMode Enumeration

ExcelChartType Enumeration

ExcelClearOptions Enumeration

ExcelColors Enumeration

ExcelComboType Enumeration

ExcelComment Class

ExcelCommentObject Class

ExcelFindOptions Enumeration

ExcelFont Class

ExcelGradient Class

ExcelHorizontalAlignment Enumeration

ExcelInterior Class

ExcelPatternType Enumeration

ExcelPicture Class

ExcelQuartileCalculation Enumeration

ExcelSaveType Enumeration

ExcelShapeType Enumeration

ExcelSheetType Enumeration

ExcelTotalsCalculation Enumeration

ExcelTreeMapLabelOption Enumeration

ExcelVersion Enumeration

ExcelVerticalAlignment Enumeration

ExpandCollapseFlags Enumeration

ExportTableOptions Class

ExternalConnection Class

ExternalLink Class

FileFormat Enumeration

FilterConditionType Enumeration

FilterDataType Enumeration

FindType Enumeration

FontCollectionIndex Enumeration

FontUnderlineType Enumeration

FontVertialAlignmentType Enumeration

GoalSeekResult Class

GradientColorType Enumeration

GradientPatternType Enumeration

GradientPresetType Enumeration

GradientStyleType Enumeration

GradientTextureType Enumeration

GradientVariantsType Enumeration

GroupByType Enumeration

HorizontalAlignType Enumeration

HPageBreak Class

HttpContentType Enumeration

HyperLink Class

HyperLinkType Enumeration

IConditionValue Interface

IconSetType Enumeration

IgnoreErrorType Enumeration

ImageFormatType Enumeration

ImageType Enumeration

ImportObjectOptions Class

InsertMoveOption Enumeration

InsertOptionsType Enumeration

IPropertyData Interface

LegendPositionType Enumeration

LegendSpacingType Enumeration

LineShapeType Enumeration

LineStyleType Enumeration

MarkerDesigner Class

MeasureUnits Enumeration

MsoPathType Enumeration

OdsPageBackground Class

OdsPageBackgroundImagePositionType Enumeration

OdsPageBackgroundImageType Enumeration

OdsPageBackgroundType Enumeration

OLEDBCommandType Enumeration

OleLinkType Enumeration

OleObjectType Enumeration

OrderBy Enumeration

OrderType Enumeration

PageBreakExtentType Enumeration

PageBreakType Enumeration

PageColRow Structure

PageImagePaintedEventArgs Class

PageImagePaintedHandler Delegate

PageOrientationType Enumeration

PageSetup Class

PagesOrderType Enumeration

PaperSizeType Enumeration

PathFillMode Enumeration

PivotAutoFomatTypes Enumeration

PivotBuiltInStyles Enumeration

PivotCache Class

PivotDataType Enumeration

PivotField Class

PivotFieldFormatType Enumeration

PivotFieldSortType Enumeration

PivotGroupByTypes Enumeration

PivotItemType Enumeration

PivotLabelFilterType Enumeration

PivotPageAreaFieldsOrderType Enumeration

PivotTable Class

PivotTableElement Enumeration

PivotTableFields Class

PivotTableLayoutType Enumeration

PivotValueFilterType Enumeration

PresetTextEffect Enumeration

PrintCommentType Enumeration

PrintErrorsType Enumeration

PrintingPageType Enumeration

PropertyType Enumeration

PrstGeomShapeType Enumeration

QueryTableXls Class

ReadingOrderType Enumeration

RectangleShapeType Enumeration

RectangleStyleType Enumeration

ReferRangeArea Class

RenameStrategy Enumeration

ResizeBehaveType Enumeration

RichTextObject Class

SaveShapeTypeOption Class

SelectionType Enumeration

ShapeArrowLengthType Enumeration

ShapeArrowStyleType Enumeration

ShapeArrowWidthType Enumeration

ShapeDashLineStyleType Enumeration

ShapeFillType Enumeration

ShapeGlow Class

ShapeLayerChangeType Enumeration

ShapeLineStyleType Enumeration

ShapeReflection Class

SheetProtectionType Enumeration

SlicerCacheCrossFilterType Enumeration

SortComparsionType Enumeration

SortedWayType Enumeration

SortOrientationType Enumeration

Sparkline Class

SparklineCollection Class

SparklineEmptyCells Enumeration

SparklineGroup Class

SparklineGroupCollection Class

SparklineType Enumeration

SpartlineVerticalAxisType Enumeration

SplitType Enumeration

StyleEntryModifierEnum Enumeration

SubtotalTypes Enumeration

TableBuiltInStyles Enumeration

TextDirection Enumeration

TextRotationType Enumeration

TextSaveOptions Class

TextVerticalValue Enumeration

ThemeColorType Enumeration

TickLabelPositionType Enumeration

TickMarkType Enumeration

TopBottomType Enumeration

TopFormatType Enumeration

TrendLineType Enumeration

UnknownVariableAction Enumeration

Validation Class

ValidationComparisonOperator Enumeration

VariableTypeAction Enumeration

VerticalAlignType Enumeration

ViewMode Enumeration

VPageBreak Class

WebQueryConnection Class

Worksheet Class

WorksheetCopyType Enumeration

WorksheetVisibility Enumeration

XlsConditionValue Class

XlsDocumentProperty Class

XlsSlicer Class

XlsSlicerCache Class

XlsSlicerCacheItem Class

XlsSlicerCacheItemCollection Class

XlsSlicerCollection Class

XLSXBorderJoinType Enumeration

XLSXChartBevelType Enumeration

XLSXChartLightingType Enumeration

XLSXChartMaterialType Enumeration

XLSXChartPrespectiveType Enumeration

XLSXChartShadowInnerType Enumeration

XLSXChartShadowOuterType Enumeration

XLSXPivotItemType Enumeration

XmlOpenType Enumeration

Click or drag to resize

GradientPatternType Enumeration

Represents excel gradient pattern.

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public enum GradientPatternType

Public Enumeration GradientPatternType

public enum class GradientPatternType

type GradientPatternType

Members

	Member name	Value	Description
	Pat5Percent	1	Represents 5% gradient pattern
	Pat10Percent	2	Represents 10% gradient pattern
	Pat20Percent	3	Represents 20% gradient pattern
	Pat25Percent	4	Represents 25% gradient pattern
	Pat30Percent	5	Represents 30% gradient pattern
	Pat40Percent	6	Represents 40% gradient pattern
	Pat50Percent	7	Represents 50% gradient pattern
	Pat60Percent	8	Represents 60% gradient pattern
	Pat70Percent	9	Represents 70% gradient pattern
	Pat75Percent	10	Represents 75% gradient pattern
	Pat80Percent	11	Represents 80% gradient pattern
	Pat90Percent	12	Represents 90% gradient pattern
	PatDarkDownwardDiagonal	15	Represents Dark Downward Diagonal gradient pattern
	PatDarkHorizontal	13	Represents Dark Horizontal gradient pattern
	PatDarkUpwardDiagonal	16	Represents Dark Upward Diagonal gradient pattern
	PatDarkVertical	14	Represents Dark Vertical gradient pattern
	PatDashedDownwardDiagonal	28	Represents Dashed Downward Diagonal gradient pattern
	PatDashedHorizontal	32	Represents Dashed Horizontal gradient pattern
	PatDashedUpwardDiagonal	27	Represents Dashed Upward Diagonal gradient pattern
	PatDashedVertical	31	Represents Dashed Vertical gradient pattern
	PatDiagonalBrick	40	Represents Diagonal Brick gradient pattern
	PatDivot	46	Represents Divot gradient pattern
	PatDottedDiamond	24	Represents Dotted Diamond gradient pattern
	PatDottedGrid	45	Represents Dotted Grid gradient pattern
	PatHorizontalBrick	35	Represents Horizontal Brick gradient pattern
	PatLargeCheckerBoard	36	Represents Large Checker Board gradient pattern
	PatLargeConfetti	33	Represents Large Confetti gradient pattern
	PatLargeGrid	34	Represents Large Grid gradient pattern
	PatLightDownwardDiagonal	21	Represents Light Downward Diagonal gradient pattern
	PatLightHorizontal	19	Represents Light Horizontal gradient pattern
	PatLightUpwardDiagonal	22	Represents Light Upward Diagonal gradient pattern
	PatLightVertical	20	Represents Light Vertical gradient pattern
	PatMixed	-2	Represents Mixed gradient pattern
	PatNarrowHorizontal	30	Represents Narrow Horizontal gradient pattern
	PatNarrowVertical	29	Represents Narrow Vertical gradient pattern
	PatOutlinedDiamond	41	Represents Outlined Diamond gradient pattern
	PatPlaid	42	Represents Plaid gradient pattern
	PatShingle	47	Represents Shingle gradient pattern
	PatSmallCheckerBoard	17	Represents Small Checker Board gradient pattern
	PatSmallConfetti	37	Represents Small Confetti gradient pattern
	PatSmallGrid	23	Represents Small Grid gradient pattern
	PatSolidDiamond	39	Represents Solid Diamond gradient pattern
	PatSphere	43	Represents Sphere gradient pattern
	PatTrellis	18	Represents Trellis gradient pattern
	PatWave	48	Represents Wave gradient pattern
	PatWeave	44	Represents Weave gradient pattern
	PatWideDownwardDiagonal	25	Represents Wide Downward Diagonal gradient pattern
	PatWideUpwardDiagonal	26	Represents Wide Upward Diagonal gradient pattern
	PatZigZag	38	Represents Zig Zag gradient pattern

See Also

Reference

Spire.Xls Namespace