read_xlsb only reads up to 99,999 rows

[HamzaAbdel]

Hi, I am trying to read a sheet with over 700K rows and the function keeps running without any results. When I try to run a loop to read 10,000 rows at a time (since I thought the function was just not powerful enough to handle that many rows), I eventually get an error when I range I am defining has six figures (i.e. A1:M100000).

The sheet I am trying to read is "Master Data" from the "North America Rotary Rig Count Pivot Table (Feb 2011 - Current)" file, which can be downloaded form here .

In case it is needed, this is the loop I try to run.

rows = seq(1,700000,by=10000)
rig_count = data.frame()
for(i in 1:length(rows)) {
  range = paste0("Master Data!A",rows[[i]],":M",(rows[[i+1]]-1))
  rig_count_part = readxlsb::read_xlsb("FILEPATH.xlsb",
                                       range = range)
  rig_count= union_all(rig_count,rig_count_part)
}

The error I get

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

[sebacea]

same issue, read_xlsb works fine for range A1:T99999. But, provided A1:T100000 I got

Error: Cell references aren't uniformly A1 or R1C1 format:
A1:T100000