Aspose.Cells for Node.js via C++

Classes

ClassDescription
AboveAverageDescribe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range.
AbstractCalculationEngineRepresents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.
AbstractInterruptMonitorMonitor for interruption requests in all time-consuming operations.
AbstractTextLoadOptionsCommon options for loading text values
AccentEquationNodeThis class specifies an accent equation, consisting of a base component and a combining diacritic.
ActiveXControlRepresents the ActiveX control.
ActiveXControlBaseRepresents the ActiveX control.
AdvancedFilterRepresents the settings of advanced filter.
ArcShapeRepresents the arc shape.
AreaEncapsulates the object that represents an area format.
ArrayEquationNodeSpecifies the Equation-Array function, an object consisting of one or more equations.
AutoFilterRepresents autofiltering for the specified worksheet.
AutoFitterOptionsRepresents all auto fitter options.
AutomaticFillrepresents automatic fill.
AutoNumberedBulletValueRepresents automatic numbered bullet.
AxisEncapsulates the object that represents an axis of chart.
AxisBinsRepresents axis bins
BarEquationNodeThis class specifies the bar equation, consisting of a base argument and an overbar or underbar.
BaseShapeGuideRepresents the shape guide.
BevelRepresents a bevel of a shape
BorderEncapsulates the object that represents the cell border.
BorderBoxEquationNodeThis class specifies the Border Box function, consisting of a border drawn around an equation.
BorderCollectionEncapsulates a collection of Border objects.
BoxEquationNodeThis class specifies the box function, which is used to group components of an equation.
BuiltInDocumentPropertyCollectionA collection of built-in document properties.
BulletRepresents the bullet points should be applied to a paragraph.
BulletValueRepresents the value of the bullet.
ButtonRepresents the Forms control: Button
CalculationCellRepresents the calculation relevant data about one cell which is being calculated.
CalculationDataRepresents the required data when calculating one function, such as function name, parameters, …etc.
CalculationOptionsRepresents options for calculation.
CellEncapsulates the object that represents a single Workbook cell.
CellAreaRepresent an area of cells.
CellRichValueRepresents rich value of the cell.
CellsEncapsulates a collection of cell relevant objects, such as Cell, Row, …etc.
CellsColorRepresents all types of color.
CellsDrawingRepresents the auto shape and drawing object.
CellsFactoryUtility for instantiating classes of Cells model.
CellsHelperProvides helper functions.
CellValueRepresents the cell value and corresponding type.
CellWatchRepresents Cell Watch Item in the ‘watch window’.
CellWatchCollectionRepresents the collection of cells on this worksheet being watched in the ‘watch window’.
CharacterBulletValueRepresents the character bullet.
ChartEncapsulates the object that represents a single Excel chart.
ChartAreaEncapsulates the object that represents the chart area in the worksheet.
ChartCalculateOptionsRepresents the options for calculating chart.
ChartCollectionEncapsulates a collection of Chart objects.
ChartDataTableRepresents a chart data table.
ChartFrameEncapsulates the object that represents the frame object in a chart.
ChartGlobalizationSettingsRepresents the globalization settings for chart.
ChartPointRepresents a single point in a series in a chart.
ChartPointCollectionRepresents a collection that contains all the points in one series.
ChartShapeRepresents the shape of the chart. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the worksheet.
ChartTextFrameEncapsulates the object that represents the frame object which contains text.
CheckBoxRepresents a check box object in a worksheet.
CheckBoxActiveXControlRepresents a CheckBox ActiveX control.
CheckBoxCollectionRepresents a collection of CheckBox objects in a worksheet.
ColorRepresents an ARGB (alpha, red, green, blue) color.
ColorFilterRepresents filtering the range by color.
ColorHelperProvides helper functions about color.
ColorScaleDescribe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.
ColumnRepresents a single column in a worksheet.
ColumnCollectionCollection 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.
ComboBoxRepresents the control form ComboBox.
ComboBoxActiveXControlRepresents a ComboBox ActiveX control.
CommandButtonActiveXControlRepresents a command button.
CommentEncapsulates the object that represents a cell comment.
CommentCollectionEncapsulates a collection of Comment objects.
CommentShapeRepresents the shape of the comment.
ConditionalFormattingCollectionEncapsulates a collection of FormatCondition objects.
ConditionalFormattingIconRepresents the custom icon of conditional formatting rule.
ConditionalFormattingIconCollectionRepresents a collection of ConditionalFormattingIcon objects.
ConditionalFormattingResultRepresents the result of conditional formatting which applies to a cell.
ConditionalFormattingValueDescribes the values of the interpolation points in a gradient scale, dataBar or iconSet.
ConditionalFormattingValueCollectionDescribes a collection of CFValueObject. Use only for icon sets.
ConnectionParameterSpecifies properties about any parameters used with external data connections Parameters are valid for ODBC and web queries.
ConnectionParameterCollectionSpecifies the ConnectionParameter collection
ContentTypePropertyRepresents identifier information.
ContentTypePropertyCollectionA collection of ContentTypeProperty objects that represent additional information.
ConversionUtilityRepresents utility to convert files to other formats.
CopyOptionsRepresents the copy options.
CustomDocumentPropertyCollectionA collection of custom document properties.
CustomFilterRepresents the custom filter.
CustomFilterCollectionRepresents the custom filters.
CustomFunctionDefinitionDefinition of custom function for calculating with user’s custom engine.
CustomGeometryRepresents a custom geometric shape.
CustomPiovtFieldGroupItemRepresents an item of custom grouped field.
CustomPropertyRepresents identifier information.
CustomPropertyCollectionA collection of CustomProperty objects that represent additional information.
CustomXmlPartRepresents a Custom XML Data Storage Part (custom XML data within a package).
CustomXmlPartCollectionRepresents a Custom XML Data Storage Part (custom XML data within a package).
CustomXmlShapeRepresents Custom xml shape ,such as Ink.
DataBarDescribe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells.
DataBarBorderRepresents the border of the data bars specified by a conditional formatting rule.
DataLabelsEncapsulates a collection of all the DataLabel objects for the specified Series.
DataMashupRepresents mashup data.
DataModelRepresents the data model.
DataModelConnectionSpecifies a data model connection
DataModelRelationshipRepresents a single relationship in the spreadsheet data model.
DataModelRelationshipCollectionRepresents the relationships.
DataModelTableRepresents properties of a single table in spreadsheet data model.
DataModelTableCollectionRepresents the list of the data model table.
DataSorterSummary description for DataSorter.
DataSorterKeyRepresents the key of the data sorter.
DataSorterKeyCollectionRepresents the key list of data sorter.
DateTimeGroupItemRepresents the datetime’s group setting.
DBConnectionSpecifies all properties associated with an ODBC or OLE DB external data connection.
DefaultStyleSettingsSettings for the default values of workbook’s style properties.
DeleteBlankOptionsRepresents the setting of deleting blank cells/rows/columns.
DeleteOptionsRepresents the setting of deleting rows/columns.
DelimiterEquationNodeThis 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.
Dialog_BoxRepresents the dialog box.
DifSaveOptionsRepresents the options of saving dif file.
DigitalSignatureSignature in file.
DigitalSignatureCollectionProvides a collection of digital signatures attached to a document.
DisplayUnitLabelRepresents the display unit label.
DocumentPropertyRepresents a custom or built-in document property.
DocumentPropertyCollectionBase class for BuiltInDocumentPropertyCollection and CustomDocumentPropertyCollection collections.
DocxSaveOptionsRepresents options of saving .docx file.
DrawObjectDrawObject will be initialized and returned when rendering.
DrawObjectEventHandlerInterface to get DrawObject and Bound when rendering.
DropBarsRepresents the up/down bars in a chart.
DxfCollectionRepresents the master differential formatting records.
DynamicFilterRepresents the dynamic filter.
EbookLoadOptionsRepresents options when importing an ebook file.
EbookSaveOptionsRepresents the options for saving ebook file.
EquationComponentNodeThis 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’.
EquationNodeAbstract class for deriving other equation nodes.
EquationNodeParagraphThis class specifies a mathematical paragraph containing one or more MathEquationNode(OMath) elements.
ErrorBarRepresents error bar of data series.
ErrorCheckOptionError check setting applied on certain ranges.
ErrorCheckOptionCollectionRepresents all error check option.
ExportRangeToJsonOptionsIndicates the options that exporting range to json.
ExternalConnectionSpecifies an external data connection
ExternalConnectionCollectionSpecifies the ExternalConnection collection
ExternalLinkRepresents an external link in a workbook.
ExternalLinkCollectionRepresents external links collection in a workbook.
FileFontSourceRepresents the single TrueType font file stored in the file system.
FileFormatInfoContains data returned by FileFormatUtil file format detection methods.
FileFormatUtilProvides utility methods for converting file format enums to strings or file extensions and back.
FillFormatEncapsulates the object that represents fill formatting for a shape.
FilterColumnRepresents a filter for a single column. The Filter object is a member of the Filters collection
FilterColumnCollectionA collection of Filter objects that represents all the filters in an autofiltered range.
FindOptionsRepresents find options.
FloorEncapsulates the object that represents the floor of a 3-D chart.
FolderFontSourceRepresents the folder that contains TrueType font files.
FontEncapsulates the font object used in a spreadsheet.
FontConfigsSpecifies font settings
FontSettingRepresents a range of characters within the cell text.
FontSettingCollectionRepresents the list of FontSetting.
FontSourceBaseThis is an abstract base class for the classes that allow the user to specify various font sources
Format3DThis class specifies the 3D shape properties for a chart element or shape.
FormatConditionRepresents conditional formatting condition.
FormatConditionCollectionRepresents conditional formatting. The FormatConditions can contain up to three conditional formats.
FormulaParseOptionsRepresents options when parsing formula.
FormulaSettingsSettings of formulas and calculation.
FractionEquationNodeThis 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.
FunctionEquationNodeThis 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.
GeometryRepresents a geometric shape.
GlobalizationSettingsRepresents the globalization settings.
GlowEffectThis class specifies a glow effect, in which a color blurred outline is added outside the edges of the object.
GradientFillRepresents the gradient fill.
GradientStopRepresents the gradient stop.
GradientStopCollectionRepresents the gradient stop collection.
GroupBoxEncapsulates the object that represents a groupbox in a spreadsheet.
GroupCharacterEquationNodeThis class specifies the Group-Character function, consisting of a character drawn above or below text, often with the purpose of visually grouping items.
GroupFillRepresents this fill format should inherit the fill properties of the group.
GroupShapeRepresents the group shape which contains the individual shapes.
HeaderFooterCommandRepresents the command of header/footer
HighlightChangesOptionsRepresents options of highlighting revsions or changes of shared Excel files.
HorizontalPageBreakEncapsulates the object that represents a horizontal page break.
HorizontalPageBreakCollectionEncapsulates a collection of HorizontalPageBreak objects.
HtmlLoadOptionsRepresents options when importing a html file.
HtmlSaveOptionsRepresents the options for saving html file.
HtmlTableLoadOptionRepresents the option when import table from html.
HtmlTableLoadOptionCollectionRepresents the table options when importing html.
HyperlinkEncapsulates the object that represents a hyperlink.
HyperlinkCollectionEncapsulates a collection of Hyperlink objects.
IconFilterRepresents icon filter.
IconSetDescribe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
ImageActiveXControlRepresents the image control.
ImageOrPrintOptionsAllows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
ImageSaveOptionsRepresents image save options. For advanced usage, please use WorkbookRender or SheetRender.
ImportTableOptionsRepresents the options of importing data into cells.
IndividualFontConfigsFont configs for each Workbook object.
InsertOptionsRepresents the options of inserting.
InterruptMonitorRepresents all operator about the interrupt.
JsonLayoutOptionsRepresents the options of json layout type.
JsonLoadOptionsRepresents the options of loading json files
JsonSaveOptionsRepresents the options of saving the workbook as a json file.
JsonUtilityRepresents the utility class of processing json.
LabelEncapsulates the object that represents a label in a spreadsheet.
LabelActiveXControlRepresents the label ActiveX control.
LegendEncapsulates the object that represents the chart legend.
LegendEntryRepresents a legend entry in a chart legend.
LegendEntryCollectionRepresents a collection of all the LegendEntry objects in the specified chart legend.
LicenseProvides methods to license the component.
LimLowUppEquationNodeThis class specifies the limit function.
LineEncapsulates the object that represents the line format.
LineFormatRepresents all setting of the line.
LineShapeRepresents the line shape.
ListBoxRepresents a list box object.
ListBoxActiveXControlRepresents a ListBox ActiveX control.
ListColumnRepresents a column in a Table.
ListColumnCollectionRepresents A collection of all the ListColumn objects in the specified ListObject object.
ListObjectRepresents 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.
ListObjectCollectionRepresents a collection of ListObject objects in the worksheet.
LoadFilterRepresents the filter that provides options for loading data when loading workbook from template.
LoadOptionsRepresents the options of loading the file.
MarkdownSaveOptionsRepresents the save options for markdown.
MarkerRepresents the marker in a line chart, scatter chart, or radar chart.
MathematicalEquationNodeThis class specifies an equation or mathematical expression. All mathematical text of equations or mathematical expressions are contained by this class.
MatrixEquationNodeThis class specifies the Matrix equation, consisting of one or more elements laid out in one or more rows and one or more columns.
MemoryFontSourceRepresents the single TrueType font file stored in memory.
MetadataOptionsRepresents the options of loading metadata of the file.
MsoFillFormatRepresents fill formatting for a shape.
MsoFillFormatHelperRepresents fill formatting for a shape.
MsoFormatPictureRepresents the picture format.
MsoLineFormatRepresents line and arrowhead formatting.
MsoLineFormatHelperRepresents line and arrowhead formatting.
MsoTextFrameRepresents the text frame in a Shape object.
MultipleFilterCollectionRepresents the multiple filter collection.
NameRepresents a defined name for a range of cells.
NameCollectionRepresents a collection of all the Name objects in the spreadsheet.
NaryEquationNodeThis class specifies an n-ary operator equation consisting of an n-ary operator, a base (or operand), and optional upper and lower bounds.
NegativeBarFormatRepresents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
NoneBulletValueRepresents no bullet.
NoneFillRepresents no fill.
NumbersLoadOptionsRepresents the options of loading Apple Numbers files.
ObjectObject class.
OdsCellFieldRepresents the cell field of ods.
OdsCellFieldCollectionRepresents the fields of ODS.
OdsLoadOptionsRepresents the options of loading ods file.
OdsPageBackgroundRepresents the page background of ods.
OdsSaveOptionsRepresents the options of saving ods file.
OleObjectRepresents an OleObject in a worksheet.
OleObjectCollectionRepresents embedded OLE objects.
OoxmlSaveOptionsRepresents the options of saving office open xml file.
OutlineRepresents an outline on a worksheet.
OvalRepresents the oval shape.
PageEndSavingArgsInfo for a page ends saving process.
PageSavingArgsInfo for a page saving process.
PageSetupEncapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.
PageStartSavingArgsInfo for a page starts saving process.
PaginatedSaveOptionsRepresents the options for pagination.
PaneCollectionRepresents all Pane objects shown in the specified window.
PasteOptionsRepresents the paste special options.
PatternFillEncapsulates the object that represents pattern fill format
PclSaveOptionsRepresents the options for saving Pcl file.
PdfBookmarkEntryPdfBookmarkEntry 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.
PdfSaveOptionsRepresents the options for saving pdf file.
PdfSecurityOptionsOptions for encrypting and access permissions for a PDF document. PDF/A does not allow security setting.
PicFormatOptionRepresents picture format option
PictureEncapsulates the object that represents a single picture in a spreadsheet.
PictureBulletValueRepresents the value of the image bullet.
PictureCollectionEncapsulates a collection of Picture objects.
PivotAreaPresents the selected area of the PivotTable.
PivotAreaFilterRepresents the filter of PivotArea for PivotTable.
PivotAreaFilterCollectionRepresents the list of filters for PivotArea
PivotDateTimeRangeGroupSettingsRepresents the field grouped by date time range.
PivotDiscreteGroupSettingsRrepsents the discrete group of pivot field
PivotFieldRepresents a field in a PivotTable report.
PivotFieldCollectionRepresents a collection of all the PivotField objects in the PivotTable’s specific PivotFields type.
PivotFieldGroupSettingsRepresents the group setting of pivot field.
PivotFieldSortSettingRepresents the setting of sorting pivot fields.
PivotFilterRepresents a PivotFilter in PivotFilter Collection.
PivotFilterCollectionRepresents a collection of all the PivotFilter objects
PivotFormatConditionRepresents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotFormatConditionCollectionRepresents PivotTable Format Conditions.
PivotGlobalizationSettingsRepresents the globalization settings for pivot tables.
PivotItemRepresents a item in a PivotField report.
PivotItemCollectionRepresents all the PivotItem objects in the PivotField.
PivotNumbericRangeGroupSettingsRepresents the numberic range group of the pivot field.
PivotOptionsRepresents a complex type that specifies the pivot controls that appear on the chart
PivotPageFieldsRepresents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.
PivotShowValuesSettingRepresents the settings about showing values as when the ShowDataAs calculation is in use.
PivotTableSummary description for PivotTable.
PivotTableCalculateOptionRerepsents the options of calcuating the pivot table.
PivotTableCollectionRepresents the collection of all the PivotTable objects on the specified worksheet.
PivotTableFormatRepresents the format defined in the PivotTable.
PivotTableFormatCollectionRepresents the collection of formats applied to PivotTable.
PivotTableRefreshOptionRepresents the options of refreshing data source of the pivot table.
PlotAreaEncapsulates the object that represents the plot area in a chart.
PowerQueryFormulaRepresents the definition of power query formula.
PowerQueryFormulaCollectionRepresents all power query formulas in the mashup data.
PowerQueryFormulaFunctionRepresents the function of power query.
PowerQueryFormulaItemRepresents the item of the power query formula.
PowerQueryFormulaItemCollectionRepresents all item of the power query formula.
PowerQueryFormulaParameterRepresents the parameter of power query formula.
PowerQueryFormulaParameterCollectionRepresents the parameters of power query formula.
PptxSaveOptionsRepresents the pptx save options.
ProtectedRangeA specified range to be allowed to edit when the sheet protection is ON.
ProtectedRangeCollectionEncapsulates a collection of ProtectedRange objects.
ProtectionRepresents the various types of protection options available for a worksheet.
QueryTableRepresents QueryTable information.
QueryTableCollectionA collection of QueryTableCollection objects that represent QueryTable collection information.
RadicalEquationNodeThis class specifies the radical equation, consisting of an optional degree deg(EquationNodeType.Degree) and a base.
RadioButtonRepresents a radio button.
RadioButtonActiveXControlRepresents a RadioButton ActiveX control.
RangeEncapsulates the object that represents a range of cells within a spreadsheet.
RangeCollectionEncapsulates a collection of Range objects.
RectangleShapeRepresents the rectangle shape.
ReferredAreaRepresents a referred area by the formula.
ReferredAreaCollectionRepresents all referred cells and areas.
ReflectionEffectThis class specifies a reflection effect.
RenderingFontFont for rendering.
RenderingWatermarkWatermark for rendering.
ReplaceOptionsRepresent the replace options.
RevisionRepresents the revision.
RevisionAutoFormatrepresents a revision record of information about a formatting change.
RevisionCellChangeRepresents the revision that changing cells.
RevisionCellCommentRepresents a revision record of a cell comment change.
RevisionCellMoveRepresents a revision record on a cell(s) that moved.
RevisionCollectionRepresents all revision logs.
RevisionCustomViewRepresents a revision record of adding or removing a custom view to the workbook
RevisionDefinedNameRepresents a revision record of a defined name change.
RevisionFormatRepresents a revision record of information about a formatting change.
RevisionHeaderRepresents a list of specific changes that have taken place for this workbook.
RevisionInsertDeleteRepresents a revision record of a row/column insert/delete action.
RevisionInsertSheetRepresents a revision record of a sheet that was inserted.
RevisionLogRepresents the revision log.
RevisionLogCollectionRepresents all revision logs.
RevisionMergeConflictRepresents a revision record which indicates that there was a merge conflict.
RevisionQueryTableRepresents a revision of a query table field change.
RevisionRenameSheetRepresents a revision of renaming sheet.
RowRepresents a single row in a worksheet.
RowCollectionCollects the Row objects that represent the individual rows in a worksheet.
SaveOptionsRepresents all save options
ScenarioRepresents an individual scenario.
ScenarioCollectionRepresents the list of scenarios.
ScenarioInputCellRepresents input cell for the scenario.
ScenarioInputCellCollectionRepresents the list of the scenario’s input cells.
ScrollBarRepresents a scroll bar object.
ScrollBarActiveXControlRepresents the ScrollBar control.
SeriesEncapsulates the object that represents a single data series in a chart.
SeriesCollectionEncapsulates a collection of Series objects.
SeriesLayoutPropertiesRepresents the properties of series layout.
SettableChartGlobalizationSettingsImplementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
SettableGlobalizationSettingsImplementation of GlobalizationSettings that supports user to set/change pre-defined texts.
SettablePivotGlobalizationSettingsImplementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
ShadowEffectThis class specifies the shadow effect of the chart element or shape.
ShapeRepresents the msodrawing object.
ShapeCollectionRepresents all the shape in a worksheet/chart.
ShapeGuideEncapsulates a shape guide specifies the presence of a shape guide that will be used to govern the geometry of the specified shape
ShapeGuideCollectionEncapsulates a collection of shape guide
ShapePathRepresents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapePathCollectionRepresents path collection information in NotPrimitive autoshape
ShapePathPointRepresents an x-y coordinate within the path coordinate space.
ShapePathPointCollectionRepresents all shape path points.
ShapePropertyCollectionThis class specifies the visual shape properties for a chart element or shape.
ShapeSegmentPathRepresents a segment path in a path of the freeform.
ShapeSegmentPathCollectionRepresents a creation path consisting of a series of moves, lines and curves that when combined will form a geometric shape.
ShapeTextAlignmentRepresents the setting of shape’s text alignment;
SheetPrintingPreviewWorksheet printing preview.
SheetRenderRepresents 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.
SheetSetDescribes a set of sheets.
SignatureLineRepresent the signature line.
Slicersummary description of Slicer View
SlicerCacheRepresent summary description of slicer cache
SlicerCacheItemRepresent slicer data source item
SlicerCacheItemCollectionRepresent the collection of SlicerCacheItem
SlicerCollectionSpecifies the collection of all the Slicer objects on the specified worksheet.
SmartArtShapeRepresents the smart art.
SmartTagRepresents a smart tag.
SmartTagCollectionRepresents all smart tags in the cell.
SmartTagOptionsRepresents the options of the smart tag.
SmartTagPropertyRepresents the property of the cell smart tag.
SmartTagPropertyCollectionRepresents all properties of cell smart tag.
SmartTagSettingRepresents all SmartTagCollection object in the worksheet.
SolidFillEncapsulates the object that represents solid fill format
SparklineA sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineCollectionEncapsulates a collection of Sparkline objects.
SparklineGroupSparkline 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.
SparklineGroupCollectionEncapsulates a collection of SparklineGroup objects.
SpinButtonActiveXControlRepresents the SpinButton control.
SpinnerRepresents the Forms control: Spinner.
SpreadsheetML2003SaveOptionsRepresents the options for saving Excel 2003 spreadml file.
SqlScriptColumnTypeMapRepresents column type map.
SqlScriptSaveOptionsRepresents the options of saving sql.
StyleRepresents 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.
StyleFlagRepresents flags which indicates applied formatting properties.
SubSupEquationNodeThis 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.
SubtotalSettingRepresents the setting of the subtotal .
SystemTimeInterruptMonitorSimple implementation of AbstractInterruptMonitor by checking and comparing current system time with user specified limit.
TableStyleRepresents the table style.
TableStyleCollectionRepresents all custom table styles.
TableStyleElementRepresents the element of the table style.
TableStyleElementCollectionRepresents all elements of the table style.
TableToRangeOptionsRepresents the options when converting table to range.
TextBoxEncapsulates the object that represents a textbox in a spreadsheet.
TextBoxActiveXControlRepresents a text box ActiveX control.
TextBoxCollectionEncapsulates a collection of TextBox objects.
TextBoxOptionsRepresents the text options of the shape
TextEffectFormatContains properties and methods that apply to WordArt objects.
TextOptionsRepresents the text options.
TextParagraphRepresents the text paragraph setting.
TextParagraphCollectionRepresents all text paragraph.
TextRunEquationNodeThis 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.
TextTabStopRepresents tab stop.
TextTabStopCollectionRepresents the list of all tab stops.
TextureFillEncapsulates the object that represents texture fill format
ThemeColorRepresents a theme color.
ThreadedCommentRepresents the threaded comment.
ThreadedCommentAuthorRepresents the person who creates the threaded comments;
ThreadedCommentAuthorCollectionRepresents all persons who .
ThreadedCommentCollectionRepresents the list of threaded comments.
ThreeDFormatRepresents a shape’s three-dimensional formatting.
TickLabelItemRepresents a tick label in the chart.
TickLabelsRepresents the tick-mark labels associated with tick marks on a chart axis.
TilePicOptionRepresents tile picture as texture.
TimelineSummary description of Timeline View Due to MS Excel, Excel 2003 does not support Timeline
TimelineCollectionSpecifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not support Timeline.
TitleEncapsulates the object that represents the title of chart or axis.
ToggleButtonActiveXControlRepresents a ToggleButton ActiveX control.
Top10Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
Top10FilterRepresents the top 10 filter.
TrendlineRepresents a trendline in a chart.
TrendlineCollectionRepresents a collection of all the Trendline objects for the specified data series.
TwoColorGradientRepresents two color gradient.
TxtLoadOptionsRepresents the options for loading text file.
TxtSaveOptionsRepresents the save options for csv/tab delimited/other text format.
UnionRangeRepresents union range.
UnknowEquationNodeEquation node class of unknown type
UnknownControlUnknow control.
ValidationRepresents data validation.settings.
ValidationCollectionRepresents data validation collection.
VbaModuleRepresents the module in VBA project.
VbaModuleCollectionRepresents the list of VbaModule
VbaProjectRepresents the VBA project.
VbaProjectReferenceRepresents the reference of VBA project.
VbaProjectReferenceCollectionRepresents all references of VBA project.
VerticalPageBreakEncapsulates the object that represents a vertical page break.
VerticalPageBreakCollectionEncapsulates a collection of VerticalPageBreak objects.
VmlShapeGuidejust 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
WallsEncapsulates the object that represents the walls of a 3-D chart.
WarningInfoWarning info
WebExtensionRepresents an Office Add-in instance.
WebExtensionBindingRepresents a binding relationship between an Office Add-in and the data in the document.
WebExtensionBindingCollectionRepresents the list of binding relationships between an Office Add-in and the data in the document.
WebExtensionCollectionRepresents the list of web extension.
WebExtensionPropertyRepresents an Office Add-in custom property.
WebExtensionPropertyCollectionRepresents the list of web extension properties.
WebExtensionReferenceRepresents identify the provider location and version of the extension.
WebExtensionReferenceCollectionRepresents the list of web extension reference.
WebExtensionShapeRepresents the shape of web extension.
WebExtensionTaskPaneRepresents a persisted taskpane object.
WebExtensionTaskPaneCollectionRepresents the list of task pane.
WebQueryConnectionSpecifies 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.
WorkbookRepresents a root object to create an Excel spreadsheet.
WorkbookMetadataRepresents the meta data.
WorkbookPrintingPreviewWorkbook printing preview.
WorkbookRenderRepresents a Workbook render. The constructor of this class , must be used after modification of pagesetup, cell style.
WorkbookSettingsRepresents all settings of the workbook.
WorksheetEncapsulates the object that represents a single worksheet.
WorksheetCollectionEncapsulates a collection of Worksheet objects.
WriteProtectionSpecifies write protection settings for a workbook.
XlsbSaveOptionsRepresents the options for saving xlsb file.
XlsSaveOptionsRepresents the save options for the Excel 97-2003 file format: xls and xlt.
XmlColumnPropertyRepresents Xml Data Binding information.
XmlDataBindingRepresents Xml Data Binding information.
XmlLoadOptionsRepresents the options of loading xml.
XmlMapRepresents Xml map information.
XmlMapCollectionA collection of XmlMap objects that represent XmlMap information.
XmlSaveOptionsRepresents the options of saving the workbook as an xml file.
XpsSaveOptionsRepresents the additional options when saving the file as the Xps.

