Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Sheets
Collection
Spreadsheets
ValuesCollection
Interface ValuesCollection
interface
ValuesCollection
{
append
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
)
:
AppendValuesResponse
;
append
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
,
)
:
AppendValuesResponse
;
batchClear
(
resource
:
BatchClearValuesRequest
,
spreadsheetId
:
string
,
)
:
BatchClearValuesResponse
;
batchClearByDataFilter
(
resource
:
BatchClearValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchClearValuesByDataFilterResponse
;
batchGet
(
spreadsheetId
:
string
)
:
BatchGetValuesResponse
;
batchGet
(
spreadsheetId
:
string
,
optionalArgs
:
object
,
)
:
BatchGetValuesResponse
;
batchGetByDataFilter
(
resource
:
BatchGetValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchGetValuesByDataFilterResponse
;
batchUpdate
(
resource
:
BatchUpdateValuesRequest
,
spreadsheetId
:
string
,
)
:
BatchUpdateValuesResponse
;
batchUpdateByDataFilter
(
resource
:
BatchUpdateValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchUpdateValuesByDataFilterResponse
;
clear
(
resource
:
any
,
spreadsheetId
:
string
,
range
:
string
,
)
:
ClearValuesResponse
;
get
(
spreadsheetId
:
string
,
range
:
string
)
:
ValueRange
;
get
(
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
)
:
ValueRange
;
update
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
)
:
UpdateValuesResponse
;
update
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
,
)
:
UpdateValuesResponse
;
}
Index
Methods
append
batch
Clear
batch
Clear
By
Data
Filter
batch
Get
batch
Get
By
Data
Filter
batch
Update
batch
Update
By
Data
Filter
clear
get
update
Methods
append
append
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
)
:
AppendValuesResponse
Parameters
resource
:
ValueRange
spreadsheetId
:
string
range
:
string
Returns
AppendValuesResponse
append
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
,
)
:
AppendValuesResponse
Parameters
resource
:
ValueRange
spreadsheetId
:
string
range
:
string
optionalArgs
:
object
Returns
AppendValuesResponse
batch
Clear
batchClear
(
resource
:
BatchClearValuesRequest
,
spreadsheetId
:
string
,
)
:
BatchClearValuesResponse
Parameters
resource
:
BatchClearValuesRequest
spreadsheetId
:
string
Returns
BatchClearValuesResponse
batch
Clear
By
Data
Filter
batchClearByDataFilter
(
resource
:
BatchClearValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchClearValuesByDataFilterResponse
Parameters
resource
:
BatchClearValuesByDataFilterRequest
spreadsheetId
:
string
Returns
BatchClearValuesByDataFilterResponse
batch
Get
batchGet
(
spreadsheetId
:
string
)
:
BatchGetValuesResponse
Parameters
spreadsheetId
:
string
Returns
BatchGetValuesResponse
batchGet
(
spreadsheetId
:
string
,
optionalArgs
:
object
)
:
BatchGetValuesResponse
Parameters
spreadsheetId
:
string
optionalArgs
:
object
Returns
BatchGetValuesResponse
batch
Get
By
Data
Filter
batchGetByDataFilter
(
resource
:
BatchGetValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchGetValuesByDataFilterResponse
Parameters
resource
:
BatchGetValuesByDataFilterRequest
spreadsheetId
:
string
Returns
BatchGetValuesByDataFilterResponse
batch
Update
batchUpdate
(
resource
:
BatchUpdateValuesRequest
,
spreadsheetId
:
string
,
)
:
BatchUpdateValuesResponse
Parameters
resource
:
BatchUpdateValuesRequest
spreadsheetId
:
string
Returns
BatchUpdateValuesResponse
batch
Update
By
Data
Filter
batchUpdateByDataFilter
(
resource
:
BatchUpdateValuesByDataFilterRequest
,
spreadsheetId
:
string
,
)
:
BatchUpdateValuesByDataFilterResponse
Parameters
resource
:
BatchUpdateValuesByDataFilterRequest
spreadsheetId
:
string
Returns
BatchUpdateValuesByDataFilterResponse
clear
clear
(
resource
:
any
,
spreadsheetId
:
string
,
range
:
string
)
:
ClearValuesResponse
Parameters
resource
:
any
spreadsheetId
:
string
range
:
string
Returns
ClearValuesResponse
get
get
(
spreadsheetId
:
string
,
range
:
string
)
:
ValueRange
Parameters
spreadsheetId
:
string
range
:
string
Returns
ValueRange
get
(
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
)
:
ValueRange
Parameters
spreadsheetId
:
string
range
:
string
optionalArgs
:
object
Returns
ValueRange
update
update
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
)
:
UpdateValuesResponse
Parameters
resource
:
ValueRange
spreadsheetId
:
string
range
:
string
Returns
UpdateValuesResponse
update
(
resource
:
ValueRange
,
spreadsheetId
:
string
,
range
:
string
,
optionalArgs
:
object
,
)
:
UpdateValuesResponse
Parameters
resource
:
ValueRange
spreadsheetId
:
string
range
:
string
optionalArgs
:
object
Returns
UpdateValuesResponse
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
append
batch
Clear
batch
Clear
By
Data
Filter
batch
Get
batch
Get
By
Data
Filter
batch
Update
batch
Update
By
Data
Filter
clear
get
update
Google Apps Script API
Loading...