aspose.cells

Package aspose.cells

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.
AbstractCalculationMonitor
Monitor for user to track the progress of formula calculation.
AbstractGlobalizationSettings
Represents the globalization settings.
AbstractInterruptMonitor
Monitor for interruption requests in all time-consuming operations.
AbstractTextLoadOptions
Common options for loading text values
AccentEquationNode
This class specifies an accent equation, consisting of a base component and a combining diacritic.
ActiveXControl
Represents the ActiveX control.
ActiveXControlBase
Represents the ActiveX control.
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.
AutomaticFill
represents automatic fill.
AutoNumberedBulletValue
Represents automatic numbered bullet.
Axis
Encapsulates the object that represents an axis of chart.
AxisBins
Represents axis bins
BarEquationNode
This class specifies the bar equation, consisting of a base argument and an overbar or underbar.
BaseShapeGuide
Represents the shape guide.
Bevel
Represents a bevel of a shape
Border
Encapsulates the object that represents the cell border.
BorderBoxEquationNode
This class specifies the Border Box function, consisting of a border drawn around an equation.
BorderCollection
Encapsulates a collection of Border objects.
BoxEquationNode
This class specifies the box function, which is used to group components of an equation.
BuiltInDocumentPropertyCollection
A collection of built-in document properties.
Bullet
Represents the bullet points should be applied to a paragraph.
BulletValue
Represents the value of the bullet.
Button
Represents the Forms control: Button
CalculationCell
Represents the calculation relevant data about one cell which is being calculated.
CalculationData
Represents the required data when calculating one function, such as function name, parameters, ...etc.
CalculationOptions
Represents options for calculation.
Cell
Encapsulates the object that represents a single Workbook cell.
CellArea
Represent an area of cells.
Cells
Encapsulates a collection of cell relevant objects, such as Cell, Row, ...etc.
CellsColor
Represents all types of color.
CellsDataTableFactory
Utility to build ICellsDataTable from custom objects for user's convenience.
CellsDrawing
Represents the auto shape and drawing object.
CellsException
The exception that is thrown when Aspose.Cells specified error occurs.
CellsFactory
Utility for instantiating classes of Cells model.
CellsHelper
Provides helper functions.
CellValue
Represents the cell value and corresponding type.
CellWatch
Represents Cell Watch Item in the 'watch window'.
CellWatchCollection
Represents the collection of cells on this worksheet being watched in the 'watch window'.
CharacterBulletValue
Represents the character bullet.
Chart
Encapsulates the object that represents a single Excel chart.
ChartArea
Encapsulates the object that represents the chart area in the worksheet.
ChartCalculateOptions
Represents the options for calculating chart.
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.
ChartGlobalizationSettings
Represents the globalization settings for 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.
ChartTextFrame
Encapsulates the object that represents the frame object which contains text.
CheckBox
Represents a check box object in a worksheet.
CheckBoxActiveXControl
Represents a CheckBox ActiveX control.
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 filtering the range by color.
ColorHelper
Provides helper functions about color.
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
Collection of the Column objects that represent the individual column(setting)s in a worksheet. The Column object only represents the settings such as column width, styles, .etc. for the whole column, has nothing to do with the fact that there are non-empty cells(data) or not in corresponding column. And the "Count" of this collection only represents the count Column objects that have been instantiated in this collection, has nothing to do with the fact that there are non-empty cells(data) or not in the worksheet.
ComboBox
Represents the control form ComboBox.
ComboBoxActiveXControl
Represents a ComboBox ActiveX control.
CommandButtonActiveXControl
Represents a command button.
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.
ConnectionParameter
Specifies properties about any parameters used with external data connections Parameters are valid for ODBC and web queries.
ConnectionParameterCollection
Specifies the ConnectionParameter collection
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.
CustomFunctionDefinition
Definition of custom function for calculating with user's custom engine.
CustomGeometry
Represents a custom geometric shape.
CustomPiovtFieldGroupItem
Represents an item of custom grouped field.
CustomProperty
Represents identifier information.
CustomPropertyCollection
A collection of CustomProperty objects that represent additional information.
CustomXmlShape
Represents Custom xml shape ,such as Ink.
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.
DataMashup
Represents mashup data.
DataModelConnection
Specifies a data model connection
DataSorter
Summary description for DataSorter.
DataSorterKey
Represents the key of the data sorter.
DataSorterKeyCollection
Represents the key list of data sorter.
DateTime
Represents an instant in time, typically expressed as a date and time of day.
DateTimeGroupItem
Represents the datetime's group setting.
DBConnection
Specifies all properties associated with an ODBC or OLE DB external data connection.
DefaultStyleSettings
Settings for the default values of workbook's style properties.
DeleteOptions
Represents the setting of deleting rows/columns.
DelimiterEquationNode
This class specifies the delimiter equation, consisting of opening and closing delimiters (such as parentheses, braces, brackets, and vertical bars), and a component contained inside. The delimiter may have more than one component, with a designated separator character between each component.
DialogBox
Represents the dialog box.
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
DocxSaveOptions
Represents options of saving .docx file.
DropBars
Represents the up/down bars in a chart.
DxfCollection
Represents the master differential formatting records.
DynamicFilter
Represents the dynamic filter.
EbookLoadOptions
Represents options when importing an ebook file.
EbookSaveOptions
Represents the options for saving ebook file.
Encoding
Represents a character encoding.
EquationComponentNode
This class specifies the components of an equation or mathematical expression. Different types of components combined into different equations. For example, a fraction consists of two parts, a numerator component and a denominator component. For more component types, please refer to 'EquationNodeType'.
EquationNode
Abstract class for deriving other equation nodes.
EquationNodeParagraph
This class specifies a mathematical paragraph containing one or more MathEquationNode(OMath) elements.
ErrorBar
Represents error bar of data series.
ErrorCheckOption
Error check setting applied on certain ranges.
ErrorCheckOptionCollection
Represents all error check option.
ExportRangeToJsonOptions
Indicates the options that exporting range to json.
ExternalConnection
Specifies an external data connection
ExternalConnectionCollection
Specifies the ExternalConnection collection
ExternalLink
Represents an external link in a workbook.
ExternalLinkCollection
Represents external links collection in a workbook.
FileFontSource
Represents the single TrueType font file stored in the file system.
FileFormatInfo
Contains data returned by FileFormatUtil file format detection methods.
FileFormatUtil
Provides utility methods for converting file format enums to strings or file extensions and back.
Fill
Represents the fill format of the shape.
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.
FolderFontSource
Represents the folder that contains TrueType font files.
Font
Encapsulates the font object used in a spreadsheet.
FontConfigs
Specifies font settings
FontSetting
Represents a range of characters within the cell text.
FontSettingCollection
Represents the list of FontSetting.
FontSourceBase
This is an abstract base class for the classes that allow the user to specify various font sources
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.
FormulaParseOptions
Represents options when parsing formula.
FormulaSettings
Settings of formulas and calculation.
FractionEquationNode
This class specifies the fraction equation, consisting of a numerator and denominator separated by a fraction bar. The fraction bar can be horizontal or diagonal, depending on the fraction properties. The fraction equation is also used to represent the stack function, which places one element above another, with no fraction bar.
FunctionEquationNode
This class specifies the Function-Apply equation, which consists of a function name and an argument acted upon. The types of the name and argument components are 'EquationNodeType.FunctionName' and 'EquationNodeType.Base' respectively.
Geometry
Represents a geometric shape.
GlobalizationSettings
Represents the globalization settings.
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.
GroupCharacterEquationNode
This class specifies the Group-Character function, consisting of a character drawn above or below text, often with the purpose of visually grouping items.
GroupFill
Represents this fill format should inherit the fill properties of the group.
GroupShape
Represents the group shape which contains the individual shapes.
HeaderFooterCommand
Represents the command of header/footer
HighlightChangesOptions
Represents options of highlighting revsions or changes of shared Excel files.
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.
HtmlTableLoadOption
Represents the option when import table from html.
HtmlTableLoadOptionCollection
Represents the table options when importing html.
Hyperlink
Encapsulates the object that represents a hyperlink.
HyperlinkCollection
Encapsulates a collection of Hyperlink objects.
IconFilter
Represents icon filter.
IconSet
Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
ImageActiveXControl
Represents the image control.
ImageFormat
Specifies the file format of the image.
ImageOrPrintOptions
Allows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
ImageSaveOptions
Represents image save options. For advanced usage, please use WorkbookRender or SheetRender.
IndividualFontConfigs
Font configs for each Workbook object.
InsertOptions
Represents the options of inserting.
JsonLayoutOptions
Represents the options of json layout type.
JsonLoadOptions
Represents the options of loading json files
JsonSaveOptions
Represents the options of saving the workbook as a json file.
JsonUtility
Represents the utility class of processing json.
Label
Encapsulates the object that represents a label in a spreadsheet.
LabelActiveXControl
Represents the label ActiveX control.
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.
LineFormat
Represents all setting of the line.
LineShape
Represents the line shape.
ListBox
Represents a list box object.
ListBoxActiveXControl
Represents a ListBox ActiveX control.
ListColumn
Represents a column in a Table.
ListColumnCollection
Represents 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
Represents a collection of ListObject objects in the worksheet.
LoadFilter
Represents the filter that provides options for loading data when loading workbook from template.
LoadOptions
Represents the options of loading the file.
MarkdownSaveOptions
Represents the save options for markdown.
Marker
Represents the marker in a line chart, scatter chart, or radar chart.
MathematicalEquationNode
This class specifies an equation or mathematical expression. All mathematical text of equations or mathematical expressions are contained by this class.
MatrixEquationNode
This class specifies the Matrix equation, consisting of one or more elements laid out in one or more rows and one or more columns.
MemoryFontSource
Represents the single TrueType font file stored in memory.
MetadataOptions
Represents the options of loading metadata of the file.
Metered
Provides methods to set metered key.
MsoFillFormat
Represents fill formatting for a shape.
MsoFillFormatHelper
Represents fill formatting for a shape.
MsoFormatPicture
Represents the picture format.
MsoLineFormat
Represents line and arrowhead formatting.
MsoLineFormatHelper
Represents line and arrowhead formatting.
MsoTextFrame
Represents the text frame in a Shape object.
MultipleFilterCollection
Represents the multiple filter collection.
Name
Represents a defined name for a range of cells.
NameCollection
Represents a collection of all the Name objects in the spreadsheet.
NaryEquationNode
This class specifies an n-ary operator equation consisting of an n-ary operator, a base (or operand), and optional upper and lower bounds.
NegativeBarFormat
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
NoneBulletValue
Represents no bullet.
NoneFill
Represents no fill.
NumbersLoadOptions
Represents the options of loading Apple Numbers files.
OdsCellField
Represents the cell field of ods.
OdsCellFieldCollection
Represents the fields of ODS.
OdsLoadOptions
Represents the options of loading ods file.
OdsPageBackground
Represents the page background of ods.
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.
Outline
Represents an outline on a worksheet.
Oval
Represents the oval shape.
PageEndSavingArgs
Info for a page ends saving process.
PageSavingArgs
Info for a page saving process.
PageSetup
Encapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.
PageStartSavingArgs
Info for a page starts saving process.
PaginatedSaveOptions
Represents the options for pagination.
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.
PdfSaveOptions
Represents the options for saving pdf file.
PdfSecurityOptions
Options for encrypting and access permissions for a PDF document. PDF/A does not allow security setting.
PicFormatOption
Represents picture format option
Picture
Encapsulates the object that represents a single picture in a spreadsheet.
PictureBulletValue
Represents the value of the image bullet.
PictureCollection
Encapsulates a collection of Picture objects.
PivotArea
Presents the selected area of the PivotTable.
PivotAreaFilter
Represents the filter of PivotArea for PivotTable.
PivotAreaFilterCollection
Represents the list of filters for PivotArea
PivotDateTimeRangeGroupSettings
Represents the field grouped by date time range.
PivotDiscreteGroupSettings
Rrepsents the discrete group of pivot field
PivotField
Represents a field in a PivotTable report.
PivotFieldCollection
Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.
PivotFieldGroupSettings
Represents the group setting of pivot field.
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.
PivotGlobalizationSettings
Represents the globalization settings for pivot tables.
PivotItem
Represents a item in a PivotField report.
PivotItemCollection
Represents a collection of all the PivotItem objects in the PivotField's
PivotNumbericRangeGroupSettings
Represents the numberic range group of the pivot field.
PivotOptions
Represents a complex type that specifies the pivot controls that appear on the chart
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.
PivotTableFormat
Represents the format defined in the PivotTable.
PivotTableFormatCollection
Represents the collection of formats applied to PivotTable.
PlotArea
Encapsulates the object that represents the plot area in a chart.
PowerQueryFormula
Represents the definition of power query formula.
PowerQueryFormulaCollection
Represents all power query formulas in the mashup data.
PowerQueryFormulaFunction
Represents the function of power query.
PowerQueryFormulaItem
Represents the item of the power query formula.
PowerQueryFormulaItemCollection
Represents all item of the power query formula.
PowerQueryFormulaParameter
Represents the parameter of power query formula.
PowerQueryFormulaParameterCollection
Represents the parameters of power query formula.
PptxSaveOptions
Represents the pptx save options.
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.
QueryTable
Represents QueryTable information.
QueryTableCollection
A collection of QueryTableCollection objects that represent QueryTable collection information.
RadicalEquationNode
This class specifies the radical equation, consisting of an optional degree deg(EquationNodeType.Degree) and a base.
RadioButton
Represents a radio button.
RadioButtonActiveXControl
Represents a RadioButton ActiveX control.
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 area by the formula.
ReferredAreaCollection
Represents all referred cells and areas.
ReflectionEffect
This class specifies a reflection effect.
RenderingFont
Font for rendering.
RenderingWatermark
Watermark for rendering.
ReplaceOptions
Represent the replace options.
Revision
Represents the revision.
RevisionAutoFormat
represents a revision record of information about a formatting change.
RevisionCellChange
Represents the revision that changing cells.
RevisionCellComment
Represents a revision record of a cell comment change.
RevisionCellMove
Represents a revision record on a cell(s) that moved.
RevisionCollection
Represents all revision logs.
RevisionCustomView
Represents a revision record of adding or removing a custom view to the workbook
RevisionDefinedName
Represents a revision record of a defined name change.
RevisionFormat
Represents a revision record of information about a formatting change.
RevisionHeader
Represents a list of specific changes that have taken place for this workbook.
RevisionInsertDelete
Represents a revision record of a row/column insert/delete action.
RevisionInsertSheet
Represents a revision record of a sheet that was inserted.
RevisionLog
Represents the revision log.
RevisionLogCollection
Represents all revision logs.
RevisionMergeConflict
Represents a revision record which indicates that there was a merge conflict.
RevisionQueryTable
Represents a revision of a query table field change.
RevisionRenameSheet
Represents a revision of renaming sheet.
Row
Represents a single row in a worksheet.
RowCollection
Collects the Row objects that represent the individual rows in a worksheet.
SaveOptions
Represents all save options
Scenario
Represents an individual scenario.
ScenarioCollection
Represents the list of scenarios.
ScenarioInputCell
Represents input cell for the scenario.
ScenarioInputCellCollection
Represents the list of the scenario's input cells.
ScrollBar
Represents a scroll bar object.
ScrollBarActiveXControl
Represents the ScrollBar control.
Series
Encapsulates the object that represents a single data series in a chart.
SeriesCollection
Encapsulates a collection of Series objects.
SeriesLayoutProperties
Represents the properties of series layout.
SettableChartGlobalizationSettings
Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
SettableGlobalizationSettings
Implementation of GlobalizationSettings that supports user to set/change pre-defined texts.
SettablePivotGlobalizationSettings
Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
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.
ShapeGuide
Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
ShapeGuideCollection
Encapsulates a collection of shape guide
ShapePath
Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapePathCollection
Represents path collection information in NotPrimitive autoshape
ShapePathPoint
Represents an x-y coordinate within the path coordinate space.
ShapePathPointCollection
Represents all shape path points.
ShapePropertyCollection
This class specifies the visual shape properties for a chart element or shape.
ShapeSegmentPath
Represents a segment path in a path of the freeform.
ShapeSegmentPathCollection
Represents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapeTextAlignment
Represents the setting of shape's text alignment;
SheetPrintingPreview
Worksheet printing preview.
SheetRender
Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG, TIFF..) The constructor of this class , must be used after modification of pagesetup, cell style.
SheetSet
Describes a set of sheets.
SignatureLine
Represent the signature line.
Slicer
summary description of Slicer View
SlicerCache
summary description of slicer cache
SlicerCacheItem
Represent slicer data source item
SlicerCacheItemCollection
Represent the collection of SlicerCacheItem
SlicerCollection
Specifies the collection of all the Slicer objects on the specified worksheet.
SmartArtShape
Represents the smart art.
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.
SpinButtonActiveXControl
Represents the SpinButton control.
Spinner
Represents the Forms control: Spinner.
SpreadsheetML2003SaveOptions
Represents the options for saving Excel 2003 spreadml file.
SqlScriptColumnTypeMap
Represents column type map.
SqlScriptSaveOptions
Represents the options of saving sql.
Style
Represents display style of excel document,such as font,color,alignment,border,etc. The Style object contains all style attributes (font, number format, alignment, and so on) as properties.
StyleFlag
Represents flags which indicates applied formatting properties.
SubSupEquationNode
This class specifies an equation that can optionally be superscript or subscript. There are four main forms of this equation, superscript,subscript,superscript and subscript placed to the left of the base, superscript and subscript placed to the right of the base.
SubtotalSetting
Represents the setting of the subtotal .
SvgSaveOptions
Represents Svg save options. For advanced usage, please use WorkbookRender or SheetRender.
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.
TableToRangeOptions
Represents the options when converting table to range.
TextBox
Encapsulates the object that represents a textbox in a spreadsheet.
TextBoxActiveXControl
Represents a text box ActiveX control.
TextBoxCollection
Encapsulates a collection of TextBox objects.
TextEffectFormat
Contains properties and methods that apply to WordArt objects.
TextOptions
Represents the text options.
TextParagraph
Represents the text paragraph setting.
TextParagraphCollection
Represents all text paragraph.
TextRunEquationNode
This class in the equation node is used to store the actual content(a sequence of mathematical text) of the equation. Usually a node object per character.
TextTabStop
Represents tab stop.
TextTabStopCollection
Represents the list of all tab stops.
TextureFill
Encapsulates the object that represents texture fill format
ThemeColor
Represents a theme color.
ThreadedComment
Represents the threaded comment.
ThreadedCommentAuthor
Represents the person who creates the threaded comments;
ThreadedCommentAuthorCollection
Represents all persons who .
ThreadedCommentCollection
Represents the list of threaded comments.
ThreeDFormat
Represents a shape's three-dimensional formatting.
TickLabelItem
Represents a tick label in the chart.
TickLabels
Represents the tick-mark labels associated with tick marks on a chart axis.
TilePicOption
Represents tile picture as texture.
Timeline
Summary description of Timeline View Due to MS Excel, Excel 2003 does not support Timeline
TimelineCollection
Specifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not support Timeline.
Title
Encapsulates the object that represents the title of chart or axis.
ToggleButtonActiveXControl
Represents a ToggleButton ActiveX control.
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.
TwoColorGradient
Represents two color gradient.
TxtLoadOptions
Represents the options for loading text file.
TxtSaveOptions
Represents the save options for csv/tab delimited/other text format.
UnionRange
Represents union range.
UnknowEquationNode
Equation node class of unknown type
UnknownControl
Unknow control.
Validation
Represents data validation.settings.
ValidationCollection
Represents data validation collection.
VbaModule
Represents the module in VBA project.
VbaModuleCollection
Represents the list of VbaModule
VbaProject
Represents the VBA project.
VbaProjectReference
Represents the reference of VBA project.
VbaProjectReferenceCollection
Represents all references of VBA project.
VerticalPageBreak
Encapsulates the object that represents a vertical page break.
VerticalPageBreakCollection
Encapsulates a collection of VerticalPageBreak objects.
VmlShapeGuide
just for vml Encapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
Walls
Encapsulates the object that represents the walls of a 3-D chart.
WebExtension
Represents an Office Add-in instance.
WebExtensionBinding
Represents a binding relationship between an Office Add-in and the data in the document.
WebExtensionBindingCollection
Represents the list of binding relationships between an Office Add-in and the data in the document.
WebExtensionCollection
Represents the list of web extension.
WebExtensionProperty
Represents an Office Add-in custom property.
WebExtensionPropertyCollection
Represents the list of web extension properties.
WebExtensionReference
Represents identify the provider location and version of the extension.
WebExtensionReferenceCollection
Represents the list of web extension reference.
WebExtensionShape
Represents the shape of web extension.
WebExtensionTaskPane
Represents a persisted taskpane object.
WebExtensionTaskPaneCollection
Represents the list of task pane.
WebQueryConnection
Specifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HTTP "Get" parameters to be processed by the web server in generating the HTML by including the parameters and parameter elements.
Workbook
Represents a root object to create an Excel spreadsheet.
WorkbookDesigner
Encapsulates the object that represents a designer spreadsheet.
WorkbookMetadata
Represents the meta data.
WorkbookPrintingPreview
Workbook printing preview.
WorkbookRender
Represents a Workbook render. The constructor of this class , must be used after modification of pagesetup, cell style.
WorkbookSettings
Represents all settings of the workbook.
Worksheet
Encapsulates the object that represents a single worksheet.
WorksheetCollection
Encapsulates a collection of Worksheet objects.
WriteProtection
Specifies write protection settings for a workbook.
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.
XmlLoadOptions
Represents the options of loading xml.
XmlMap
Represents Xml map information.
XmlMapCollection
A collection of XmlMap objects that represent XmlMap information.
XmlSaveOptions
Represents the options of saving the workbook as an xml file.
XpsSaveOptions
Represents the additional options when saving the file as the Xps.
 

