Explanation: How to Work with Ranges in Google Sheets

When interacting with Google Sheets or similar tabular data sources, ranges define specific sections of the spreadsheet to read or modify. These ranges are essential for fetching data dynamically, especially in Unity projects that rely on external data for configuration or runtime updates.

Understanding Range Formats

1. General Format:

   [StartColumn][StartRow]:[EndColumn][EndRow]
   

   • StartColumn: The letter representing the starting column (e.g., A, B, C).
   • StartRow: The number representing the starting row (e.g., 1, 2, 3).
   • EndColumn: The letter representing the ending column.
   • EndRow: The number representing the ending row.

2. Examples:

   • A:H: Selects all rows from columns A to H.
   • A2:H: Selects all rows from row 2 onwards, from columns A to H.
   • A2:H6: Selects rows 2 through 6, from columns A to H.

Common Use Cases

1. Full Columns

• Range: A:H

• Description:

  • Selects all data in columns A to H.
  • Useful when the number of rows varies dynamically, but you know the columns you want.

• Example Data:

  Column A | Column B | Column C | ... | Column H
  ---------|----------|----------|-----|---------
  Value 1  | Value 2  | Value 3  | ... | Value 8
  ...
  
  

• Use Case: Fetching all data for a database where rows are dynamically added over time.

2. Starting from a Specific Row

• Range: A2:H

• Description:

  • Selects all data from row 2 onwards, within columns A to H.
  • Useful when the first row contains headers or metadata that you want to skip.

• Example Data:

  Row 1 (Skipped)  | Header 1 | Header 2 | Header 3 | ... | Header 8
  Row 2            | Value 1  | Value 2  | Value 3  | ... | Value 8
  ...
  
  

• Use Case: Skipping header rows when parsing data into objects.