All Classes

All Constants

Package com.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.
AbstractCalculationEngine
Represents user's custom calculation engine to extend the default calculation engine of Aspose.Cells.
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.
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
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 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.
CellsFactory
Represents the factory of the cells's classes
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.
ChartTextFrame
Encapsulates the object that represents the frame object which contains text.
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.
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
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.
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.
CustomGeometry
Represents a custom geometric shape.
CustomProperty
Represents identifier information.
CustomPropertyCollection
A collection of CustomProperty objects that represent additional information.
CustomXmlPart
Represents a InnerCustom XML Data Storage Part (custom XML data within a package).
CustomXmlPartCollection
Represents a InnerCustom XML Data Storage Part (custom XML data within a package).
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
Represents the datetime's group setting.
DBConnection
Specifies all properties associated with an ODBC or OLE DB external data connection.
DeleteOptions
Represents the setting of deleting rows/columns.
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
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.
DxfCollection
Represents the master differential formatting records.
DynamicFilter
Represents the dynamic filter.
Encoding
Represents a character 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.
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.
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.
Geometry
Represents a geometric shape.
GlobalizationSettings
Repsents 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.
GroupFill
Represents this fill format should inherit the fill properties of the group.
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
Represents icon filter.
IconSet
Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
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
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.
LineFormat
Represents all setting of the line.
LineShape
Represents the line shape.
ListBox
Represents a list box object.
ListColumn
Represents a column in a list.
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.
ListObjectImp
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.
LoadDataOption
The load data options.
LoadFilter
Represents the filter that provides options for loading data when loading workbook from template.
LoadOptions
Represents the options of loading the file.
Marker
Represents the marker in a line chart, scatter chart, or radar chart.
MemoryFontSource
Represents the single TrueType font file stored in memory.
Metered
Provides methods to set metered key.
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.
MsoLineFormatHelper
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.
NoneFill
Represents no fill.
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.
PdfSaveOptions
Represents the options for saving pdf file.
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.
RangeImp
Encapsulates the object that represents a range of cells within a spreadsheet.
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.
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
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.
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.
ShapeFormat
Represents the format of the shape or text.
ShapeGuide
Encapsulates a shape guide specifies the precense of a shape guide that will be used to govern the geometry of the specifiedshape
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.
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.
SignatureLine
Represent the singature line.
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.
SvgSaveOptions
Represents Svg save options
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.
ThreeDFormat
Represents a shape's three-dimensional formatting.
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.
VbaModule
Represents module that is contained in VBA project.
VbaModuleCollection
Represents the list of VbaModule
VbaProject
Represents the VBA project.
VbaProjectReference
Represents the refernece of VBA project.
VbaProjectReferenceCollection
Represents all referneces of VBA project.
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.
WarningInfo
Warning info
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.
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.
XmlMap
Represents Xml map information.
XmlMapCollection
A collection of XmlMap objects that represent XmlMap information.
XpsSaveOptions
Represents the additional options when saving the file as the Xps.
 

Interface Summary
ICellsDataTable
Represents data table.
ICustomFunction
Allows users to add their custom formula calculation functions to extend the calculation engine.
ICustomParser
Allows users to add their custom value parser for parsing string values to other proper cell value object.
IExportObjectListener
Allows users to manipulate objects while exporting.
IFilePathProvider
Represents the exported file path provider.
ISmartMarkerCallBack
Represents callback interface of processing smartmarker.
IStreamProvider
Represents the exported stream provider.
IWarningCallback
Callback interface of warning.
LightCellsDataHandler
Represents cells data handler for reading large spreadsheet files in light weight mode.
LightCellsDataProvider
Represents Data provider for saving large spreadsheet files in light weight mode.
 

Constant Summary
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 builin style type
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 calcualted as the expected result. Such as formula "=-0.45+0.43+0.02", when calcuating 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. Rerepsents 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.
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. Represents all color type
ConnectionDataSourceType
Utility class containing constants. Specifies external database source type
ConnectionParameterType
Utility class containing constants. Specifies the parameter type of external connnection
ConsolidationFunction
Utility class containing constants. Represents consolidation function.
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 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. InnerCustom Filter operator type.
FilterType
Utility class containing constants. The filter type.
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.
HeaderFooterCommandType
Utility class containing constants. Represents the command type of header and footer.
HtmlCrossType
Utility class containing constants. Represents three types of html corss 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 col in html.
HtmlHiddenRowDisplayType
Utility class containing constants. Represents two types of showing the hidden row 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.
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. Repesents 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.
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.
LookAtType
Utility class containing constants. Represents look at type.
LookInType
Utility class containing constants. Represents look in type.
MemorySetting
Utility class containing constants. Memory usage options.
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.
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.
OLEDBCommandType
Utility class containing constants. Specifies the OLE DB command type.
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. Represents all parameters' type or return value type of function.
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.
PdfOptimizationType
Utility class containing constants. Specifies a type of optimization.
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.
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.
PivotOptions
Utility class containing constants. Represents a complex type that specifies the pivot controls that appear on the chart
PivotTableAutoFormatType
Utility class containing constants. Represents PivotTable auto format 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.
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.
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.
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.
RenameStrategy
Utility class containing constants. Renames strategy when columns contains the duplicate names.
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.
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.
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.
SqlDataType
Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.
StyleModifyFlag
Utility class containing constants. The style mofied 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.
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 the direction of the text flow for this paragraph.
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.
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.
WarningType
Utility class containing constants. WaringType
WeightType
Utility class containing constants. Enumerates the weight types for a picture border or a chart line.