Objects


AutoFilter

?   

Application (1.1)

calculationModeP  
calculateM  
loadM  

BasicDataValidation (1.8)

?   

Binding (1.1)

idP  
typeP  
getRangeM  
getTableM  
getTextM  
loadM  

BindingCollection (1.1)

countP  
itemsP  
getItemM  
getItemAtM  
loadM  

CellBorder

?   

CellBorderCollection

?   

CellProperties

?   

CellPropertiesBorderLoadOptions

?   

CellPropertiesFill

?   

CellPropertiesFillLoadOptions

?   

CellPropertiesFont

?   

CellPropertiesFontLoadOptions

?   

CellPropertiesFormat

?   

CellPropertiesFormatLoadOptions

?   

CellPropertiesLoadOptions

?   

CellPropertiesProtection

?   

CellValueConditionalFormat (1.6)

?   

Chart (1.1)

heightP  
idP  
leftP  
nameP  
topP  
widthP  
deleteM  
getImageM  
loadM  
setDataM  
setPositionM  
axesR  
titleR  
seriesR  
legendR  
formatR  
dataLabelsR  

ChartAreaFormat (1.1)

loadM  
fillR  
fontR  

ChartAxes (1.1)

loadM  
categoryAxisR  
seriesAxisR  
valueAxisR  

ChartAxis (1.1)

majorUnitP  
maximumP  
minimumP  
minorUnitP  
loadM  
formatR  
majorGridlinesR  
minorGridlinesR  
titleR  

ChartAxisFormat (1.1)

fontP  
lineP  
loadM  

ChartAxisTitle (1.1)

textP  
visibleP  
formatR  
loadM  

ChartAxisTitleFormat (1.1)

fontR  
loadM  

ChartBinOptions

?   

ChartBorder (1.7)

?   

ChartBoxwhisker

?   

ChartCollection (1.1)

countP  
itemsP  
addM  
getItemM  
getItemAtM  
loadM  

ChartDataLabel (1.7)

?   

ChartDataLabelFormat (1.1)

fillR  
fontR  
loadM  

ChartDataLabels (1.1)

positionP  
separatorP  
showBubbleSizeP  
showCategoryNameP  
showLegendKeyP  
showPercentageP  
showSeriesNameP  
showValueP  
formatR  
loadM  

ChartErrorBars

?   

ChartErrorBarsFormat

?   

ChartFill (1.1)

clearM  
setSolidColorM  

ChartFont (1.1)

boldP  
colorP  
italicP  
nameP  
sizeP  
underlineP  
loadM  

ChartFormatString (1.7)

?   

ChartGridlines (1.1)

visibleP  
formatR  
loadM  

ChartGridlinesFormat (1.1)

lineR  
loadM  

ChartLegend (1.1)

overlayP  
positionP  
visibleP  
formatR  
loadM  

ChartLegendEntry (1.7)

?   

ChartLegendEntryCollection (1.7)

?   

ChartLegendFormat (1.1)

fillR  
fontR  
loadM  

ChartLineFormat (1.1)

colorP  
clearM  
loadM  

ChartMapOptions

?   

ChartPivotOptions

?   

ChartPlotArea (1.8)

?   

ChartPlotAreaFormat (1.8)

?   

ChartPoint (1.1)

valueP  
formatR  
boldM  

ChartPointFormat (1.1)

fillR  
loadM  

ChartPointsCollection (1.1)

countP  
itemsP  
getItemM  
loadM  

ChartSeries (1.1)

nameP  
formatR  
pointsR  
loadM  

ChartSeriesCollection (1.1)

countP  
itemsP  
getItemM  
loadM  

ChartSeriesFormat (1.1)

fillR  
lineR  
loadM  

ChartTitle (1.1)

overlayP  
textP  
visibleP  
formatR  
loadM  

ChartTitleFormat (1.1)

fillP  
fontP  
loadM  

ChartTrendLine (1.7)

?   

ChartTrendLineCollection (1.7)

?   

ChartTrendLineFormat (1.7)

?   

ChartTrendLineLabel (1.8)

?   

ChartTrendLineLabelFormat (1.8)

?   

ColorScaleConditionalFormat (1.6)

?   

ColumnProperties

?   

ColumnPropertiesLoadOptions

?   

Comment

?   

CommentCollection

?   

CommentReply

?   

CommentReplyCollection

?   

ConditionalCellValueRule (1.6)

?   

ConditionalColorScaleCriteria (1.6)

?   

ConditionalColorScaleCriterion (1.6)

?   

ConditionalDatabarNegativeFormat (1.6)

?   

ConditionalDatabarPositiveFormat (1.6)

?   

