All Downloads are FREE. Search and download functionalities are using the official Maven repository.

target.apidocs.com.google.api.services.bigquery.model.GoogleSheetsOptions.html Maven / Gradle / Ivy

There is a newer version: v2-rev20241027-2.0.0
Show newest version






GoogleSheetsOptions (BigQuery API v2-rev20240727-2.0.0)












com.google.api.services.bigquery.model

Class GoogleSheetsOptions

    • Constructor Detail

      • GoogleSheetsOptions

        public GoogleSheetsOptions()
    • Method Detail

      • getRange

        public String getRange()
        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
        Returns:
        value or null for none
      • setRange

        public GoogleSheetsOptions 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 - range or null for none
      • getSkipLeadingRows

        public Long getSkipLeadingRows()
        Optional. 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. When autodetect is on, the behavior is the following: * skipLeadingRows unspecified - Autodetect tries to detect headers in the first row. If they are not detected, the row is read as data. Otherwise data is read starting from the second row. * skipLeadingRows is 0 - Instructs autodetect that there are no headers and data should be read starting from the first row. * skipLeadingRows = N > 0 - Autodetect skips N-1 rows and tries to detect headers in row N. If headers are not detected, row N is just skipped. Otherwise row N is used to extract column names for the detected schema.
        Returns:
        value or null for none
      • setSkipLeadingRows

        public GoogleSheetsOptions setSkipLeadingRows(Long skipLeadingRows)
        Optional. 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. When autodetect is on, the behavior is the following: * skipLeadingRows unspecified - Autodetect tries to detect headers in the first row. If they are not detected, the row is read as data. Otherwise data is read starting from the second row. * skipLeadingRows is 0 - Instructs autodetect that there are no headers and data should be read starting from the first row. * skipLeadingRows = N > 0 - Autodetect skips N-1 rows and tries to detect headers in row N. If headers are not detected, row N is just skipped. Otherwise row N is used to extract column names for the detected schema.
        Parameters:
        skipLeadingRows - skipLeadingRows or null for none
      • clone

        public GoogleSheetsOptions clone()
        Overrides:
        clone in class com.google.api.client.json.GenericJson

Copyright © 2011–2024 Google. All rights reserved.





© 2015 - 2024 Weber Informatics LLC | Privacy Policy