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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description GoogleSheetsOptions
build()
Creates aGoogleSheetsOptions
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.
-
-
-
Method Detail
-
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
- ornull
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 aGoogleSheetsOptions
object.
-
-