Package com.spire.xls

Interface Summary

IConditionValue

Represents single condition value for iconset, databar, colorscale conditions.

Class Summary

CellBorder
CellRange	Represents the cell range.
CellStyle
CellStyleObject
Chart
ChartShadow
ChartSheet
ColorScale	The color scale condition in the conditional format
ConditionalFormat	Contains a condition and the formatting for cells.
ConditionalFormats	Contains a condition and the formatting for cells.
ConditionalFormatWrapper	Summary description for conditional format wrapper.
ConverterSetting	Convert setting
DataBar	Represents a data bar conditional formating rule.
DocumentProperty
ExcelComment
ExcelCommentObject
ExcelFont	Represents the excel font.
ExcelGradient
ExcelInterior	Used to get or set interior settings.
ExcelPicture	Excel picture
Format3D
HPageBreak
HyperLink
IconSet	Conditional formatting icon set condition.
MarkerDesigner	Workbook designerused for template markers to the workbook and worksheet.
OColor	This object used to store, convert colors.
PageColRow	Page col row types in excel.
PageSetup	Represents the page setup description.
PivotCache
PivotField
PivotTable
PivotTableFields
RichText
RichTextObject
Sparkline	A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineCollection	Represents the sparkline collection.
SparklineGroup	Represents a sparkline group.The sparkline group object is a member of the sparkline groups collection.The sparkline groups collection contains all the sparkline group objects in a workheet.
SparklineGroupCollection	The sparkline group collection represents the collection of sparkline group objects.
Validation
VPageBreak	Represents a vertical page break.
Workbook	Represents the workbook object of excel.
Worksheet	Represents the worksheet.

Enum Summary

AlertStyleType	Possible error style values:
AutoFormatOptions	Represents auto format options.
AutoFormatType	Represents auto format values.
AverageType	Average type.
AxisLineIdentifierType	Axis line indentifier type.
AxisTextDirectionType	Represents axis text direction.
AxisType	Primary axis types for charts.
AxisTypes	Axis types.
BaseFormatType	Base format options.
BordersLineType	Specifies border and diagonal line types in excel.
BubbleSizeType	Bubble size.
BuiltInPropertyType	Summary information property type.
BuiltInStyles	Specifies existing built-in styles for excel 2007.
CategoryType	Represents category type.
CellDataType	Cell data types.
CellFormatType	Cell format types.
ChartBackgroundMode	Chart background mode.
ChartBaseUnitType	Represents chart base unit.
ChartDisplayUnitType	Represents excel chart uint to display.
ChartLinePatternType	Chart line patterns.
ChartLineWeightType	Chart line weight values type.
ChartMarkerType	Chart marker types.
ChartParagraphType	MS chart font type
ChartPlotEmptyType	Chart plot empty type.
CheckState	Specifies check state of the check box.
ColorType	Color types.
CommentHAlignType	Comment horizontally align.
CommentVAlignType	Comment vertically align
ComparisonOperatorType	The comparison operator for conditional formatting in excel.
ConditionalFormatType	Conditional formatting type.
ConditionValuePosition	Specifies condition value position.
ConditionValueType	Specifies the types of condition values that can be used.
CopyRangeOptions	Enumeration to specify the options to update formulas and merged ranges during copy range operation.
DataLabelPositionType	Represents data label placement.
DataSourceType	Data source type.
DeleteOption	Delete option
ExcelCalculationMode	Enum that defines different types of the formula calculations.
ExcelChartType	Chart types.
ExcelClearOptions	Enumeration of possible directions to clear the cell formats, content, comments or clear all of them.
ExcelColors	Predefined colors in excel.
ExcelComboType	Represents possible combo box type values.
ExcelFindOptions	Possible type of finding options
ExcelPatternType	Patterns style.
ExcelShapeType	Excel shapes.
ExcelSheetType	Sheet types.
ExcelTotalsCalculation	Specifies the type of calculation in the totals row of a list column.
ExcelVersion	Represents possible excel versions.
ExpandCollapseFlags	Flags for expand/collapse settings.
FileFormat	Represents possible excel versions.
FilterConditionType	Filter conditions.
FilterDataType	Data type for filters.
FindType	Possible types of param, specified as string, number in find first, find all methods.
FontUnderlineType	Font underline types.
FontVertialAlignmentType	Defines the possible settings for vertical alignment of a run of text.
GradientColorType	Represents gradient color type.
GradientPatternType	Represents excel gradient pattern.
GradientPresetType	Represents preset gradient type.
GradientStyleType	Represents excel shape shading style.
GradientTextureType	Represents gradient texture.
GradientVariantsType	Represents shape shading variants.
GroupByType	Enumeration of Group types in Excel.
HorizontalAlignType	Horizontal alignment type.
HyperLinkType	Hyper link type.
IconSetType	Icon set type for conditional formatting.
IgnoreErrorType	Represents flags of excel ignore error indicator.
ImageFormatType	Image formats.
InsertMoveOption	Insert move option
InsertOptionsType	Enumeration of the insert options in excel.
LegendPositionType	Legend placement for charts.
LineShapeType
LineStyleType	Border line styles.
OleLinkType	Defines types of the ole object field.
OleObjectType	Defines the types of ole object
OrderBy	Represents the sort order.
OrderType	Page order for sheet in Excel.
PageBreakExtentType	Page break extent types in excel.
PageBreakType	Page break types in excel.
PageOrientationType	Page orientation types in excel.
PagesOrderType	Page order type
PaperSizeType	Paper size type.
PivotBuiltInStyles	Excel 2007 pivot table built in styles.
PivotFieldFormatType
PivotFieldSortType	Sort orders that can be applied to fields in a PivotTable.
PivotTableElement
PrintCommentType
PrintErrorsType	Print error values.
PrstGeomShapeType
ReadingOrderType	Reading order types.
ResizeBehaveType	Represents the resize behave mode.
ShapeArrowLengthType	Represents arrow head length.
ShapeArrowStyleType	Represents shape arrow style type.
ShapeArrowWidthType	Represents arrow head width.
ShapeDashLineStyleType	Represents shape dash line style.
ShapeFillType	Represents shape xls fill type.
ShapeLineStyleType	Represents shape line style.
SheetProtectionType	Represents sheet protection flags enums.
SortComparsionType	Represents the sort by in the range.
SortedWayType	Represents the algorithm to sort.
SparklineType	Defined types of sparkline chart types.
SplitType	Split type.
SubtotalTypes	Represents the subtotal types.
TableBuiltInStyles	Excel 2007 table built in styles.
TextRotationType	Text Rotation types.
TickLabelPositionType	Represents enum of chart tick label position values.
TickMarkType	Represents enum of chart tick mark values.
TopBottomType	TopBottom
TopFormatType	Top format type.
TrendLineType	Represents trend line values.
UnknownVariableAction	Defines action that must be taken when meeting unknown variable during template markers processing.
ValidationComparisonOperator	The comparison operator for conditional formatting.
VariableTypeAction	Defines value type and numberformat in the template marker variable.
VerticalAlignType	Vertical alignment type.
ViewMode	Defines the view setting of the sheet.
WorksheetCopyType	Enumeration to specify options when copying worksheets.
WorksheetVisibility	Visibility of worksheet type.
XLSXBorderJoinType	shape border join type
XLSXChartMaterialType	Indicates the Material property values fro the chart
XLSXChartPrespectiveType	Indicates the Perspective shadow Values
XLSXChartShadowInnerType	Indicates the Inner Shadow Values
XLSXChartShadowOuterType	Indicates the Outer Shadow values