Widgets
Samples
Demos
Forum
Services
Documentation
addCheckbox
addImage
addRadio
addSheet
addSparkline
addStyle
adjust
alert
attachEvent
bind
blockEvent
callEvent
changeDecimals
clearRange
clearSheet
combineCells
compactStyles
confirm
define
deleteColumn
deleteRow
destructor
detachEvent
disable
eachSelectedCell
editSheet
enable
filterSpreadSheet
freezeColumns
freezeRows
getActiveSheet
getCellEditor
getCellFilter
getCellValue
getChildViews
getColumn
getFormView
getNode
getParentView
getRangeValue
getRow
getSelectedId
getSelectedRange
getSheetData
getSheetState
getStyle
getTopParentView
groupUndo
hasEvent
hide
hideColumn
hideGridlines
hideHeaders
hideRow
ignoreUndo
innerId
insertColumn
insertRow
isCellLocked
isColumnVisible
isEnabled
isRowVisible
isVisible
load
lockCell
mapEvent
markCheckbox
markRadio
parse
posToRef
queryView
recalculate
redo
refToPos
refresh
registerMathMethod
removeFilters
removeSheet
renameSheet
reset
resetUndo
resize
saveCell
serialize
setCellEditor
setCellFilter
setCellValue
setColumnWidth
setFormat
setPlaceholder
setRangeStyle
setRangeValue
setRowHeight
setSheetState
setStyle
show
showCell
showFormulas
showPrintBorders
showSheet
sortRange
splitCell
ui
unbind
unblockEvent
undo
zoom
Start
API Reference
ui.spreadsheet
Methods
getRangeValue
returns values from the range
array
getRangeValue
(
string
range
,
string
page
);
range
string
the range of cells
page
string
the name of the sheet you want to perform an operation on
array
values from the range
Example
var
value
=
$$
(
"ssheet"
)
.
getRangeValue
(
"A1:B2"
,
"Sheet2"
)
;
See also
API
setRangeValue
Back to top