Objects


Application (1.1)

calculateM  
calculationEngineVersionP  
calculationModeP  
calculationStateP  
iterativeCalculationP  
loadM  
setM  
suspendApiCalculationUntilNextSyncM(1.6) 
suspendScreenUpdatingUntilNextSyncM(1.9) 

AutoFilter (1.9)

applyMethod  
clearCriteriaMethod  
criteriaProperty  
enabledProperty  
getRangeMethod  
getRangeOrNullObjectMethod  
isDataFilteredProperty  
loadMethod  
reapplyMethod  
removeMethod  

Binding (1.1)

deleteM  
getRangeM  
getTableM  
getTextM  
idP  
loadM  
onDataChangedEvent  
onSelectionChangedEvent  
typeP  

BindingCollection (1.1)

addM  
addFromNamedItemM  
addFromSelectionM  
countP  
getCountM  
getItemM  
getItemAtM  
getItemOrNullObjectM  
itemsP  
loadM  

CellValueConditionalFormat (1.6)

formatM  
loadM  
ruleP  
setM  

Chart (1.1)

axesProperty (Read-only)  
dataLabelsProperty (Read-only)  
deleteM  
displayBlankAsP  
formatProperty (Read-only)  
getImageM  
heightP  
idP  
leftP  
legendProperty (Read-only)  
loadM  
nameP  
onActivatedEvent  
onDeactivatedEvent  
pivotOptionsP  
plotAreaP  
plotByP  
plotVisibleOnlyP  
seriesProperty (Read-only)  
seriesNameLevelP  
setM  
setDataM  
setPositionM  
showAllFieldButtonsP  
showDataLabelOverMaximumP  
styleP  
titleProperty (Read-only)  
topP  
widthP  
worksheetM  

ChartAreaFormat (1.1)

loadM  
fillProperty (Read Only)  
fontProperty (Read Only)  
borderP  
colorSchemeP  
roundedCornersP  
setM  

ChartAxes (1.1)

loadM  
categoryAxisProperty (Read Only)  
seriesAxisProperty (Read Only)  
valueAxisProperty (Read Only)  
getItemM  
setM  

ChartAxis (1.1)

alignmentP  
axisGroupP  
baseTimeUnitP  
categoryTypeP  
customDisplayUnitP  
displayUnitP  
formatProperty (Read Only)  
heightP  
isBetweenCategoriesP  
leftP  
linkNumberFormatP  
loadM  
logBaseP  
majorGridlinesProperty (Read Only)  
majorTickMarkP  
majorTimeUnitScaleP  
majorTimeUnitScaleP  
majorUnitP  
maximumP  
minimumP  
minorGridlinesProperty (Read Only)  
minorTickMarkP  
minorUnitP  
multiLevelP  
numberFormatP  
offsetP  
positionP  
positionAtP  
reversePlotOrderP  
scaleTypeP  
setM  
setCategoryNamesM  
setCustomDisplayUnitM  
showDisplayUnitLabelP  
textOrientationP  
tickLabelPositionP  
tickLabelSpacingP  
tickMarkSpacingP  
titleProperty (Read Only)  
titleP  
topP  
typeP  
visibleP  
widthP  

ChartAxisFormat (1.1)

fontP  
fillP  
lineP  
loadM  
setM  

ChartAxisTitle (1.1)

formatR  
loadM  
setM  
setFormulaM  
textP  
visibleP  

ChartAxisTitleFormat (1.1)

fontR  
borderP  
fillP  
loadM  
setM  

ChartBinOptions (1.9)

allowOverflowP  
allowUnderflowP  
countP  
loadM  
overflowValueP  
setM  
typeP  
underflowValueP  
widthP  

ChartBorder (1.7)

clearP  
colorP  
linestyleP  
loadM  
setM  
weightP  

ChartBoxwhiskerOptions (1.9)

loadM  
quartileCalculationP  
setM  
showInnerPointsP  
showMeanLineP  
showMeanMarkerP  
showOutlierPointsP  

ChartCollection (1.1)

countP  
itemsP  
addM  
getItemM  
getItemAtM  
loadM  
getCountM  
getItemOrNullObjectM  
onActivatedEvent  
onAddedEvent  
onDeactivatedEvent  
onDeletedEvent  

ChartDataLabel (1.7)

