Class GoogleSheetsOptions.Builder (2.42.1) 

public static final class GoogleSheetsOptions.Builder

Inheritance

java.lang.Object > GoogleSheetsOptions.Builder

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