Class GoogleSheetsOptions.Builder

    • 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 - 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.