autoTextP  
formatP  
formulaP  
heightP  
horizontalAlignmentP  
leftP  
linkNumberFormatP  
loadM  
positionP  
separatorP  
setM  
showBubbleSizeP  
showCategoryNameP  
showLegendKeyP  
showPercentageP  
showSeriesNameP  
showValueP  
textP  
textOrientationP  
topP  
verticalAlignmentP  
widthP  

ChartDataLabelFormat (1.1)

fillR  
fontR  
loadM  
borderP  
setM  

ChartDataLabels (1.1)

positionP  
separatorP  
showBubbleSizeP  
showCategoryNameP  
showLegendKeyP  
showPercentageP  
showSeriesNameP  
showValueP  
formatR  
loadM  
autoTextP  
horizontalAlignmentP  
linkNumberFormatP  
numberFormatP  
positionP  
separatorP  
showBubbleSizeP  
textOrientationP  
verticalAlignmentP  

ChartErrorBars (1.9)

endStyleCapP  
formatP  
includeP  
loadM  
setM  
typeP  
visibleP  

ChartErrorBarsFormat (1.9)

lineP  
loadM  
setM  

ChartFill (1.1)

clearM  
setSolidColorM  
loadM  

ChartFont (1.1)

boldP  
colorP  
italicP  
nameP  
sizeP  
underlineP  
loadM  
setM  

ChartFormatString (1.7)

fontP  
loadM  
setM  

ChartGridlines (1.1)

visibleP  
formatR  
loadM  

ChartGridlinesFormat (1.1)

lineR  
loadM  

ChartLegend (1.1)

overlayP  
positionP  
visibleP  
formatR  
loadM  

ChartLegendEntry (1.7)

heightP  
indexP  
leftP  
loadP  
setP  
topP  
visibleP  
widthP  

ChartLegendEntryCollection (1.7)

getCountM  
getItemAtM  
itemsP  
loadM  

ChartLegendFormat (1.1)

fillProperty (Read Only)  
fontProperty (Read Only)  
loadM  
borderP  

ChartLineFormat (1.1)

colorP  
clearM  
loadM  
linestyleP  
weightP  

ChartMapOptions (1.9)

labelStrategyP  
levelP  
projectionTypeP  

ChartPivotOptions (1.9)

showAxisFieldButtonsP  
showLegenFieldButtonsP  
showReportFilterFieldButtonsP  
showValueFieldButtonsP  

ChartPlotArea (1.8)

formatP  
heightP  
insideHeightP  
insideLeftP  
insideTopP  
insideWidthP  
leftP  
positionP  
topP  
widthP  

ChartPlotAreaFormat (1.8)

borderP  
fillP  

ChartPoint (1.1)

valueP  
formatProperty (Read Only)  
boldM  
dataLabelP  
hasDataLabelP  
markerBackgroundColorP  
markerForegroundColorP  
markerSizeP  
markerStyleP  
valueP  

ChartPointFormat (1.1)

fillR  
loadM  
borderP  
fillP  

ChartPointsCollection (1.1)

countP  
itemsP  
getItemM  
loadM  
getCountM  
getItemAtM  

ChartSeries (1.1)

nameP  
formatR  
pointsR  
loadM  
binOptionsP  
boxwhiskerOptionsP  
bubbleScaleP  
chartTypeP  
dataLabelsP  
deleteP  
doughnutHoleSizeP  
explosionP  
filteredP  
firstSliceAngleP  
gapWidthP  
gradientStyleP  
gradientMaximumColorP  
gradientMaximumTypeP  
gradientMaximumValueP  
gradientMidpointColorP  
gradientMidpointTypeP  
gradientMidpointValueP  
gradientMinimumColorP  
gradientMinimumTypeP  
gradientMinimumValueP  
hasDataLabelsP  
invertColorP  
invertIfNegativeP  
mapOptionsP  
markerBackgroundColorP  
markerForegroundColorP  
markerSizeP  
markerStyleP  
overlapP  
parentLabelStrategyP  
plotOrderP  
pointsP  
secondPlotSizeP  
setBubbleSizesP  
setValuesP  
setXAxisValuesP  
showConnectorLinesP  
showLeaderLinesP  
showShadowP  
smoothP  
splitTypeP  
splitValueP  
trendlinesP  
varyByCategoriesP  
XErrorBarsP  
yErrorBarsP  

