Class GoogleSheetsOptions.Builder (2.35.0)

public static final class GoogleSheetsOptions.Builder

Inheritance

java.lang.Object > GoogleSheetsOptions.Builder

Methods

build()

public GoogleSheetsOptions build()

Creates a GoogleSheetsOptions object.

Returns
TypeDescription
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
NameDescription
rangeString

or null for none

Returns
TypeDescription
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
NameDescription
skipLeadingRowslong
Returns
TypeDescription
GoogleSheetsOptions.Builder