Class SpreadsheetsResource.ValuesResource.GetRequest
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
Inheritance
Inherited Members
Namespace: Google.Apis.Sheets.v4
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class SpreadsheetsResource.ValuesResource.GetRequest : SheetsBaseServiceRequest<ValueRange>, IClientServiceRequest<ValueRange>, IClientServiceRequest
Constructors
GetRequest(IClientService, string, string)
Constructs a new Get request.
Declaration
public GetRequest(IClientService service, string spreadsheetId, string range)
Parameters
Type | Name | Description |
---|---|---|
IClientService | service | |
string | spreadsheetId | |
string | range |
Properties
DateTimeRenderOption
How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.
Declaration
[RequestParameter("dateTimeRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum? DateTimeRenderOption { get; set; }
Property Value
Type | Description |
---|---|
SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum? |
HttpMethod
Gets the HTTP method.
Declaration
public override string HttpMethod { get; }
Property Value
Type | Description |
---|---|
string |
Overrides
MajorDimension
The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is:
A1=1,B1=2,A2=3,B2=4
, then requesting range=Sheet1!A1:B2?majorDimension=ROWS
returns
[[1,2],[3,4]]
, whereas requesting range=Sheet1!A1:B2?majorDimension=COLUMNS
returns
[[1,3],[2,4]]
.
Declaration
[RequestParameter("majorDimension", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.GetRequest.MajorDimensionEnum? MajorDimension { get; set; }
Property Value
Type | Description |
---|---|
SpreadsheetsResource.ValuesResource.GetRequest.MajorDimensionEnum? |
MethodName
Gets the method name.
Declaration
public override string MethodName { get; }
Property Value
Type | Description |
---|---|
string |
Overrides
Range
The A1 notation or R1C1 notation of the range to retrieve values from.
Declaration
[RequestParameter("range", RequestParameterType.Path)]
public virtual string Range { get; }
Property Value
Type | Description |
---|---|
string |
RestPath
Gets the REST path.
Declaration
public override string RestPath { get; }
Property Value
Type | Description |
---|---|
string |
Overrides
SpreadsheetId
The ID of the spreadsheet to retrieve data from.
Declaration
[RequestParameter("spreadsheetId", RequestParameterType.Path)]
public virtual string SpreadsheetId { get; }
Property Value
Type | Description |
---|---|
string |
ValueRenderOption
How values should be represented in the output. The default render option is FORMATTED_VALUE.
Declaration
[RequestParameter("valueRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum? ValueRenderOption { get; set; }
Property Value
Type | Description |
---|---|
SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum? |
Methods
InitParameters()
Initializes Get parameter list.
Declaration
protected override void InitParameters()