Class GoogleSheetsOptions.Builder (2.45.0)

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`