du_read_excel_ranges: read multiple ranges from the same sheet in an excel file

Description Usage Arguments Value Examples

View source: R/datatrame_io.R

Description

read multiple ranges from the same sheet in an excel file

Usage

1
du_read_excel_ranges(path, sheet = NULL, range, guess = TRUE)

Arguments

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

Value

a list of data frames

Examples

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)

yusuzech/dfutils documentation built on Dec. 8, 2019, 4:39 p.m.