Why does setting the range of cells to read in read_xlsb yield the error Error in is.null(range) || is.na(range)?

81 Views Asked by At

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.

0

There are 0 best solutions below