Some or all of the information on this page might not apply to Trusted Cloud by S3NS. See Differences from Google Cloud for more details.

Class GoogleSheetsOptions.Builder (2.54.1)

public static final class GoogleSheetsOptions.Builder

Inheritance

java.lang.Object > GoogleSheetsOptions.Builder

Inherited Members

Object.clone()

Object.equals(Object)

Object.finalize()

Object.getClass()

Object.hashCode()

Object.notify()

Object.notifyAll()

Object.toString()

Object.wait()

Object.wait(long)

Object.wait(long,int)

Methods

build()

public GoogleSheetsOptions build()

Creates a GoogleSheetsOptions object.

Returns
Type	Description
`GoogleSheetsOptions`

setRange(String range)

public GoogleSheetsOptions.Builder setRange(String range)

[Optional] Range of a sheet to query from. Only used when non-empty. Typical format: sheet_name!top_left_cell_id:bottom_right_cell_id For example: sheet1!A1:B20

Parameter
Name	Description
`range`	`String` or `null` for none

Returns
Type	Description
`GoogleSheetsOptions.Builder`

setSkipLeadingRows(long skipLeadingRows)

public GoogleSheetsOptions.Builder setSkipLeadingRows(long skipLeadingRows)

Sets the number of rows at the top of a sheet that BigQuery will skip when reading the data. The default value is 0. This property is useful if you have header rows that should be skipped.

Parameter
Name	Description
`skipLeadingRows`	`long`

Returns
Type	Description
`GoogleSheetsOptions.Builder`