ConditionalDatabarRule (1.6)

?   

ConditionalFormat (1.6)

?   

ConditionalFormatCollection (1.6)

?   

ConditionalFormatRule (1.6)

?   

ConditionalIconCriterion (1.6)

?   

ConditionalPresetCriteriaRule (1.6)

?   

ConditionalRangeBorder (1.6)

?   

ConditionalRangeBorderCollection (1.6)

?   

ConditionalRangeFill (1.6)

?   

ConditionalRangeFont (1.6)

?   

ConditionalRangeFormat (1.6)

?   

ConditionalTextComparisonRule (1.6)

?   

ConditionalTopBottomRule (1.6)

?   

CustomConditionalFormat (1.6)

?   

CustomDataValidation (1.8)

?   

CustomProperty (1.7)

?   

CustomPropertyCollection (1.7)

addM  
deleteAllM  
getCountM  
getItemM  
getItemOrNullObjectM  
loadM  
toJSONM  
itemsPreturns the loaded child items in the collection 

CustomXmlPart (1.5)

?   

CustomXmlPartCollection (1.5)

addM  
getByNamespaceM  
getCountM  
getItemM  
getItemOrNullObjectM  
loadM  
toJSONM  
itemsPreturns the loaded child items in the collection 

CustomXmlPartScopedCollection (1.5)

?   

DatabarConditionalFormat (1.6)

?   

DataConnectionCollection (1.7)

?   

DataPivotHierarchy (1.8)

?   

DataPivotHierarchyCollection (1.8)

?   

DataValidation (1.8)

?   

DataValidationErrorAlert (1.8)

?   

DataValidationPrompt (1.8)

?   

DataValidationRule (1.8)

?   

DateTimeDataValidation (1.8)

?   

DocumentProperties (1.7)

?   

Filter (1.2)

criteriaRThe currently applied filter on the given column. Read-only. 
applyM  
applyBottomItemsFilterM  
applyBottomPercentFilterM  
applyCellColorFilterM  
applyCustomFilterM  
applyDynamicFilterM  
applyFontColorFilterM  
applyIconFilterM  
applyTopItemsFilterM  
applyTopPercentFilterM  
applyValuesFilterM  
clearM  

FilterCriteria (1.2)

?   

FilterDatetime (1.2)

?   

FilterPivotHierarchy (1.8)

?   

FilterPivotHierarchyCollection (1.8)

?   

FormatProtection (1.2)

?   

FunctionResult (1.2)

?   

Functions (1.2)

?   

GeometricShape

?   

GroupShapeCollection

?   

HeaderFooter

?   

HeaderFooterGroup

?   

Icon (1.2)

?   

IconSetConditionalFormat (1.6)

?   

Image

?   

IterativeCalculation

?   

LoadOption (1.2)

selectP  
expandP  
topP  
skipP  

Line

?   

ListDataValidation (1.8)

?   

NamedItem (1.1)

nameP  
typeP  
valueP  
visibleP  
getRangeM  
loadM  

NamedItemArrayValues (1.7)

?   

NamedItemCollection (1.1)

itemsP  
getItemM  
loadM  

PageBreak

?   

PageBreakCollection

?   

PageLayout

?   

PageLayoutMarginOptions

?   

PageLayoutZoomOptions

?   

PivotField (1.8)

?   

PivotFieldCollection (1.8)

?   

PivotHierarchy (1.8)

?   

PivotHierarchyCollection (1.8)

?   

PivotItem (1.8)

?   

PivotItemCollection (1.8)

?   

PivotLayout (1.8)

?   

PivotTable (1.3)

?   

PivotTableCollection (1.3)

?   

PivotTableStyle

?   

PivotTableStyleCollection

?   

PresetCriteriaConditionalFormat (1.6)

?   

Range (1.1)

addressP  
addressLocalP  
cellcountP  
clearM  
columnCountP  
columnHiddenP  
deleteM  
formatR  
formulasP  
formulasLocalP  
formulasR1C1P  
getBoundingRectM  
getCellM  
getColumnM  
getEntireColumnM  
getEntireRowM  
getIntersectionM  
getLastCellM  
getLastColumnM  
getLastRowM  
getOffsetRangeM  
getRowM  
getUsedRangeM  
hiddenP  
insertM  
loadM  
mergeM  
numberFormatP  
rowCountP  
rowHiddenP  
selectM  
sortR  
textP  
unmergeM  
valuesP  
valueTypesP  
worksheetR  

RangeAreas

?   

RangeBorder (1.1)

colorP  
sideIndexP  
styleP  
weightP  
loadM  

RangeBorderCollection (1.1)

