I am trying to read a (large) xlsb file in R. Given the size of the file, I am reading it in groups of lines. However, I always run in trouble at some point. For instance, the following code:
Df <- read_xlsb("C:/MyData.xlsb",
sheet = "mysheet" ,
range = cellranger::cell_limits(c(1, 1), c(100000, NA)) ,
col_names = TRUE )
yields the error message
Error in is.null(range) || is.na(range) :
'length = 3' in coercion to 'logical(1)'
Alternatively,
Df <- read_xlsb("C:/MyData.xlsb",
sheet = "My_sheet" ,
range = "A1:BC1500000",
col_names = TRUE )
yields
Error: Cell references aren't uniformly A1 or R1C1 format:
A1:BC1500000
In addition: Warning message:
Cell reference follows neither the A1 nor R1C1 format. Example:
BC1500000
NAs generated.
I have installed the most recent version of readxlsb and cellranger. Note that the second error does not occur for smaller ranges, such as A1:BC1500.