Skip to content
TREB Docs

GetRangeOptions

GetRangeOptions interface

options for the GetRange method

Members
formattedoptional
boolean
boolean
return formatted values (apply number formats and return strings) (deprecated)
formulaoptional
boolean
boolean
return formulas instead of values. formula takes precedence over "formatted"; if you pass both, returned values will *not* be formatted. (deprecated)
typeoptional
'formatted' | 'A1' | 'R1C1' | 'formula'
'formatted' | 'A1' | 'R1C1' | 'formula'
by default, GetRange returns cell values. the optional type field can be used to returns data in different formats.
Referenced by
EmbeddedSpreadsheet.GetRange