read_xl_sheets: datatools::read_xl_sheets

Description Usage Arguments Details Value Examples

View source: R/read_xl_sheets.R

Description

Import Excel workbook with multiple sheets

Usage

1
read_xl_sheets(path, skip = 0)

Arguments

path

path to the xls/xlsx file.

skip

An integer: number of rows to be skiped in the beginning of each sheet; default = 0.

Details

This function imports multiple sheets contained in a .xls/.xlsx spreadsheet into distinct tibbles.

Value

A series of tibbles corresponding to the different sheets contained in the Excel workbook.

Examples

1
2
3
4
5
6
## Not run: 
path <- ".../myworkbook.xls"
read_xl_sheets(path)
read_xl_sheets(path, skip = 2)

## End(Not run)

pmerckle/datatools documentation built on Feb. 21, 2022, 2:19 a.m.