read_workbook: read_workbook

In TaylorAndrew/atImport: Methods for importing packages, data, and other files

Description

read_workbook is an extension of readxl::read_excel, loading all sheets in an excel workbook either directly into the global environment or as a part of a list

Usage

read_workbook(ExcelFile, na_value = "", add_to_Envir = TRUE,
  output_ls = FALSE)

Arguments

ExcelFile	Character string of the directory and filename pointing at the file to load
na_value	Value in the excel workbook that should be treated as missing/NA
add_to_Envir	TRUE/FALSE: Should each sheet be added to the global environment, each as a data.frame
output_ls	TRUE/FALSE: Should each sheet be appended to a list of data.frames

Value

if output_ls==TRUE, a list of data.frames.

Examples

#NULL

TaylorAndrew/atImport documentation built on May 9, 2019, 4:22 p.m.