Class BatchUpdateValuesByDataFilterRequest
The request for updating more than one range of values in a spreadsheet.
Implements
Inherited Members
Namespace: Google.Apis.Sheets.v4.Data
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class BatchUpdateValuesByDataFilterRequest : IDirectResponseSchema
Properties
Data
The new values to apply to the spreadsheet. If more than one range is matched by the specified DataFilter the specified values are applied to all of those ranges.
Declaration
[JsonProperty("data")]
public virtual IList<DataFilterValueRange> Data { get; set; }
Property Value
Type | Description |
---|---|
IList<DataFilterValueRange> |
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
string |
IncludeValuesInResponse
Determines if the update response should include the values of the cells that were updated. By default,
responses do not include the updated values. The updatedData
field within each of the
BatchUpdateValuesResponse.responses contains the updated values. If the range to write was larger than the
range actually written, the response includes all values in the requested range (excluding trailing empty
rows and columns).
Declaration
[JsonProperty("includeValuesInResponse")]
public virtual bool? IncludeValuesInResponse { get; set; }
Property Value
Type | Description |
---|---|
bool? |
ResponseDateTimeRenderOption
Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.
Declaration
[JsonProperty("responseDateTimeRenderOption")]
public virtual string ResponseDateTimeRenderOption { get; set; }
Property Value
Type | Description |
---|---|
string |
ResponseValueRenderOption
Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.
Declaration
[JsonProperty("responseValueRenderOption")]
public virtual string ResponseValueRenderOption { get; set; }
Property Value
Type | Description |
---|---|
string |
ValueInputOption
How the input data should be interpreted.
Declaration
[JsonProperty("valueInputOption")]
public virtual string ValueInputOption { get; set; }
Property Value
Type | Description |
---|---|
string |