Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
Appends values to a spreadsheet. The input range is used to search for existing data and find a
"table" within that range. Values will be appended to the next row of the table, starting with
the first column of the table. See the [guide](/sheets/api/guides/values#appending_values) and
[sample code](/sheets/api/samples/writing#append_values) for specific details of how tables are
detected and data is appended. The caller must specify the spreadsheet ID, range, and a
valueInputOption. The `valueInputOption` only controls how the input data will be added to the
sheet (column-wise or row-wise), it does not influence what cell the data starts being written
to.
Create a request for the method "values.append".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
range - The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical table of
data. Values are appended after the last row of the table.
Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet
ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as
formatting and data validation) are kept.
Create a request for the method "values.batchClear".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet
ID and one or more DataFilters. Ranges matching any of the specified data filters will be
cleared. Only values are cleared -- all other properties of the cell (such as formatting, data
validation, etc..) are kept.
Create a request for the method "values.batchClearByDataFilter".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote
operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet
ID and one or more ranges.
Create a request for the method "values.batchGet".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to retrieve data from.
Returns one or more ranges of values that match the specified data filters. The caller must
specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the data filters
in the request will be returned.
Create a request for the method "values.batchGetByDataFilter".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote
operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to retrieve data from.
Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a
valueInputOption, and one or more ValueRanges.
Create a request for the method "values.batchUpdate".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a
valueInputOption, and one or more DataFilterValueRanges.
Create a request for the method "values.batchUpdateByDataFilter".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote
operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only
values are cleared -- all other properties of the cell (such as formatting, data validation,
etc..) are kept.
Create a request for the method "values.clear".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
range - The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to clear.
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a
range.
Create a request for the method "values.get".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to retrieve data from.
range - The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values
from.
Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a
valueInputOption.
Create a request for the method "values.update".
This request holds the parameters needed by the sheets server. After setting any optional
parameters, call the AbstractGoogleClientRequest.execute() method to invoke the remote operation.
Parameters:
spreadsheetId - The ID of the spreadsheet to update.
range - The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update.