Constant Summary
AccessCacheOptions
Utility class containing constants. Cache options for data access. Can be combined with | operator for multiple options together.
AdjustFontSizeForRowType
Utility class containing constants. Represents which kind of rows should be ajusted.
AutoFillType
Utility class containing constants. Represents the auto fill type.
AutoFitMergedCellsType
Utility class containing constants. Represents the type of auto fitting merged cells.
AutoFitWrappedTextType
Utility class containing constants. Represents the type of auto fitting wrapped text.
AutoShapeType
Utility class containing constants. Represents all built-in auto shape type.
AxisType
Utility class containing constants. Represents the axis 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.
BevelType
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 built-in style types.
BulletType
Utility class containing constants. Represents the type of the bullet.
CalcModeType
Utility class containing constants. Represents the mode type of calculating formulas.
CalculationPrecisionStrategy
Utility class containing constants. Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result.
CategoryType
Utility class containing constants. Represents the category axis type.
CellBorderType
Utility class containing constants. Enumerates a cell's border type.
CellValueFormatStrategy
Utility class containing constants. Specifies how to apply style for the value of the cell.
CellValueType
Utility class containing constants. Specifies a cell value type.
ChartLineFormattingType
Utility class containing constants. Represents line format type of chart line.
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.
ChartTextDirectionType
Utility class containing constants. Represents the text direction type of the chart.
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.
ColorDepth
Utility class containing constants. Enumerates Bit Depth Type for tiff image.
ColorType
Utility class containing constants. Represents all color type
CommentTitleType
Utility class containing constants. Represents comment title type while rendering when comment is set to display at end of sheet.
ConsolidationFunction
Utility class containing constants. Represents consolidation function.
ControlBorderType
Utility class containing constants. Represents the border type of the ActiveX control.
ControlCaptionAlignmentType
Utility class containing constants. Represents the position of the Caption relative to the control.
ControlListStyle
Utility class containing constants. Represents the visual appearance of the list in a ListBox or ComboBox.
ControlMatchEntryType
Utility class containing constants. Represents how a ListBox or ComboBox searches its list as the user types.
ControlMousePointerType
Utility class containing constants. Represents the type of icon displayed as the mouse pointer for the control.
ControlPictureAlignmentType
Utility class containing constants. Represents the alignment of the picture inside the Form or Image.
ControlPicturePositionType
Utility class containing constants. Represents the location of the control's picture relative to its caption.
ControlPictureSizeMode
Utility class containing constants. Represents how to display the picture.
ControlScrollBarType
Utility class containing constants. Represents the type of scroll bar.
ControlScrollOrientation
Utility class containing constants. Represents type of scroll orientation
ControlSpecialEffectType
Utility class containing constants. Represents the type of special effect.
ControlType
Utility class containing constants. Represents all type of ActiveX control.
CopyFormatType
Utility class containing constants. Represents type of copying format when inserting rows.
CountryCode
Utility class containing constants. Represents Excel country identifiers.
CredentialsMethodType
Utility class containing constants. Specifies Credentials method used for server access.
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 type 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 positive data bars.
DataLabelShapeType
Utility class containing constants. Specifies the preset shape geometry that is to be used for a chart.
DataLabelsSeparatorType
Utility class containing constants. Represents the separator type of DataLabels.
DateTimeGroupingType
Utility class containing constants. Specifies how to group dateTime values.
DefaultEditLanguage
Utility class containing constants. Represents the default edit language.
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 of chart's axis.
DropButtonStyle
Utility class containing constants. Represents the symbol displayed on the drop button.
DynamicFilterType
Utility class containing constants. Dynamic filter type.
EmfRenderSetting
Utility class containing constants. Setting for rendering Emf metafile.
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.
EquationCharacterPositionType
Utility class containing constants. Specifies the position of a particular subobject within its parent
EquationCombiningCharacterType
Utility class containing constants. Type of combining characters.
EquationDelimiterShapeType
Utility class containing constants. This specifies the shape of delimiters in the delimiter object.
EquationFractionType
Utility class containing constants. This specifies the display style of the fraction bar.
EquationHorizontalJustificationType
Utility class containing constants. This specifies the default horizontal justification of equations in the document.
EquationLimitLocationType
Utility class containing constants. Specifies the limit location on an operator.
EquationMathematicalOperatorType
Utility class containing constants. Mathematical Operators Type
EquationNodeType
Utility class containing constants. Equation node type. Notice: (1)[1-99] Currently there is only one node in the scope, and its enumeration value is 1. The node it specifies is used to store mathematical text. (2)[100-199] Indicates that the node is a component of some special function nodes. (3)[200-] Indicates that the node has some special functions(Usually with 'Equation' suffix. 'EquationParagraph' is a special case.).
EquationVerticalJustificationType
Utility class containing constants. This specifies the default vertical justification of equations in the document.
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.
ExternalLinkType
Utility class containing constants. Represents the type of external link.
FileFormatType
Utility class containing constants. Represents the 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.
FontSchemeType
Utility class containing constants. Represents the scheme type of the font.
FontSourceType
Utility class containing constants. Specifies the type of a font source.
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.
GridlineType
Utility class containing constants. Enumerates grid line Type.
HeaderFooterCommandType
Utility class containing constants. Represents the command type of header and footer.
HtmlCrossType
Utility class containing constants. Represents five types of html cross string.
HtmlExportDataOptions
Utility class containing constants. Represents the options for exporting html data.
HtmlFormatHandlingType
Utility class containing constants. Specifies how to handle formatting from the HTML source
HtmlHiddenColDisplayType
Utility class containing constants. Represents two types of showing the hidden columns in html.
HtmlHiddenRowDisplayType
Utility class containing constants. Represents two types of showing the hidden rows in html.
HtmlLinkTargetType
Utility class containing constants. Represents the type of target attribute in HTML tag.
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.
ImageBinarizationMethod
Utility class containing constants. Specifies the method used to binarize image.
ImageType
Utility class containing constants. Specifies the type (format) of an image.
InputMethodEditorMode
Utility class containing constants. Represents the default run-time mode of the Input Method Editor.
JsonExportHyperlinkType
Utility class containing constants. Represents type of exporting hyperlinks to json.
LabelPositionType
Utility class containing constants. Represents data label position type.
LegendPositionType
Utility class containing constants. Enumerates the legend position types.
LightRigDirectionType
Utility class containing constants. Represents the light rig direction type.
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.
LineSpaceSizeType
Utility class containing constants. Represents the unit type of line space size.
LineType
Utility class containing constants. Enumerates the type of Picture border or Chart line.
LoadDataFilterOptions
Utility class containing constants. Represents the options to filter data when loading workbook from template.
LoadFormat
Utility class containing constants. Represents the load file format.
LoadNumbersTableType
Utility class containing constants. Indicates type of loading tables when some tables are in a sheet.
LookAtType
Utility class containing constants. Represents look at type.
LookInType
Utility class containing constants. Represents look in type.
MapChartLabelLayout
Utility class containing constants. Represents the layout of map chart's labels.
MapChartProjectionType
Utility class containing constants. Represents projection type of the map chart.
MapChartRegionType
Utility class containing constants. Represents the region type of the map chart.
MemorySetting
Utility class containing constants. Memory usage options.
MergeEmptyTdType
Utility class containing constants. Represents the merge type for empty TD element when exporting file to html.
MetadataType
Utility class containing constants. Represents the type of metadata.
MirrorType
Utility class containing constants. Represents mirror type of texture 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.
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.
NameScopeType
Utility class containing constants. Represents the scope type of defined names.
NumberCategoryType
Utility class containing constants. Represents category type of cell's number formatting.
OdsCellFieldType
Utility class containing constants. Represents the cell field type of ods.
OdsGeneratorType
Utility class containing constants. Represents the type of ODS generator.
OdsPageBackgroundGraphicPositionType
Utility class containing constants. Represents the position.
OdsPageBackgroundGraphicType
Utility class containing constants. Represents the type of formatting page background with image.
OdsPageBackgroundType
Utility class containing constants. Represents the page background type of ods.
OLEDBCommandType
Utility class containing constants. Specifies the OLE DB command type.
OoxmlCompliance
Utility class containing constants. Allows to specify which OOXML specification will be used when saving in the Xlsx format.
OoxmlCompressionType
Utility class containing constants. The Ooxml compression type
OpenDocumentFormatVersionType
Utility class containing constants. Open Document Format version type.
OperatorType
Utility class containing constants. Represents the operator type of conditional format and data validation.
PageLayoutAlignmentType
Utility class containing constants. Enumerates page layout alignment types.
PageOrientationType
Utility class containing constants. Represents print orientation constants.
PaneStateType
Utility class containing constants. Represents state of the sheet's pane.
PaperSizeType
Utility class containing constants. Represents paper size constants.
ParameterType
Utility class containing constants. Represents all parameters' type or return value type of function.
PasteOperationType
Utility class containing constants. Represents operation type when pasting range.
PasteType
Utility class containing constants. Represents the paste special type.
PdfCompliance
Utility class containing constants. Allowing user to set PDF conversion's Compatibility
PdfCompressionCore
Utility class containing constants. Specifies a type of compression applied to all content in the PDF file except images.
PdfCustomPropertiesExport
Utility class containing constants. Specifies the way CustomDocumentPropertyCollection are exported to PDF file.
PdfFontEncoding
Utility class containing constants. Represents pdf embedded font encoding.
PdfOptimizationType
Utility class containing constants. Specifies a type of optimization.
PivotAreaType
Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.
PivotConditionFormatRuleType
Utility class containing constants. Represents PivotTable condition formatting rule type.
PivotConditionFormatScopeType
Utility class containing constants. Represents PivotTable condition formatting scope type.
PivotFieldDataDisplayFormat
Utility class containing constants. Represents data display format in the PivotTable data field.
PivotFieldGroupType
Utility class containing constants. Represents the group type of pivot 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 group by 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.
PivotTableSelectionType
Utility class containing constants. Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
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.
PlotDataByType
Utility class containing constants. Represents the type of data plot by row or column.
PlotEmptyCellsType
Utility class containing constants. Represents all plot empty cells type of a chart.
PresetCameraType
Utility class containing constants. Represent different algorithmic methods for setting all camera properties, including position.
PresetMaterialType
Utility class containing constants. Describes surface appearance of a shape.
PresetShadowType
Utility class containing constants. Represents preset shadow type.
PresetThemeGradientType
Utility class containing constants. Represents the preset theme gradient type.
PresetWordArtStyle
Utility class containing constants. Represents the preset WordArt styles.
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.
QuartileCalculationType
Utility class containing constants. Represents quartile calculation methods.
ReConnectionMethodType
Utility class containing constants. Specifies what the spreadsheet application should do when a connection fails.
RectangleAlignmentType
Utility class containing constants. Represents how to position two rectangles relative to each other.
ReflectionEffectType
Utility class containing constants. Represents the effect type of reflection.
RenameStrategy
Utility class containing constants. Strategy option for duplicate names of columns.
ResourceLoadingType
Utility class containing constants. Represents how to loading the linked resource.
RevisionActionType
Utility class containing constants. Represents the type of revision action.
RevisionType
Utility class containing constants. Represents the revision type.
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.
ShapeAnchorType
Utility class containing constants. Represents the anchor type.
ShapeLockType
Utility class containing constants. Represents type of the property to be locked.
ShapePathType
Utility class containing constants. Represents path segment type.
SheetType
Utility class containing constants. Specifies the worksheet type.
ShiftType
Utility class containing constants. Represent the shift options when deleting a range of cells.
ShowDropButtonType
Utility class containing constants. Specifies when to show the drop button
SlicerCacheCrossFilterType
Utility class containing constants. Represent the type of SlicerCacheCrossFilterType
SlicerCacheItemSortType
Utility class containing constants. Specify the sort type of SlicerCacheItem
SlicerStyleType
Utility class containing constants. Specify the style of slicer view
SlideViewType
Utility class containing constants. Represents the type when exporting to slides.
SmartTagShowType
Utility class containing constants. Represents the show type of the smart tag.
SortOnType
Utility class containing constants. Sorted value type.
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.
SqlDataType
Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.
SqlScriptOperatorType
Utility class containing constants. Represents the type of operating data.
StyleModifyFlag
Utility class containing constants. The style modified flags.
TableDataSourceType
Utility class containing constants. Represents the table's data source type.
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.
TargetModeType
Utility class containing constants. Represents the type of target mode.
TextAlignmentType
Utility class containing constants. Enumerates text alignment types.
TextAutonumberScheme
Utility class containing constants. Represents all automatic number scheme.
TextCapsType
Utility class containing constants. This type specifies the cap types of the text.
TextCrossType
Utility class containing constants. Enumerates displaying text type when the text width is larger than cell width.
TextDirectionType
Utility class containing constants. Represents the direction of the text flow for this paragraph.
TextFontAlignType
Utility class containing constants. Represents the different types of font alignment.
TextNodeType
Utility class containing constants. Represents the node type.
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.
TextTabAlignmentType
Utility class containing constants. Represents the text tab alignment types.
TextureType
Utility class containing constants. Represents the preset texture type.
TextVerticalType
Utility class containing constants. Represents the text direct type.
ThemeColorType
Utility class containing constants. Enumerates the theme color types.
TickLabelAlignmentType
Utility class containing constants. Represents the text alignment type for the tick labels on the axis
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.
TxtLoadStyleStrategy
Utility class containing constants. Specifies how to apply style for parsed values when converting string value to number or datetime.
TxtValueQuoteType
Utility class containing constants. Specifies the type of using quotation marks for values in text format files.
UpdateLinksType
Utility class containing constants. Represents how to update links to other workbooks when the workbook is opened.
ValidationAlertType
Utility class containing constants. Represents the data validation alert style.
ValidationType
Utility class containing constants. Represents data validation type.
VbaModuleType
Utility class containing constants. Represents the type of VBA module.
VbaProjectReferenceType
Utility class containing constants. Represents the type of VBA project reference.
ViewType
Utility class containing constants. Represents the view type of the worksheet.
VisibilityType
Utility class containing constants. Represents the states for sheet visibility.
WebExtensionStoreType
Utility class containing constants. Represents the store type of web extension.
WeightType
Utility class containing constants. Enumerates the weight types for a picture border or a chart line.
XAdESType
Utility class containing constants. Type of XML Advanced Electronic Signature (XAdES).