How to create a range of an xls file, which is fed weekly?

Question

How to create a crease in function read_excel, package readxl, where there is the initial cut and the end is open as it is fed weekly.

b_aberto <- read_excel("Boletos_em_ABERTO.csv", range=c("A10: "))

Answer 1

You can use the function cell_limits package cellranger to define an open rectangle. The format is

• ul - vector identifying the upper left corner (upper lEft) of the rectangle cell.
• lr - vector identifying the lower right corner (lower right) of the rectangle cell.

And the code will be something like (untested):

library(readxl)
library(cellranger)

# A10 - linha 10, coluna 1
read_excel("Boletos_em_ABERTO.csv", range = cell_limits(c(10, 1), c(NA, NA)))