Package com.google.cloud.bigquery

Class GoogleSheetsOptions.Builder

java.lang.Object

com.google.cloud.bigquery.GoogleSheetsOptions.Builder

Enclosing class:

GoogleSheetsOptions

public static final class GoogleSheetsOptions.Builder
extends Object

Method Summary

Modifier and Type	Method	Description
GoogleSheetsOptions	build()	Creates a GoogleSheetsOptions object.
GoogleSheetsOptions.Builder	setRange(String range)	[Optional] Range of a sheet to query from.
GoogleSheetsOptions.Builder	setSkipLeadingRows(long skipLeadingRows)	Sets the number of rows at the top of a sheet that BigQuery will skip when reading the data.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

setRange

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

Parameters:

range - or null for none

setSkipLeadingRows

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.

build

public GoogleSheetsOptions build()

Creates a GoogleSheetsOptions object.