countP  
itemsP  
getItemM  
getItemAtM  
loadM  

RangeCollection

?   

RangeFill (1.1)

colorP  
clearM  
loadM  

RangeFont (1.1)

boldP  
colorP  
italicP  
nameP  
sizeP  
underlineP  
loadM  

RangeFormat (1.1)

columnWidthP  
horizonalAlignmentP  
rowHeightP  
verticalAlignmentP  
wrapTextP  
bordersR  
fillR  
fontR  
protectionR  
autofitColumnsM  
autofitRowsM  
loadM  

RangeHyperlink (1.7)

?   

RangeReference (1.7)

?   

RangeSort (1.2)

applyM  

RangeView (1.3)

?   

RangeViewCollection (1.3)

?   

RemoveDuplicateResult

?   

ReplaceCriteria

?   

RowColumnPivotHierarchy (1.8)

?   

RowColumnPivotHierarchyCollection (1.8)

?   

RowProperties

?   

RowPropertiesLoadOptions

?   

RunOptions

?   

Runtime (1.5)

?   

SearchCriteria

?   

Session

?   

SettableCellProperties

?   

SettableColumnProperties

?   

SettableRowProperties

?   

Setting (1.4)

?   

SettingCollection (1.4)

This is a collection of Setting (key value pairs)

addM  
getCountM  
getItemM  
getItemOrNullObjectM  
loadM  
toJSONM  
itemsPreturns the loaded child items in the collection 
onSettingsChangedEoccurs when the settings are changed 

Shape

?   

ShapeCollection

?   

ShapeFill

?   

ShapeFont

?   

ShapeGroup

?   

ShapeLineFormat

?   

ShowAsRule (1.8)

?   

Slicer

?   

SlicerCollection

?   

SlicerItem

?   

SlicerItemCollection

?   

SlicerStyle

?   

SlicerStyleCollection

?   

SortField (1.2)

?   

Style (1.7)

?   

StyleCollection (1.7)

?   

Subtotals (1.8)

?   

Table (1.1)

idP  
nameP  
showHeadersP  
showTotalsP  
styleP  
columnsR  
rowsR  
sortR  
worksheetR  
clearFiltersM  
convertToRangeM  
deleteM  
getDataBodyRangeM  
getHeaderRowRangeM  
getRangeM  
getTotalRowRangeM  
loadM  
reapplyFiltersM  

TableCollection (1.1)

countP  
itemsP  
addM  
getItemM  
getItemAtM  
loadM  

TableColumn (1.1)

idP  
indexP  
nameP  
valuesP  
filterR  
deleteM  
getDataBodyM  
getHeaderRowRangeM  
getRangeM  
getTotalRowRangeM  
loadM  

TableColumnCollection (1.1)

countM  
itemsM  
addM  
getItemM  
getItemAtM  
loadM  

TableRow (1.1)

indexP  
valuesP  
deleteM  
getRangeM  
loadM  

TableRowCollection (1.1)

countP  
itemsP  
addM  
getIndexAtM  
loadM  

TableScopedCollection

?   

TableSort (1.2)

matchCasePRepresents whether the casing impacted the last sort of the table. Read-only. 
methodPRepresents Chinese character ordering method last used to sort the table. Read-only. Possible values are: PinYin, StrokeCount. 
fieldsR  
applyM  
clearM  
reapplyM  

TableStyle

?   

TableStyleCollection

?   

TextConditionalFormat (1.6)

?   

TextFrame

?   

TextRange

?   

TimelineStyle

?   

TimelineStyleCollection

?   

TopBottomConditionalFormat (1.6)

?   

TrackedObjectsCollection (1.1)

addM  
removeM  
removeAllM  

Workbook (1.1)

applicationR  
bindingsR  
functionsR  
namesR  
tablesR  
worksheetsR  
getSelectedRangeM  
loadM  

WorkbookCreated (1.8)

?   

WorkbookProtection (1.7)

?   

Worksheet (1.1)

idP  
nameP  
positionP  
visibilityP  
chartsR  
tablesR  
protectionR  
activateM  
deleteM  
getCellM  
getRangeM  
getUsedRangeM  
loadM  

WorksheetCollection (1.1)

itemsP  
addM  
getActiveWorksheetM  
getItemM  
loadM  

WorksheetFreezePanes (1.7)

?   

WorksheetFunctions (1.2)

renamed from Functions

    

WorksheetProtection (1.2)

protectedPindicates if the worksheet is protected (read only)  
optionsRWorksheetProtectionOptions 
protectMprotects a worksheet 
unprotectMunprotects a worksheet 

WorksheetProtectionOptions (1.2)

?   

WorksheetSearchCriteria

?   


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext