read_excel_all: Read an entire Excel file workbook (using readxl functions)

Description Usage Arguments Value

View source: R/read_excel_all.R

Description

Read an entire Excel file workbook (using readxl functions)

Usage

1
2
read_excel_all(path, save2env = FALSE, check.names = FALSE, names = "",
  skip = 0)

Arguments

path

Path to the xls/xlsx file

save2env

Either TRUE to save each worksheet to the environment or FALSE to return a list of worksheets, which can be saved to the environment

check.names

Either TRUE to make variable names syntactically valid or FALSE to preserve original names

names

A vector of character data representing preferred sheet names

skip

Number of rows to skip when reading in data

Value

If there is more than one worksheet, then a list of data frames that represent each worksheet. If there is only one worksheet, then a data frame.


samuelkaminsky/SKTools documentation built on July 15, 2018, 7:51 p.m.