Description Usage Arguments Value Examples
read multiple ranges from the same sheet in an excel file
1 | du_read_excel_ranges(path, sheet = NULL, range, guess = TRUE)
|
path |
file of excel file |
sheet |
the sheet name or number to be read. If NULL, read the first sheet |
range |
range(s) in the given sheet, can be a unnamed/named vector or list. If named, names will be used as the name in the list of data frames |
guess |
whether to guess column type, if FALSE, read all columns as text |
a list of data frames
1 2 3 4 5 6 7 8 | ## Not run:
file_path <- system.file("examples/excel.xlsx",package = "dfutils")
range1 <- c("A1:E5","H7:L11")
range2 <- list(tabl1="A1:E5",table2="H7:L11")
du_read_excel_ranges(file_path,range = range1)
du_read_excel_ranges(file_path,range = range2,guess = FALSE)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.