Class GoogleSheetsOptions.Builder (2.20.0)

Version 2.20.0

• 2.44.0 (latest)
• 2.43.3
• 2.42.3
• 2.41.0
• 2.40.3
• 2.39.1
• 2.38.2
• 2.37.2
• 2.36.0
• 2.35.0
• 2.34.2
• 2.33.2

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