Interfaces

InterfaceDescription
IFilePathProviderRepresents the exported file path provider.
IPageSavingCallbackControl/Indicate progress of page saving process.
IWarningCallbackCallback interface of warning.
LightCellsDataHandlerRepresents cells data handler for reading large spreadsheet files in light weight mode.
LightCellsDataProviderRepresents Data provider for saving large spreadsheet files in light weight mode.

Enumeration Types

Enumeration TypeDescription
AccessCacheOptionsCache options for data access. Can be combined with
ActiveXPersistenceTypeRepresents the persistence method to persist an ActiveX control.
AdjustFontSizeForRowTypeRepresents which kind of rows should be ajusted.
AutoFillTypeRepresents the auto fill type.
AutoFitMergedCellsTypeRepresents the type of auto fitting merged cells.
AutoFitWrappedTextTypeRepresents the type of auto fitting wrapped text.
AutoShapeTypeRepresents all built-in auto shape type.
AxisTypeRepresents the axis type.
BackgroundModeRepresents the display mode of the background.
BackgroundTypeEnumerates cell background pattern types.
Bar3DShapeTypeRepresents the shape used with the 3-D bar or column chart.
BevelPresetTypeRepresents a preset for a type of bevel which can be applied to a shape in 3D.
BevelTypeRepresents a preset for a type of bevel which can be applied to a shape in 3D.
BorderTypeEnumerates the border line and diagonal line types.
BubbleSizeRepresentsRepresents what the bubble size represents on a bubble chart.
BuiltinStyleTypeRepresents all built-in style types.
BulletTypeRepresents the type of the bullet.
CalcModeTypeRepresents the mode type of calculating formulas.
CalculationPrecisionStrategyEnumerates 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.
CategoryTypeRepresents the category axis type.
CellBorderTypeEnumerates a cell’s border type.
CellsUnitTypeSpecifies the unit of measurement.
CellValueFormatStrategySpecifies how to apply style for the value of the cell.
CellValueTypeSpecifies a cell value type.
ChartLineFormattingTypeRepresents line format type of chart line.
ChartMarkerTypeRepresents the marker style in a line chart, scatter chart, or radar chart.
ChartSplitTypeRepresents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
ChartTextDirectionTypeRepresents the text direction type of the chart.
ChartTypeEnumerates all chart types used in Excel.
CheckValueTypeRepresents the check value type of the check box.
ColorDepthEnumerates Bit Depth Type for tiff image.
ColorTypeRepresents all color type
CommentTitleTypeRepresents comment title type while rendering when comment is set to display at end of sheet.
ConnectionDataSourceTypeSpecifies external database source type
ConnectionParameterTypeSpecifies the parameter type of external connection
ConsolidationFunctionRepresents consolidation function.
ContentDispositionThe content disposition type.
ControlBorderTypeRepresents the border type of the ActiveX control.
ControlCaptionAlignmentTypeRepresents the position of the Caption relative to the control.
ControlListStyleRepresents the visual appearance of the list in a ListBox or ComboBox.
ControlMatchEntryTypeRepresents how a ListBox or ComboBox searches its list as the user types.
ControlMousePointerTypeRepresents the type of icon displayed as the mouse pointer for the control.
ControlPictureAlignmentTypeRepresents the alignment of the picture inside the Form or Image.
ControlPicturePositionTypeRepresents the location of the control’s picture relative to its caption.
ControlPictureSizeModeRepresents how to display the picture.
ControlScrollBarTypeRepresents the type of scroll bar.
ControlScrollOrientationRepresents type of scroll orientation
ControlSpecialEffectTypeRepresents the type of special effect.
ControlTypeRepresents all type of ActiveX control.
CopyFormatTypeRepresents type of copying format when inserting rows.
CountryCodeRepresents Excel country identifiers.
CredentialsMethodTypeSpecifies Credentials method used for server access.
CrossTypeRepresents the axis cross type.
DataBarAxisPositionSpecifies the axis position for a range of cells with conditional formatting as data bars.
DataBarBorderTypeSpecifies the border type of a data bar.
DataBarFillTypeSpecifies how a data bar is filled with color.
DataBarNegativeColorTypeSpecifies whether to use the same border and fill color as positive data bars.
DataLabelShapeTypeSpecifies the preset shape geometry that is to be used for a chart.
DataLabelsSeparatorTypeRepresents the separator type of DataLabels.
DateTimeGroupingTypeSpecifies how to group dateTime values.
DefaultEditLanguageRepresents the default edit language.
DirectoryTypeRepresents the directory type of the file name.
DisplayDrawingObjectsRepresents whether and how to show objects in the workbook.
DisplayUnitTypeRepresents the type of display unit of chart’s axis.
DrawObjectEnumIndicate Cell or Image of DrawObject.
DropButtonStyleRepresents the symbol displayed on the drop button.
DynamicFilterTypeDynamic filter type.
EmfRenderSettingSetting for rendering Emf metafile.
EncodingTypeRepresents supported encoding types.
EncryptionTypeEncryption 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.
EquationCharacterPositionTypeSpecifies the position of a particular subobject within its parent
EquationCombiningCharacterTypeType of combining characters.
EquationDelimiterShapeTypeThis specifies the shape of delimiters in the delimiter object.
EquationFractionTypeThis specifies the display style of the fraction bar.
EquationHorizontalJustificationTypeThis specifies the default horizontal justification of equations in the document.
EquationLimitLocationTypeSpecifies the limit location on an operator.
EquationMathematicalOperatorTypeMathematical Operators Type
EquationNodeTypeEquation 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.
EquationVerticalJustificationTypeThis specifies the default vertical justification of equations in the document.
ErrorBarDisplayTypeRepresents error bar display type.
ErrorBarTypeRepresents error bar amount type.
ErrorCellValueTypeRepresents a cell value which contains an error.
ErrorCheckTypeRepresents all error check type.
ExceptionTypeRepresents custom exception type code.
ExternalConnectionClassTypeRepresents the type of connection
ExternalLinkTypeRepresents the type of external link.
FileFormatTypeRepresents the file format types.
FillPatternEnumerates shape fill pattern types.
FillPictureTypeRepresents the picture fill type.
FillTypeFill format type.
FilterOperatorTypeCustom Filter operator type.
FilterTypeThe filter type.
FontSchemeTypeRepresents the scheme type of the font.
FontSourceTypeSpecifies the type of a font source.
FontUnderlineTypeEnumerates the font underline types.
FormatConditionTypeConditional format rule type.
FormatConditionValueTypeCondition value type.
FormatSetTypeFill format set type.
FormattingTypeRepresents the type of formatting applied to an Area object or a Line object.
GradientColorTypeRepresents the gradient color type for the specified fill.
GradientDirectionTypeRepresents all direction type of gradient.
GradientFillTypeRepresents all Gradient fill type.
GradientPresetTypeRepresents gradient preset color type.
GradientStyleTypeRepresents gradient shading style.
GridlineTypeEnumerates grid line Type.
HeaderFooterCommandTypeRepresents the command type of header and footer.
HtmlCrossTypeRepresents five types of html cross string.
HtmlExportDataOptionsRepresents the options for exporting html data.
HtmlFormatHandlingTypeSpecifies how to handle formatting from the HTML source
HtmlHiddenColDisplayTypeRepresents two types of showing the hidden columns in html.
HtmlHiddenRowDisplayTypeRepresents two types of showing the hidden rows in html.
HtmlLinkTargetTypeRepresents the type of target attribute in HTML tag.
HtmlOfficeMathOutputTypeRepresents how export OfficeMath to HTML.
IconSetTypeIcon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.
ImageBinarizationMethodSpecifies the method used to binarize image.
ImageTypeSpecifies the type (format) of an image.
InputMethodEditorModeRepresents the default run-time mode of the Input Method Editor.
JsonExportHyperlinkTypeRepresents type of exporting hyperlinks to json.
LabelPositionTypeRepresents data label position type.
LegendPositionTypeEnumerates the legend position types.
LightRigDirectionTypeRepresents the light rig direction type.
LightRigTypeRepresents a preset light right that can be applied to a shape
LineCapTypeRepresents the caps of a line
LineJoinTypeRepresents the join styles of a line.
LineSpaceSizeTypeRepresents the unit type of line space size.
LineTypeEnumerates the type of Picture border or Chart line.
LoadDataFilterOptionsRepresents the options to filter data when loading workbook from template.
LoadFormatRepresents the load file format.
LoadNumbersTableTypeIndicates type of loading tables when some tables are in a sheet.
LookAtTypeRepresents look at type.
LookInTypeRepresents look in type.
MapChartLabelLayoutRepresents the layout of map chart’s labels.
MapChartProjectionTypeRepresents projection type of the map chart.
MapChartRegionTypeRepresents the region type of the map chart.
MemorySettingMemory usage options.
MergedCellsShrinkTypeRepresents the strategy to shrink merged cells for operations such as deleting blank rows/column.
MergeEmptyTdTypeRepresents the merge type for empty TD element when exporting file to html.
MetadataTypeRepresents the type of metadata.
MirrorTypeRepresents mirror type of texture fill
MsoArrowheadLengthEnumerates the line end width of the shape border line.
MsoArrowheadStyleEnumerates the line end type of the shape border line.
MsoArrowheadWidthEnumerates the line end width of the shape border line.
MsoDrawingTypeRepresents office drawing objects type.
MsoLineDashStyleRepresents style of dash drawing lines.
MsoLineStyleRepresents style of drawing lines.
MsoPresetTextEffectRepresents preset text effect type of WordArt.
MsoPresetTextEffectShapeRepresents preset text effect shape type of WordArt.
NameScopeTypeRepresents the scope type of defined names.
NumberCategoryTypeRepresents category type of cell’s number formatting.
ObjectTypeRepresents the type of the object.
OdsCellFieldTypeRepresents the cell field type of ods.
OdsGeneratorTypeRepresents the type of ODS generator.
OdsPageBackgroundGraphicPositionTypeRepresents the position.
OdsPageBackgroundGraphicTypeRepresents the type of formatting page background with image.
OdsPageBackgroundTypeRepresents the page background type of ods.
OLEDBCommandTypeSpecifies the OLE DB command type.
OoxmlComplianceAllows to specify which OOXML specification will be used when saving in the Xlsx format.
OoxmlCompressionTypeThe Ooxml compression type
OpenDocumentFormatVersionTypeOpen Document Format version type.
OperatorTypeRepresents the operator type of conditional format and data validation.
PageLayoutAlignmentTypeEnumerates page layout alignment types.
PageOrientationTypeRepresents print orientation constants.
PaneStateTypeRepresents state of the sheet’s pane.
PaperSizeTypeRepresents paper size constants.
ParameterTypeRepresents all parameters’ type or return value type of function.
PasteOperationTypeRepresents operation type when pasting range.
PasteTypeRepresents the paste special type.
PdfComplianceAllowing user to set PDF conversion’s Compatibility
PdfCompressionCoreSpecifies a type of compression applied to all content in the PDF file except images.
PdfCustomPropertiesExportSpecifies the way CustomDocumentPropertyCollection are exported to PDF file.
PdfFontEncodingRepresents pdf embedded font encoding.
PdfOptimizationTypeSpecifies a type of optimization.
PivotAreaTypeIndicates the type of rule being used to describe an area or aspect of the PivotTable.
PivotConditionFormatRuleTypeRepresents PivotTable condition formatting rule type.
PivotConditionFormatScopeTypeRepresents PivotTable condition formatting scope type.
PivotFieldDataDisplayFormatRepresents data display format in the PivotTable data field.
PivotFieldGroupTypeRepresents the group type of pivot field.
PivotFieldSubtotalTypeSummary description for PivotFieldSubtotalType.
PivotFieldTypeRepresents PivotTable field type.
PivotFilterTypeRepresents PivotTable Filter type.
PivotGroupByTypeRepresents group by type.
PivotItemPositionRepresents base item Next/Previous/All position in the base field .
PivotItemPositionTypeRepresents the position type of the pivot base item in the base field when the ShowDataAs calculation is in use.
PivotLineTypeSpecifies the type of the PivotLine.
PivotMissingItemLimitTypeRepresents number of items to retain per field.
PivotRefreshStateThe state for refreshing pivot tables.
PivotTableAutoFormatTypeRepresents PivotTable auto format type.
PivotTableSelectionTypeSpecifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
PivotTableSourceTypeRepresents data source type of the pivot table.
PivotTableStyleTypeRepresents the pivot table style type.
PlacementTypeRepresents the way the drawing object is attached to the cells below it.
PlotDataByTypeRepresents the type of data plot by row or column.
PlotEmptyCellsTypeRepresents all plot empty cells type of a chart.
PowerQueryFormulaTypeRepresents the type of power query formula.
PresetCameraTypeRepresent different algorithmic methods for setting all camera properties, including position.
PresetMaterialTypeDescribes surface appearance of a shape.
PresetShadowTypeRepresents preset shadow type.
PresetThemeGradientTypeRepresents the preset theme gradient type.
PresetWordArtStyleRepresents the preset WordArt styles.
PrintCommentsTypeRepresents the way comments are printed with the sheet.
PrintErrorsTypeRepresents print errors constants.
PrintingPageTypeIndicates which pages will not be printed.
PrintOrderTypeRepresent print order constants.
PrintSizeTypeRepresents the printed chart size.
PropertyTypeSpecifies data type of a document property.
ProtectionTypeRepresents workbook/worksheet protection type.
QuartileCalculationTypeRepresents quartile calculation methods.
ReConnectionMethodTypeSpecifies what the spreadsheet application should do when a connection fails.
RectangleAlignmentTypeRepresents how to position two rectangles relative to each other.
ReflectionEffectTypeRepresents the effect type of reflection.
RenameStrategyStrategy option for duplicate names of columns.
ReserveMissingPivotItemTypeRepresents how to keep the missing pivot items.
ResourceLoadingTypeRepresents how to loading the linked resource.
RevisionActionTypeRepresents the type of revision action.
RevisionTypeRepresents the revision type.
SaveFormatRepresents the format in which the workbook is saved.
SelectionTypeThe selection type of list box.
ShapeAnchorTypeRepresents the anchor type.
ShapeLockTypeRepresents type of the property to be locked.
ShapePathTypeRepresents path segment type.
ShapeTextVerticalAlignmentTypeIt corresponds to “Format Shape - Text Options - Text Box - Vertical Alignment” in Excel.
SheetTypeSpecifies the worksheet type.
ShiftTypeRepresent the shift options when deleting a range of cells.
ShowDropButtonTypeSpecifies when to show the drop button
SignatureTypeSpecifies the signature type.
SlicerCacheCrossFilterTypeRepresent the type of SlicerCacheCrossFilterType
SlicerCacheItemSortTypeSpecify the sort type of SlicerCacheItem
SlicerStyleTypeSpecify the style of slicer view
SlideViewTypeRepresents the type when exporting to slides.
SmartTagShowTypeRepresents the show type of the smart tag.
SortOnTypeSorted value type.
SortOrderRepresents sort order for the data range.
SparklineAxisMinMaxTypeRepresents the minimum and maximum value types for the sparkline vertical axis.
SparklinePresetStyleTypeRepresents the preset style types for sparkline.
SparklineTypeRepresents the sparkline types.
SqlDataTypeSpecifies SQL data type of the parameter. Only valid for ODBC sources.
SqlScriptOperatorTypeRepresents the type of operating data.
StyleModifyFlagThe style modified flags.
TableDataSourceTypeRepresents the table’s data source type.
TableStyleElementTypeRepresents the Table or PivotTable style element type.
TableStyleTypeRepresents the built-in table style type.
TargetModeTypeRepresents the type of target mode.
TextAlignmentTypeEnumerates text alignment types.
TextAutonumberSchemeRepresents all automatic number scheme.
TextCapsTypeThis type specifies the cap types of the text.
TextCrossTypeEnumerates displaying text type when the text width is larger than cell width.
TextDirectionTypeRepresents the direction of the text flow for this paragraph.
TextFontAlignTypeRepresents the different types of font alignment.
TextNodeTypeRepresents the node type.
TextOrientationTypeEnumerates text orientation types.
TextOverflowTypeRepresents the way the text vertical or horizontal overflow.
TextStrikeTypeThis type specifies the strike type.
TextTabAlignmentTypeRepresents the text tab alignment types.
TextureTypeRepresents the preset texture type.
TextVerticalTypeRepresents the text direct type.
ThemeColorTypeEnumerates the theme color types.
TickLabelAlignmentTypeRepresents the text alignment type for the tick labels on the axis
TickLabelPositionTypeRepresents the position type of tick-mark labels on the specified axis.
TickMarkTypeRepresents the tick mark type for the specified axis.
TiffCompressionSpecifies what type of compression to apply when saving images into TIFF format file.
TimePeriodTypeUsed in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.
TimeUnitRepresents the base unit for the category axis.
TotalsCalculationDetermines the type of calculation in the Totals row of the list column.
TrendlineTypeRepresents the trendline type.
TxtLoadStyleStrategySpecifies how to apply style for parsed values when converting string value to number or datetime.
TxtValueQuoteTypeSpecifies the type of using quotation marks for values in text format files.
UpdateLinksTypeRepresents how to update links to other workbooks when the workbook is opened.
ValidationAlertTypeRepresents the data validation alert style.
ValidationTypeRepresents data validation type.
VbaModuleTypeRepresents the type of VBA module.
VbaProjectReferenceTypeRepresents the type of VBA project reference.
ViewTypeRepresents the view type of the worksheet.
VisibilityTypeRepresents the states for sheet visibility.
WarningTypeWaringType
WebExtensionStoreTypeRepresents the store type of web extension.
WeightTypeEnumerates the weight types for a picture border or a chart line.
XAdESTypeType of XML Advanced Electronic Signature (XAdES).

Enumerators

EnumeratorDescription
CellEnumeratorIterator of Cell objects.
ChartPointEnumeratorIterator of ChartPoint objects.
DigitalSignatureEnumeratorIterator of DigitalSignature objects.
ExternalLinkEnumeratorIterator of ExternalLink objects.
PivotFieldEnumeratorIterator of PivotField objects.
PivotItemEnumeratorIterator of PivotItem objects.
ReferredAreaEnumeratorIterator of ReferredArea objects.
RowEnumeratorIterator of Row objects.
TextParagraphEnumeratorIterator of TextParagraph objects.