|
Class Summary |
| AboveAverage |
Describe the AboveAverage conditional formatting rule.
This conditional formatting rule highlights cells that
are above or below the average for all values in the range.
|
| ArcShape |
Represents the arc shape.
|
| Area |
Encapsulates the object that represents an area format.
|
| AutoFilter |
Represents autofiltering for the specified worksheet.
|
| AutoFitterOptions |
Represents all auto fitter options.
|
| Axis |
Encapsulates the object that represents a chart's axis.
|
| Bevel |
Represents a bevel of a shape
|
| Border |
Encapsulates the object that represents the cell border.
|
| BorderCollection |
Encapsulates a collection of Border objects.
|
| BuiltInDocumentPropertyCollection |
A collection of built-in document properties.
|
| Button |
Represents the Forms control: Button
|
| Cell |
Encapsulates the object that represents a single Workbook cell.
|
| CellArea |
Represent an area of cells.
|
| Cells |
Encapsulates a collection of Cell objects.
|
| CellsColor |
Represents all types of color.
|
| CellsDrawing |
Represents the auto shape and drawing object.
|
| CellsException |
The exception that is thrown when Aspose.Cells specified error occurs.
|
| CellsHelper |
Provides helper functions.
|
| Chart |
Encapsulates the object that represents a single Excel chart.
|
| ChartArea |
Encapsulates the object that represents the chart area in the worksheet.
|
| ChartCollection |
Encapsulates a collection of Chart objects.
|
| ChartDataTable |
Represents a chart data table.
|
| ChartFrame |
Encapsulates the object that represents the frame object in a chart.
|
| ChartPoint |
Represents a single point in a series in a chart.
|
| ChartPointCollection |
Represents a collection that contains all the points in one series.
|
| ChartShape |
Represents the shape of the chart.
Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the worksheet.
|
| CheckBox |
Represents a check box object in a worksheet.
|
| CheckBoxCollection |
Represents a collection of CheckBox objects in a worksheet.
|
| CollectionBase |
Provides the abstract base class for a strongly typed collection.
|
| Color |
Represents an ARGB (alpha, red, green, blue) color.
|
| ColorFilter |
Represents the color filter.
|
| ColorScale |
Describe the ColorScale conditional formatting rule.
This conditional formatting rule creates a gradated color scale on the cells.
|
| Column |
Represents a single column in a worksheet.
|
| ColumnCollection |
Collects the objects that represent the individual columns in a worksheet.
|
| ComboBox |
Represents the control form ComboBox.
|
| Comment |
Encapsulates the object that represents a cell comment.
|
| CommentCollection |
Encapsulates a collection of Comment objects.
|
| CommentShape |
Represents the shape of the comment.
|
| ConditionalFormattingCollection |
Encapsulates a collection of FormatCondition objects.
|
| ConditionalFormattingIcon |
Represents the custom icon of conditional formatting rule.
|
| ConditionalFormattingIconCollection |
Represents a collection of ConditionalFormattingIcon objects.
|
| ConditionalFormattingResult |
Represents the result of conditional formatting which applies to a cell.
|
| ConditionalFormattingValue |
Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
|
| ConditionalFormattingValueCollection |
Describes a collection of CFValueObject.
Use only for icon sets.
|
| ContentTypeProperty |
Represents identifier information.
|
| ContentTypePropertyCollection |
A collection of ContentTypeProperty objects that represent additional information.
|
| CopyOptions |
Represents the copy options.
|
| CustomDocumentPropertyCollection |
A collection of custom document properties.
|
| CustomFilter |
Represents the custom filter.
|
| CustomFilterCollection |
Represents the custom filters.
|
| CustomProperty |
Represents identifier information.
|
| CustomPropertyCollection |
A collection of CustomProperty objects that represent additional information.
|
| DataBar |
Describe the DataBar conditional formatting rule.
This conditional formatting rule displays a gradated
data bar in the range of cells.
|
| DataBarBorder |
Represents the border of the data bars specified by a conditional formatting rule.
|
| DataLabels |
Encapsulates a collection of all the DataLabel objects for the specified Series.
|
| DataSorter |
Summary description for DataSorter.
|
| DateTime |
Represents an instant in time, typically expressed as a date and time of day.
|
| DateTimeGroupItem |
|
| DifSaveOptions |
Represents the options of saving dif file.
|
| DigitalSignature |
Signature in file.
|
| DigitalSignatureCollection |
Provides a collection of digital signatures attached to a document.
|
| DisplayUnitLabel |
Represents the display unit label.
|
| DocumentProperty |
Represents a custom or built-in document property.
|
| DocumentPropertyCollection |
Base class for BuiltInDocumentPropertyCollection and CustomDocumentPropertyCollection collections.
|
| DrawObject |
DrawObject will be initalized and returned when rendering
|
| DrawObjectEventHandler |
Interface to get DrawObject and Bound when rendering.
|
| DropBars |
Represents the up/down bars in a chart.
|
| DynamicFilter |
Represents the dynamic filter.
|
| Encoding |
|
| ErrorBar |
Represents error bar of data series.
|
| ErrorCheckOption |
Error check setting applied on certain ranges.
|
| ErrorCheckOptionCollection |
Represents all erorr check option.
|
| ExportObjectEvent |
The event triggered when exporting an object, such as Picture.
|
| ExportTableOptions |
Represents all export table options.
|
| ExternalLink |
Represents an external link in a workbook.
|
| ExternalLinkCollection |
Represents external links collection in a workbook.
|
| FileFormatUtil |
Provides utility methods for conveting file format enums to strings or file extensions and back.
|
| FillFormat |
Encapsulates the object that represents fill formatting for a shape.
|
| FilterColumn |
Represents a filter for a single column. The Filter object is a member of the Filters collection
|
| FilterColumnCollection |
A collection of Filter objects that represents all the filters in an autofiltered range.
|
| FindOptions |
Represents find options.
|
| Floor |
Encapsulates the object that represents the floor of a 3-D chart.
|
| Font |
Encapsulates the font object used in a spreadsheet.
|
| FontSetting |
Represents a range of characters within the cell text.
|
| Format3D |
This class specifies the 3D shape properties for a chart element or shape.
|
| FormatCondition |
Represents conditional formatting condition.
|
| FormatConditionCollection |
Represents conditional formatting.
The FormatConditions can contain up to three conditional formats.
|
| GlowEffect |
This class specifies a glow effect, in which a color blurred outline
is added outside the edges of the object.
|
| GradientFill |
Represents the gradient fill.
|
| GradientStop |
Represents the gradient stop.
|
| GradientStopCollection |
Represents the gradient stop collection.
|
| GroupBox |
Encapsulates the object that represents a groupbox in a spreadsheet.
|
| GroupShape |
Represents the individual shapes within a grouped shape.
|
| HeaderFooterCommand |
Represents the command of header/footer
|
| HorizontalPageBreak |
Encapsulates the object that represents a horizontal page break.
|
| HorizontalPageBreakCollection |
Encapsulates a collection of HorizontalPageBreak objects.
|
| HTMLLoadOptions |
Represents options when importing a html file.
|
| HtmlSaveOptions |
Represents the options for saving html file.
|
| Hyperlink |
Encapsulates the object that represents a hyperlink.
|
| HyperlinkCollection |
Encapsulates a collection of Hyperlink objects.
|
| IconFilter |
Reprents icon filter.
|
| IconSet |
Describe the IconSet conditional formatting rule.
This conditional formatting rule applies icons to cells
according to their values.
|
| ImageFormat |
|
| ImageOrPrintOptions |
Allows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
|
| ImportTableOptions |
Represents the options of importing data into cells.
|
| InterruptMonitor |
Represents all operator about the interrupt.
|
| Label |
Encapsulates the object that represents a label in a spreadsheet.
|
| Legend |
Encapsulates the object that represents the chart legend.
|
| LegendEntry |
Represents a legend entry in a chart legend.
|
| LegendEntryCollection |
Represents a collection of all the LegendEntry objects in the specified chart legend.
|
| License |
Provides methods to license the component.
|
| Line |
Encapsulates the object that represents the line format.
|
| LineShape |
Represents the line shape.
|
| ListBox |
Represents a list box object.
|
| ListColumn |
Represents a column in a list.
|
| ListColumnCollection |
A collection of all the ListColumn objects in the specified ListObject object.
|
| ListObject |
Represents a list object on a worksheet.
The ListObject object is a member of the ListObjects collection.
The ListObjects collection contains all the list objects on a worksheet.
|
| ListObjectCollection |
Returns a collection of ListObject objects in the worksheet.
|
| LoadDataOption |
The load data options.
|
| LoadOptions |
Represents the options of loading the file.
|
| Marker |
Represents the marker in a line chart, scatter chart, or radar chart.
|
| MsoFillFormat |
Represents fill formatting for a shape.
|
| MsoFillFormatHelper |
Represents fill formatting for a shape.
|
| MsoFormatPicture |
Reprensents the picture format.
|
| MsoLineFormat |
Represents line and arrowhead formatting.
|
| MsoTextFrame |
Represents the text frame in a Shape object.
|
| MultipleFilterCollection |
Represents the multiple filte collection.
|
| Name |
Represents a defined name for a range of cells.
|
| NameCollection |
Represents a collection of all the Name objects in the spreadsheet.
|
| NegativeBarFormat |
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
|
| OdsSaveOptions |
Represents the options of saving ods file.
|
| OleObject |
Represents an OleObject in a worksheet.
|
| OleObjectCollection |
Represents embedded OLE objects.
|
| OoxmlSaveOptions |
Represents the options of saving office open xml file.
|
| Oval |
Represents the oval shape.
|
| PageSetup |
Encapsulates the object that represents the page setup description.
The PageSetup object contains all page setup options.
|
| PaneCollection |
Represents all Pane objects shown in the specified window.
|
| PasteOptions |
Represents the paste special options.
|
| PatternFill |
Encapsulates the object that represents pattern fill format
|
| PdfBookmarkEntry |
PdfBookmarkEntry is an entry in pdf bookmark.
if Text property of current instance is null or "",
current instance will be hidden and children will be inserted on current level.
|
| PdfSecurityOptions |
Settings of pdf when converting excel to pdf, PDF/A does not allow security setting.
|
| PicFormatOption |
Represents pictrue format option
|
| Picture |
Encapsulates the object that represents a single picture in a spreadsheet.
|
| PictureCollection |
Encapsulates a collection of Picture objects.
|
| PivotField |
Represents a field in a PivotTable report.
|
| PivotFieldCollection |
Represents a collection of all the PivotField objects
in the PivotTable's specific PivotFields type.
|
| PivotFilter |
Represents a PivotFilter in PivotFilter Collection.
|
| PivotFilterCollection |
Represents a collection of all the PivotFilter objects
|
| PivotFormatCondition |
Represents a PivotTable Format Condition in PivotFormatCondition Collection.
|
| PivotFormatConditionCollection |
Represents PivotTable Format Conditions.
|
| PivotItem |
Represents a item in a PivotField report.
|
| PivotItemCollection |
Represents a collection of all the PivotItem objects in the PivotField's
|
| PivotPageFields |
Represents the pivot page field items
if the pivot table data source is consolidation ranges.
It only can contain up to 4 fields.
|
| PivotTable |
Summary description for PivotTable.
|
| PivotTableCollection |
Represents the collection of all the PivotTable objects on the specified worksheet.
|
| PlotArea |
Encapsulates the object that represents the plot area in a chart.
|
| ProtectedRange |
A specified range to be allowed to edit when the sheet protection is ON.
|
| ProtectedRangeCollection |
Encapsulates a collection of ProtectedRange objects.
|
| Protection |
Represents the various types of protection options available for a worksheet.
Only used in ExcelXP and above version.
|
| QueryTable |
Represents QueryTable information.
|
| QueryTableCollection |
A collection of QueryTableCollection objects that represent QueryTable collection information.
|
| RadioButton |
Represents a radion button.
|
| Range |
Encapsulates the object that represents a range of cells within a spreadsheet.
|
| RangeCollection |
Encapsulates a collection of Range objects.
|
| RectangleShape |
Represents the rectangle shape.
|
| ReferredArea |
Represents a referred objcet by the formula.
|
| ReferredAreaCollection |
Represents all referred cells and areas.
|
| ReplaceOptions |
Represent the replace options.
|
| Row |
Represents a single row in a worksheet.
|
| RowCollection |
Collects the objects that represent the individual rows in a worksheet.
|
| SaveOptions |
Represents all save options
|
| ScrollBar |
Represents a scroll bar object.
|
| Series |
Encapsulates the object that represents a single data series in a chart.
|
| SeriesCollection |
Encapsulates a collection of Series objects.
|
| ShadowEffect |
This class specifies the shadow effect of the chart element or shape.
|
| Shape |
Represents the msodrawing object.
|
| ShapeCollection |
Represents all the shape in a worksheet/chart.
|
| ShapePropertyCollection |
This class specifies the visual shape properties for a chart element or shape.
|
| SmartTag |
Represents a smart tag.
|
| SmartTagCollection |
Represents all smart tags in the cell.
|
| SmartTagOptions |
Represents the options of the smart tag.
|
| SmartTagProperty |
Represents the property of the cell smart tag.
|
| SmartTagPropertyCollection |
Represents all properties of cell smart tag.
|
| SmartTagSetting |
Represents all SmartTagCollection object in the worksheet.
|
| SolidFill |
Encapsulates the object that represents solid fill format
|
| Sparkline |
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
|
| SparklineCollection |
Encapsulates a collection of Sparkline objects.
|
| SparklineGroup |
Sparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items.
A sparkline group specifies the type, display settings and axis settings for the sparklines.
|
| SparklineGroupCollection |
Encapsulates a collection of SparklineGroup objects.
|
| Spinner |
Represents the Forms control: Spinner.
|
| SpreadsheetML2003SaveOptions |
Represents the options for saving Excel 2003 spreadml file.
|
| StreamProviderOptions |
Represents the stream options.
|
| Style |
Represents display style of excel document,such as font,
color,alignment,border,etc.
|
| StyleCollection |
Encapsulates a collection of Style objects.
|
| StyleFlag |
Represents flags which indicates applied formatting properties.
|
| SxRng |
Represents Group Range in a PivotField.
|
| TableStyle |
Represents the table style.
|
| TableStyleCollection |
Represents all custom table styles.
|
| TableStyleElement |
Represents the element of the table style.
|
| TableStyleElementCollection |
Represents all elements of the table style.
|
| TextBox |
Encapsulates the object that represents a textbox in a spreadsheet.
|
| TextBoxCollection |
Encapsulates a collection of TextBox objects.
|
| TextEffectFormat |
Contains properties and methods that apply to WordArt objects.
|
| TextureFill |
Encapsulates the object that represents texture fill format
|
| ThemeColor |
Represents a theme color.
|
| TickLabels |
Represents the tick-mark labels associated with tick marks on a chart axis.
|
| TilePicOption |
Represents tile picture as texture.
|
| Title |
Encapsulates the object that represents the title of chart or axis.
|
| Top10 |
Describe the Top10 conditional formatting rule.
This conditional formatting rule highlights cells whose
values fall in the top N or bottom N bracket, as specified.
|
| Top10Filter |
Represents the top 10 filter.
|
| Trendline |
Represents a trendline in a chart.
|
| TrendlineCollection |
Represents a collection of all the Trendline objects for the specified data series.
|
| TxtLoadOptions |
Represents the options for loading text file.
|
| TxtSaveOptions |
Repesents the save options for csv/tab delimitered/other text format.
|
| Validation |
Represents data validation.settings.
|
| ValidationCollection |
Represents data validation collection.
|
| VerticalPageBreak |
Encapsulates the object that represents a vertical page break.
|
| VerticalPageBreakCollection |
Encapsulates a collection of VerticalPageBreak objects.
|
| Walls |
Encapsulates the object that represents the walls of a 3-D chart.
|
| Workbook |
Represents a root object to create an Excel spreadsheet.
|
| WorkbookDesigner |
Encapsulates the object that represents a designer spreadsheet.
|
| WorkbookSettings |
Represents all seetings of the workbook.
|
| Worksheet |
Encapsulates the object that represents a single worksheet.
|
| WorksheetCollection |
Encapsulates a collection of Worksheet objects.
|
| XlsbSaveOptions |
Represents the options for saving xlsb file.
|
| XlsSaveOptions |
Represents the save options for the Excel 97-2003 file format: xls and xlt.
|
| XmlColumnProperty |
Represents Xml Data Binding information.
|
| XmlDataBinding |
Represents Xml Data Binding information.
|
| XmlMap |
Represents Xml map information.
|
| XmlMapCollection |
A collection of XmlMap objects that represent XmlMap information.
|
|
Constant Summary |
| AutoShapeType |
Utility class containing constants.
Represents all built-in auto shape type.
|
| BackgroundMode |
Utility class containing constants.
Represents the display mode of the background.
|
| BackgroundType |
Utility class containing constants.
Enumerates cell background pattern types.
|
| Bar3DShapeType |
Utility class containing constants.
Represents the shape used with the 3-D bar or column chart.
|
| BevelPresetType |
Utility class containing constants.
Represents a preset for a type of bevel which can be applied to a shape in 3D.
|
| BorderType |
Utility class containing constants.
Enumerates the border line and diagonal line types.
|
| BubbleSizeRepresents |
Utility class containing constants.
Represents what the bubble size represents on a bubble chart.
|
| BuiltinStyleType |
Utility class containing constants.
Represents all builit style type
|
| CalcModeType |
Utility class containing constants.
Calculate formula mode type.
|
| CategoryType |
Utility class containing constants.
Represents the category axis type.
|
| CellBorderType |
Utility class containing constants.
Enumerates a cell's border type.
|
| CellValueType |
Utility class containing constants.
Specifies a cell value type.
|
| ChartMarkerType |
Utility class containing constants.
Represents the marker style in a line chart, scatter chart, or radar chart.
|
| ChartSplitType |
Utility class containing constants.
Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
|
| ChartType |
Utility class containing constants.
Enumerates all chart types used in Excel.
|
| CheckValueType |
Utility class containing constants.
Represents the check value type of the check box.
|
| ColorType |
Utility class containing constants.
Indicates all color type
|
| ConsolidationFunction |
Utility class containing constants.
Represents consolidation function.
|
| CountryCode |
Utility class containing constants.
Represents Excel country identifiers.
|
| CrossType |
Utility class containing constants.
Represents the axis cross type.
|
| DataBarAxisPosition |
Utility class containing constants.
Specifies the axis position for a range of cells with conditional formatting as data bars.
|
| DataBarBorderType |
Utility class containing constants.
Specifies the border of a data bar.
|
| DataBarFillType |
Utility class containing constants.
Specifies how a data bar is filled with color.
|
| DataBarNegativeColorType |
Utility class containing constants.
Specifies whether to use the same border and fill color as postive data bars.
|
| DataLablesSeparatorType |
Utility class containing constants.
Represents the separator type of DataLables.
|
| DateTimeGroupingType |
Utility class containing constants.
Specifies how to group dateTime values.
|
| DirectoryType |
Utility class containing constants.
Represents the directory type of the file name.
|
| DisplayDrawingObjects |
Utility class containing constants.
Represents whether and how to show objects in the workbook.
|
| DisplayUnitType |
Utility class containing constants.
Represents the type of display unit.
|
| DrawObjectEnum |
Utility class containing constants.
Indicate Cell or Image of DrawObject.
|
| DynamicFilterType |
Utility class containing constants.
Dynamic filter type.
|
| EncryptionType |
Utility class containing constants.
Encryption Type.
Only used by excel2003.
We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.
|
| ErrorBarDisplayType |
Utility class containing constants.
Represents error bar display type.
|
| ErrorBarType |
Utility class containing constants.
Represents error bar amount type.
|
| ErrorCheckType |
Utility class containing constants.
Represents all error check type.
|
| ExceptionType |
Utility class containing constants.
Represents custom exception type code.
|
| FileFormatType |
Utility class containing constants.
Enumerates spreadsheet file format types
|
| FillPattern |
Utility class containing constants.
Enumerates shape fill pattern types.
|
| FillPictureType |
Utility class containing constants.
Represents the picture fill type.
|
| FillType |
Utility class containing constants.
Fill format type.
|
| FilterOperatorType |
Utility class containing constants.
Custom Filter operator type.
|
| FilterType |
Utility class containing constants.
The filter type.
|
| FontUnderlineType |
Utility class containing constants.
Enumerates the font underline types.
|
| FormatConditionType |
Utility class containing constants.
Conditional format rule type.
|
| FormatConditionValueType |
Utility class containing constants.
Condition value type.
|
| FormatSetType |
Utility class containing constants.
Fill format set type.
|
| FormattingType |
Utility class containing constants.
Represents the type of formatting applied to an Area object or a Line object.
|
| GradientColorType |
Utility class containing constants.
Represents the gradient color type for the specified fill.
|
| GradientDirectionType |
Utility class containing constants.
Represents all direction type of gradient.
|
| GradientFillType |
Utility class containing constants.
Represents all Gradient fill type.
|
| GradientPresetType |
Utility class containing constants.
Represents gradient preset color type.
|
| GradientStyleType |
Utility class containing constants.
Represents gradient shading style.
|
| HeaderFooterCommandType |
Utility class containing constants.
Represents the command type of header and footer.
|
| HeaderFooterSectionType |
Utility class containing constants. |
| HtmlCrossType |
Utility class containing constants.
Represents three types of html corss string.
|
| HtmlHiddenColDisplayType |
Utility class containing constants.
Represents two types of showing the hidden col in html.
|
| HtmlHiddenRowDisplayType |
Utility class containing constants.
Represents two types of showing the hidden row in html.
|
| IconSetType |
Utility class containing constants.
Icon set type for conditional formatting.
The threshold values for triggering the different icons within a set are
configurable, and the icon order is reversible.
|
| LabelPositionType |
Utility class containing constants.
Represents data label position type.
|
| LegendPositionType |
Utility class containing constants.
Enumerates the legend position types.
|
| LightRigType |
Utility class containing constants.
Represents a preset light right that can be applied to a shape
|
| LineCapType |
Utility class containing constants.
Represents the caps of a line
|
| LineJoinType |
Utility class containing constants.
Represents the join styles of a line.
|
| LineType |
Utility class containing constants.
Enumerates the type of Picture border or Chart line.
|
| LoadFormat |
Utility class containing constants.
Represents the load file format.
|
| LookAtType |
Utility class containing constants.
Represents look at type.
|
| LookInType |
Utility class containing constants.
Represents look in type.
|
| MirrorType |
Utility class containing constants.
Represents mirror type of textrue fill
|
| MsoArrowheadLength |
Utility class containing constants.
Enumerates the line end width of the shape border line.
|
| MsoArrowheadStyle |
Utility class containing constants.
Enumerates the line end type of the shape border line.
|
| MsoArrowheadWidth |
Utility class containing constants.
Enumerates the line end width of the shape border line.
|
| MsoDrawingType |
Utility class containing constants.
Represents office drawing objects type.
|
| MsoLineDashStyle |
Utility class containing constants.
Represents style of dash drawing lines.
|
| MsoLineStyle |
Utility class containing constants.
Represents style of drawing lines.
|
| MsoPathType |
Utility class containing constants.
Represents path segment type.
|
| MsoPresetTextEffect |
Utility class containing constants.
Represents preset text effect type of WordArt.
|
| MsoPresetTextEffectShape |
Utility class containing constants.
Represents preset text effect shape type of WordArt.
|
| NumberCategoryType |
Utility class containing constants.
Represents category type of cell's number formatting.
|
| OleFileType |
Utility class containing constants.
Ole object file type.
|
| OperatorType |
Utility class containing constants.
Represents the operator type of conditional format and data validation.
|
| Outline |
Utility class containing constants.
Represents an outline on a worksheet.
|
| PageOrientationType |
Utility class containing constants.
Represents print orientation constants.
|
| PaperSizeType |
Utility class containing constants.
Represents paper size constants.
|
| ParameterType |
Utility class containing constants.
Reprents all parameters' type or return value type of fuction.
|
| PasteType |
Utility class containing constants.
Represents the paste special type.
|
| PdfCompliance |
Utility class containing constants.
Allowing user to set PDF convertion's Compatibility
|
| PdfCompressionCore |
Utility class containing constants.
Specifies a type of compression applied to all content in the PDF file except images.
|
| PivotConditionFormatScopeType |
Utility class containing constants.
Represents PivotTable condition format scope type.
|
| PivotFieldDataDisplayFormat |
Utility class containing constants.
Represents data display format in the PivotTable data field.
|
| PivotFieldSubtotalType |
Utility class containing constants.
Summary description for PivotFieldSubtotalType.
|
| PivotFieldType |
Utility class containing constants.
Represents PivotTable field type.
|
| PivotFilterType |
Utility class containing constants.
Represents PivotTable Filter type.
|
| PivotGroupByType |
Utility class containing constants.
Represents PivotTable groupby type.
|
| PivotItemPosition |
Utility class containing constants.
Represents PivotTable base item Next/Previous/All position in the base field .
|
| PivotMissingItemLimitType |
Utility class containing constants.
Represents number of items to retain per field.
|
| PivotTableAutoFormatType |
Utility class containing constants.
Represents PivotTable auto format type.
|
| PivotTableSourceType |
Utility class containing constants.
Represents the pivot table data source type.
|
| PivotTableStyleType |
Utility class containing constants.
Represents the pivot table style type.
|
| PlacementType |
Utility class containing constants.
Represents the way the drawing object is attached to the cells below it.
|
| PlotEmptyCellsType |
Utility class containing constants.
Represents all plot empty cells type of a chart.
|
| PresetMaterialType |
Utility class containing constants.
Describes surface appearance of a shape.
|
| PresetShadowType |
Utility class containing constants.
Represents preset shadow type.
|
| PrintCommentsType |
Utility class containing constants.
Represents the way comments are printed with the sheet.
|
| PrintErrorsType |
Utility class containing constants.
Represents print errors constants.
|
| PrintingPageType |
Utility class containing constants.
Indicates which pages will not be printed.
|
| PrintOrderType |
Utility class containing constants.
Represent print order constants.
|
| PrintSizeType |
Utility class containing constants.
Represents the printed chart size.
|
| PropertyType |
Utility class containing constants.
Specifies data type of a document property.
|
| ProtectionType |
Utility class containing constants.
Represents workbook/worksheet protection type.
|
| RectangleAlignmentType |
Utility class containing constants.
Represents how to position two rectangles relative to each other.
|
| SaveFormat |
Utility class containing constants.
Represents the format in which the workbook is saved.
|
| SelectionType |
Utility class containing constants.
The selection type of list box.
|
| SheetType |
Utility class containing constants.
Specifies the worksheet type.
|
| ShiftType |
Utility class containing constants.
Represent the shift options when deleting a range of cells.
|
| SmartTagShowType |
Utility class containing constants.
Represents the show type of the smart tag.
|
| SortOrder |
Utility class containing constants.
Represents sort order for the data range.
|
| SparklineAxisMinMaxType |
Utility class containing constants.
Represents the minimum and maximum value types for the sparkline vertical axis.
|
| SparklinePresetStyleType |
Utility class containing constants.
Represents the preset style types for sparkline.
|
| SparklineType |
Utility class containing constants.
Represents the sparkline types.
|
| StyleModifyFlag |
Utility class containing constants.
The style mofied flags.
|
| TableStyleElementType |
Utility class containing constants.
Represents the Table or PivotTable style element type.
|
| TableStyleType |
Utility class containing constants.
Represents the built-in table style type.
|
| TextAlignmentType |
Utility class containing constants.
Enumerates text alignment types.
|
| TextCapsType |
Utility class containing constants.
This type specifies the cap types of the text.
|
| TextDirectionType |
Utility class containing constants.
Represents text reading order.
|
| TextOrientationType |
Utility class containing constants.
Enumerates text orientation types.
|
| TextOverflowType |
Utility class containing constants.
Represents the way the text vertical or horizontal overflow.
|
| TextStrikeType |
Utility class containing constants.
This type specifies the strike type.
|
| TextureType |
Utility class containing constants.
Represents the preset texture type.
|
| ThemeColorType |
Utility class containing constants.
Enumerates the theme color types.
|
| TickLabelPositionType |
Utility class containing constants.
Represents the position type of tick-mark labels on the specified axis.
|
| TickMarkType |
Utility class containing constants.
Represents the tick mark type for the specified axis.
|
| TiffCompression |
Utility class containing constants.
Specifies what type of compression to apply when saving images into TIFF format file.
|
| TimePeriodType |
Utility class containing constants.
Used in a FormatConditionType.TimePeriod conditional formatting rule.
These are dynamic time periods, which change based on
the date the conditional formatting is refreshed / applied.
|
| TimeUnit |
Utility class containing constants.
Represents the base unit for the category axis.
|
| TotalsCalculation |
Utility class containing constants.
Determines the type of calculation in the Totals row of the list column.
|
| TrendlineType |
Utility class containing constants.
Represents the trendline type.
|
| TxtValueQuoteType |
Utility class containing constants.
Specifies the type of using quotation marks for values in text format files.
|
| ValidationAlertType |
Utility class containing constants.
Represents the data validation alert style.
|
| ValidationType |
Utility class containing constants.
Represents data validation type.
|
| ViewType |
Utility class containing constants.
Represents the view type of the worksheet.
|
| VisibilityType |
Utility class containing constants.
Represents the states for sheet visibility.
|
| WeightType |
Utility class containing constants.
Enumerates the weight types for a picture border or a chart line.
|