ChartSeriesCollection (1.1)

countP  
addM  
countP  
getCountM  
getItemM  
getItemAtM  
itemsP  
itemsP  
loadM  

ChartSeriesFormat (1.1)

fillR  
lineR  
loadM  

ChartTitle (1.1)

overlayP  
formatR  
getSubStringP  
heightP  
horizontalAlignmentP  
leftP  
loadM  
overlayP  
positionP  
setP  
setFormulaP  
showShadowP  
textP  
textOrientationP  
topP  
verticalAlignmentP  
visibleP  
widthP  

ChartTitleFormat (1.1)

fillP  
fontP  
loadM  

ChartTrendLine (1.7)

?   

ChartTrendLineCollection (1.7)

?   

ChartTrendLineFormat (1.7)

?   

ChartTrendLineLabel (1.8)

?   

ChartTrendLineLabelFormat (1.8)

?   

ColorScaleConditionalFormat (1.6)

?   

Comment (prev)

?   

CommentCollection (prev)

?   

CommentReply (prev)

?   

CommentReplyCollection (prev)

?   

ConditionalDatabarNegativeFormat (1.6)

?   

ConditionalDatabarPositiveFormat (1.6)

?   

ConditionalFormat (1.6)

?   

ConditionalFormatCollection (1.6)

?   

ConditionalFormatRule (1.6)

?   

ConditionalRangeBorder (1.6)

?   

ConditionalRangeBorderCollection (1.6)

?   

ConditionalRangeFill (1.6)

?   

ConditionalRangeFont (1.6)

?   

ConditionalRangeFormat (1.6)

?   

CustomConditionalFormat (1.6)

?   

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)

?   

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  

FilterPivotHierarchy (1.8)

?   

FilterPivotHierarchyCollection (1.8)

?   

FormatProtection (1.2)

?   

FunctionResult (1.2)

?   

Functions (1.2)

?   

GeometricShape (1.9)

?   

GroupShapeCollection (1.9)

?   

HeaderFooter (1.9)

?   

HeaderFooterGroup (1.9)

?   

IconSetConditionalFormat (1.6)

?   

Image (1.9)

?   

IterativeCalculation (1.9)

?   

Line (1.9)

?   

NamedItem (1.1)

nameP  
typeP  
valueP  
visibleP  
getRangeM  
loadM  

NamedItemArrayValues (1.7)

?   

NamedItemCollection (1.1)

itemsP  
getItemM  
loadM  

PageBreak (1.9)

?   

PageBreakCollection (1.9)

?   

PageLayout (1.9)

?   

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 (prev)

?   

PivotTableStyleCollection (prev)

?   

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 (1.9)

?   

RangeBorder (1.1)

colorP  
sideIndexP  
styleP  
weightP  
loadM  

RangeBorderCollection (1.1)

countP  
itemsP  
getItemM  
getItemAtM  
loadM  

RangeCollection (1.9)

?   

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  

RangeSort (1.2)

applyM  

RangeView (1.3)

?   

RangeViewCollection (1.3)

?   

RemoveDuplicatesResult (1.9)

?   

RequestContext

?   

RowColumnPivotHierarchy (1.8)

?   

RowColumnPivotHierarchyCollection (1.8)

?   

Runtime (1.5)

?   

Session

?   

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 (1.9)

?   

ShapeCollection (1.9)

?   

ShapeFill (1.9)

?   

ShapeFont (1.9)

?   

ShapeGroup (1.9)

?   

ShapeLineFormat (1.9)

?   

Slicer (prev)

?   

SlicerCollection (prev)

?   

SlicerItem (prev)

?   

SlicerItemCollection (prev)

?   

SlicerStyle (prev)

?   

SlicerStyleCollection (prev)

?   

SortField (1.2)

?   

Style (1.7)

?   

StyleCollection (1.7)

?   

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 (1.9)

?   

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 (prev)

?   

TableStyleCollection (prev)

?   

TextConditionalFormat (1.6)

?   

TextFrame (1.9)

?   

TextRange (1.9)

?   

TimelineStyle (prev)

?   

TimelineStyleCollection (prev)

?   

TopBottomConditionalFormat (1.6)

?   

TrackedObjectsCollection (1.1)

no longer available ?

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
not found ?

    

WorksheetProtection (1.2)

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


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