read_wb: read data from workbooks

Description Usage Arguments Value

View source: R/read_wb.R

Description

read data from workbooks

Usage

1
2
3
4
5
6
7
8
read_wb(
  source_data_dir,
  reqd_wkbks = NA,
  reqd_sheets = NA,
  password_protected = FALSE,
  overwrite = TRUE,
  dest_data_dir = NULL
)

Arguments

source_data_dir

string indicating source directory

reqd_wkbks

character vector indicating the names of the files you wish to extract from source_dir. default NA extracts all workbooks in the dir

reqd_sheets

character vector containing names of sheets to extract data from. default NA extracts from all sheets in workbook

password_protected

logical indicating whether the excel files are password protected. Password must be the same for multiple file reads

overwrite

logical indicating whether files in the destination directory should be overwritten. FALSE results in no copy rather than duplicates

dest_data_dir

optional string indicating destination directory - default NULL will use temp directory

Value

tbl_df with columns file_name, raw_excel_data and all_excel_data_tbl


ces0491/excelsioR documentation built on July 19, 2021, 8:47 a.m.