google-sheetsgoogle-sheets-api

How to describe range for all rows (no column constraint) starting from given one?


In Google Spreadsheet API to work on values (e.g. get, update), you can use open-ended row ranges in the form <column-start><row-start>:<column-end> (e.g. A2:A to get all cells from column A except the first row)

I want to do the same thing without specifying a column. By the way I tried <row-start>: (e.g. 2:) but it fails to parse. Also tried with a specifying the initial column <column-start><row-start>: (e.g. A2:) but same result.


Solution

  • I haven't found a right solution, but to simulate infinite column, you can use A:ZZZ . It seems to be the largest column range supported by the API.

    So in order to get all cells starting from row 2, you can use : A2:ZZZ