Namespace Spire.Xls
Classes
- ColorScale
The color scale condition in the conditional format
- ConditionValue
Represents single condition value for iconset, databar, colorscale conditions.
- ConditionalFormat
Contains a condition and the formatting for cells.
- ConditionalFormats
Contains a condition and the formatting for cells.
- ConverterSetting
Convert Setting
- DataBar
Represents a data bar conditional formating rule.
- ExcelInterior
Used to get or set interior settings.
- GoalSeek
Goal seek.
- GoalSeekResult
Goal seek calculate result.
- IconSet
Conditional formatting icon set condition.
- MarkerDesigner
WorkbookDesignerused for template markers to the workbook and worksheet.
- OColor
This object used to store, convert colors.
- PageSetup
Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
- SaveShapeTypeOption
Specifies the shape type that needs to be converted to a picture, and defaults to all types
- Sparkline
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
- SparklineCollection
Represents the SparklineCollection.
- SparklineGroupCollection
The SparklineGroupCollection represents the collection of SparklineGroup objects.
- VPageBreak
Represents a vertical page break.
Structs
Interfaces
Enums
- 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..
- BaseFormatType
Base format options.
- BordersLineType
Specifies border and diagonal line types in Excel.
- BubbleSizeType
Bubble size.
- BuiltInPropertyType
SummaryInformation 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.
- ChartExPositionAlignment
It represent side position alignment of a chart element
- ChartExSidePosition
It specifies an enumeration of side positions
- ChartLinePatternType
Chart line patterns.
- ChartLineWeightType
Chart line weight values type.
- ChartMarkerType
Chart marker types.
- ChartParagraphType
MS Chart Font Type
- ChartPieType
Chart pile type.
- ChartPlotEmptyType
Chart plot empty type.
- ChartStyleElements
Contains the list of style elements
- CheckState
Specifies check state of the check box.
- ColorModel
Contains the list of color models
- ColorType
Color types.
- CommentHAlignType
Comment horizontally align.
- CommentVAlignType
Comment vertically align
- ComparisonOperatorType
The Comparison operator for conditional formatting in Excel.
- ConditionalFormatType
Conditional formatting type.
- DataLabelPositionType
Represents Data label placement.
- DataSourceType
Data source type.
- DropLineStyleType
Drop line style type.
- EndLineCap
This simple type enumeration specifies how to cap the ends of lines.
- ErrorBarIncludeType
Represents error bar include values.
- ErrorBarType
Error-bar type.
- Excel2007DataLabelPos
Represents the data label positioning.
- ExcelCalculationMode
Enum that defines different types of the formula calculations.
- ExcelChartType
Chart types.
- ExcelColors
Predefined colors in excel.
- ExcelComboType
Represents possible combo box type values..
- ExcelHorizontalAlignment
Represents different horizontal alignments
- ExcelPatternType
Patterns style.
- ExcelQuartileCalculation
It represents Quartile calculation used for Box and Whisker Chart series
- ExcelShapeType
Excel shapes.
- ExcelSheetType
Sheet types.
- ExcelTreeMapLabelOption
It represents the Label position in Tree Map chart
- ExcelVersion
Represents possible excel versions.
- ExcelVerticalAlignment
Represents different vertical alignments
- ExpandCollapseFlags
Flags for expand/collapse settings.
- FileFormat
Represents possible excel versions.
- FilterConditionType
Filter conditions.
- FilterDataType
Data type for filters.
- FontCollectionIndex
Enumeration represents one of the fonts associated with the style.
- FontUnderlineType
Font underline types.
- FontVertialAlignmentType
Defines the possible settings for vertical alignment of a run of text. This is used to get superscript or subscript text without altering the font size properties of the rest of the text run.
- 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.
- HorizontalAlignType
Horizontal alignment type.
- HyperLinkType
Hyper link type.
- IgnoreErrorType
Represents flags of excel ignore error indicator.
- ImageFormatType
Image formats.
- ImageType
Possible image types for image conversion.
- LegendPositionType
Legend placement for charts.
- LegendSpacingType
Legend spacing for charts.
- LineStyleType
Border line styles.
- 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.
- PrintCommentType
Print comments types.
- PrintErrorsType
Print error values.
- ReadingOrderType
Reading order types.
- RectangleStyleType
Excel rectangle style.
- ResizeBehaveType
Represents The ResizeBehave 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 XlsFill type.
- ShapeLayerChangeType
Change target type of shape.
- ShapeLineStyleType
Represents shape line style.
- SheetProtectionType
Represents sheet protection flags enums.
- SortComparsionType
Represents the sort by in the range.
- SortOrientationType
Represents the sort orientation.
- SortedWayType
Represents the algorithm to sort.
- SparklineType
Defined types of Sparkline chart types.
- SplitType
Split type.
- StyleEntryModifierEnum
Contains the style entry modifier enumerations
- TextDirection
Represents different text direction.
- TextRotationType
Text Rotation types.
- ThemeColorType
theme color type
- TickLabelPositionType
Represents enum of chart tick label position values.
- TickMarkType
Represents enum of chart tick mark values.
- TopBottomType
TopBottom type.
- 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.
- 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