When reading a large range with read_excel there seems to be row limits of about 100,000 when using spreadsheet style range descriptions.
tb_data <- read_excel(path = "large_sheet.xlsx", sheet = "Sheet1", range = "A24:R115758", col_names = FALSE)
Error: Cell references aren't uniformly A1 or R1C1 format:
In addition: Warning message:
Cell reference follows neither the A1 nor R1C1 format. Example:
Doing it with unbounded rectangles does work.
tb_data <- read_excel(path = "large_sheet.xlsx", sheet = "Sheet1", range = cell_limits(c(24, 1), c(NA, 18)), col_names = FALSE)
A tibble: 115,735 x 18
I'm not sure if this is a bug or a feature, but it should probably be documented somewhere.