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

target.apidocs.com.google.api.services.sheets.v4.model.GridRange.html Maven / Gradle / Ivy

There is a newer version: v4-rev20240423-2.0.0
Show newest version






GridRange (Google Sheets API v4-rev20230526-2.0.0)












com.google.api.services.sheets.v4.model

Class GridRange

  • All Implemented Interfaces:
    Cloneable, Map<String,Object>


    public final class GridRange
    extends com.google.api.client.json.GenericJson
    A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if `"Sheet1"` is sheet ID 123456, then: `Sheet1!A1:A1 == sheet_id: 123456, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1` `Sheet1!A3:B4 == sheet_id: 123456, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1!A:B == sheet_id: 123456, start_column_index: 0, end_column_index: 2` `Sheet1!A5:B == sheet_id: 123456, start_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1 == sheet_id: 123456` The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as `#REF!`.

    This is the Java data model class that specifies how to parse/serialize into the JSON that is transmitted over HTTP when working with the Google Sheets API. For a detailed explanation see: https://developers.google.com/api-client-library/java/google-http-java-client/json

    Author:
    Google, Inc.
    • Constructor Detail

      • GridRange

        public GridRange()
    • Method Detail

      • getEndColumnIndex

        public Integer getEndColumnIndex()
        The end column (exclusive) of the range, or not set if unbounded.
        Returns:
        value or null for none
      • setEndColumnIndex

        public GridRange setEndColumnIndex(Integer endColumnIndex)
        The end column (exclusive) of the range, or not set if unbounded.
        Parameters:
        endColumnIndex - endColumnIndex or null for none
      • getEndRowIndex

        public Integer getEndRowIndex()
        The end row (exclusive) of the range, or not set if unbounded.
        Returns:
        value or null for none
      • setEndRowIndex

        public GridRange setEndRowIndex(Integer endRowIndex)
        The end row (exclusive) of the range, or not set if unbounded.
        Parameters:
        endRowIndex - endRowIndex or null for none
      • getSheetId

        public Integer getSheetId()
        The sheet this range is on.
        Returns:
        value or null for none
      • setSheetId

        public GridRange setSheetId(Integer sheetId)
        The sheet this range is on.
        Parameters:
        sheetId - sheetId or null for none
      • getStartColumnIndex

        public Integer getStartColumnIndex()
        The start column (inclusive) of the range, or not set if unbounded.
        Returns:
        value or null for none
      • setStartColumnIndex

        public GridRange setStartColumnIndex(Integer startColumnIndex)
        The start column (inclusive) of the range, or not set if unbounded.
        Parameters:
        startColumnIndex - startColumnIndex or null for none
      • getStartRowIndex

        public Integer getStartRowIndex()
        The start row (inclusive) of the range, or not set if unbounded.
        Returns:
        value or null for none
      • setStartRowIndex

        public GridRange setStartRowIndex(Integer startRowIndex)
        The start row (inclusive) of the range, or not set if unbounded.
        Parameters:
        startRowIndex - startRowIndex or null for none
      • set

        public GridRange set(String fieldName,
                             Object value)
        Overrides:
        set in class com.google.api.client.json.GenericJson
      • clone

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

Copyright © 2011–2023 Google. All rights reserved.





© 2015 - 2024 Weber Informatics LLC | Privacy Policy