Lines Matching full:values

38  * The "values" collection of methods.
42  *   $values = $sheetsService->values;
48    * Appends values to a spreadsheet. The input range is used to search for
49    * existing data and find a "table" within that range. Values will be appended
51    * See the [guide](/sheets/api/guides/values#appending_values) and [sample
57    * (values.append)
61    * range to search for a logical table of data. Values are appended after the
67    * should include the values of the cells that were appended. By default,
68    * responses do not include the updated values.
74    * @opt_param string responseValueRenderOption Determines how values in the
86    * Clears one or more ranges of values from a spreadsheet. The caller must
87    * specify the spreadsheet ID and one or more ranges. Only values are cleared --
89    * kept. (values.batchClear)
103    * Clears one or more ranges of values from a spreadsheet. The caller must
105    * of the specified data filters will be cleared. Only values are cleared -- all
107    * kept. (values.batchClearByDataFilter)
121    * Returns one or more ranges of values from a spreadsheet. The caller must
122    * specify the spreadsheet ID and one or more ranges. (values.batchGet)
136    * notation](/sheets/api/guides/concepts#cell) of the range to retrieve values
138    * @opt_param string valueRenderOption How values should be represented in the
149    * Returns one or more ranges of values that match the specified data filters.
152    * (values.batchGetByDataFilter)
166    * Sets values in one or more ranges of a spreadsheet. The caller must specify
168    * (values.batchUpdate)
182    * Sets values in one or more ranges of a spreadsheet. The caller must specify
184    * DataFilterValueRanges. (values.batchUpdateByDataFilter)
198    * Clears values from a spreadsheet. The caller must specify the spreadsheet ID
199    * and range. Only values are cleared -- all other properties of the cell (such
200    * as formatting, data validation, etc..) are kept. (values.clear)
204    * notation](/sheets/api/guides/concepts#cell) of the values to clear.
216    * Returns a range of values from a spreadsheet. The caller must specify the
217    * spreadsheet ID and a range. (values.get)
221    * notation](/sheets/api/guides/concepts#cell) of the range to retrieve values
232    * @opt_param string valueRenderOption How values should be represented in the
243    * Sets values in a range of a spreadsheet. The caller must specify the
244    * spreadsheet ID, range, and a valueInputOption. (values.update)
248    * the values to update.
253    * should include the values of the cells that were updated. By default,
254    * responses do not include the updated values. If the range to write was larger
255    * than the range actually written, the response includes all values in the
261    * @opt_param string responseValueRenderOption Determines how values in the