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
3
4
5
6
7
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 Jan. 2, 2021, 4:06 a.m.