Package com.google.cloud.bigquery
Class GoogleSheetsOptions.Builder
java.lang.Object
com.google.cloud.bigquery.GoogleSheetsOptions.Builder
- Enclosing class:
- GoogleSheetsOptions
-
Method Summary
Modifier and TypeMethodDescriptionbuild()
Creates aGoogleSheetsOptions
object.[Optional] Range of a sheet to query from.setSkipLeadingRows
(long skipLeadingRows) Sets the number of rows at the top of a sheet that BigQuery will skip when reading the data.
-
Method Details
-
setRange
[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
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
Creates aGoogleSheetsOptions
object.
-