'Range' argument does not work beyond 99,999 rows
rik-glt opened this issue · 2 comments
rik-glt commented
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 commented
Just dropping in a note that I face this issue regularly too. Upvoting for