'Range' argument does not work beyond 99,999 rows

[rik-glt]

I have encountered this issue numerous times; if you try to import a range that extends beyond row 99,999 (i.e. more than 100,000 rows) then an error is returned. E.g.:

foo <- read_excel("Sample spreadsheet.xlsx", range = "B2:C99999") #works perfectly

foo <- read_excel("Sample spreadsheet.xlsx", range = "B2:C100000") #returns the below error

Error: Cell references aren't uniformly A1 or R1C1 format:
B2:C100000
In addition: Warning message:
Cell reference follows neither the A1 nor R1C1 format. Example:
C100000
NAs generated.

[rsangole]

Just dropping in a note that I face this issue regularly too. Upvoting for 👀.

[rsangole]

@rik-glt FYI, if you're still facing this, moving to the R1C1 format works when rows are > 99,999.