Worksheet

(1.1) An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc.

activateMethod
autoFilter
calculate
chartsR
copy
deleteMethod
enableCalculation
findAllMethod
findAllOrNullObjectMethod
freezePanes
getCellMethod
getNextMethod
getNextOrNullObjectMethod
getPreviousMethod
getPreviousOrNullObjectMethod
getRangeMethod
getRangeByIndexesMethod
getRangesMethod
getUsedRangeMethod
getUsedRangeOrNullObjectMethod
idP
loadMethod
nameP
names
onActivatedEvent -
onCalculatedEvent -
onChangedEvent -
onDeactivatedEvent -
onFormatChangedEvent -
onSelectionChangedEvent -
pageLayout
pivotTables
positionP
protectionR
replaceAllMethod
set
shapes
showGridlines
showHeadings
standardHeight
standardWidth
tabColor
tablesR
verticalPageBreaks
visibilityP

activate
Method
autoFilter
calculate
charts
R
copy
delete
Method
enableCalculation
findAll
Method
findAllOrNullObject
Method
freezePanes
getCell
Method
getNext
Method
getNextOrNullObject
Method
getPrevious
Method
getPreviousOrNullObject
Method
getRange
Method
getRangeByIndexes
Method
getRanges
Method
getUsedRange
Method
getUsedRangeOrNullObject
Method
id
P
load
Method
name
P
names
onActivated
Event -
onCalculated
Event -
onChanged
Event -
onDeactivated
Event -
onFormatChanged
Event -
onSelectionChanged
Event -
pageLayout
pivotTables
position
P
protection
R
replaceAll
Method
set
shapes
showGridlines
showHeadings
standardHeight
standardWidth
tabColor
tables
R
verticalPageBreaks
visibility
P

REMARKS
* Added in 1.1
* For the Microsoft documentation refer to docs.microsoft.com

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top