Class SpreadsheetsResource.ValuesResource.AppendRequest

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 and sample code 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.

Inheritance
object
ClientServiceRequest
ClientServiceRequest<AppendValuesResponse>
SheetsBaseServiceRequest<AppendValuesResponse>
SpreadsheetsResource.ValuesResource.AppendRequest
Implements
Inherited Members
Namespace: Google.Apis.Sheets.v4
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class SpreadsheetsResource.ValuesResource.AppendRequest : SheetsBaseServiceRequest<AppendValuesResponse>, IClientServiceRequest<AppendValuesResponse>, IClientServiceRequest

Constructors

AppendRequest(IClientService, ValueRange, string, string)

Constructs a new Append request.

Declaration
public AppendRequest(IClientService service, ValueRange body, string spreadsheetId, string range)
Parameters
Type Name Description
IClientService service
ValueRange body
string spreadsheetId
string range

Properties

HttpMethod

Gets the HTTP method.

Declaration
public override string HttpMethod { get; }
Property Value
Type Description
string
Overrides

IncludeValuesInResponse

Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.

Declaration
[RequestParameter("includeValuesInResponse", RequestParameterType.Query)]
public virtual bool? IncludeValuesInResponse { get; set; }
Property Value
Type Description
bool?

InsertDataOption

How the input data should be inserted.

Declaration
[RequestParameter("insertDataOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum? InsertDataOption { get; set; }
Property Value
Type Description
SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum?

MethodName

Gets the method name.

Declaration
public override string MethodName { get; }
Property Value
Type Description
string
Overrides

Range

The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table.

Declaration
[RequestParameter("range", RequestParameterType.Path)]
public virtual string Range { get; }
Property Value
Type Description
string

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
[RequestParameter("responseDateTimeRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.ResponseDateTimeRenderOptionEnum? ResponseDateTimeRenderOption { get; set; }
Property Value
Type Description
SpreadsheetsResource.ValuesResource.AppendRequest.ResponseDateTimeRenderOptionEnum?

ResponseValueRenderOption

Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.

Declaration
[RequestParameter("responseValueRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.ResponseValueRenderOptionEnum? ResponseValueRenderOption { get; set; }
Property Value
Type Description
SpreadsheetsResource.ValuesResource.AppendRequest.ResponseValueRenderOptionEnum?

RestPath

Gets the REST path.

Declaration
public override string RestPath { get; }
Property Value
Type Description
string
Overrides

SpreadsheetId

The ID of the spreadsheet to update.

Declaration
[RequestParameter("spreadsheetId", RequestParameterType.Path)]
public virtual string SpreadsheetId { get; }
Property Value
Type Description
string

ValueInputOption

How the input data should be interpreted.

Declaration
[RequestParameter("valueInputOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum? ValueInputOption { get; set; }
Property Value
Type Description
SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum?

Methods

GetBody()

Returns the body of the request.

Declaration
protected override object GetBody()
Returns
Type Description
object
Overrides

InitParameters()

Initializes Append parameter list.

Declaration
protected override void InitParameters()
Overrides

Implements