R/xls.reader.R

Defines functions xls.reader

Documented in xls.reader

#' @describeIn preinstalled.readers Read an Excel file with a \code{.xls} file extension.
#'
#' This function will load the specified Excel file into memory using the
#' \code{readxl} package.
xls.reader <- function(data.file, filename, workbook.name)
{
  .require.package('readxl')

  sheets <- readxl::excel_sheets(filename)

  for (sheet.name in sheets)
  {
    variable.name <- paste(workbook.name, clean.variable.name(sheet.name), sep = ".")
    tryCatch(assign(variable.name,
                    data.frame(readxl::read_excel(filename,
                                       sheet = sheet.name)),
                    envir = .TargetEnv),
             error = function(e)
             {
               warning(paste("The worksheet", sheet.name, "didn't load correctly."))
             })
  }
}
johnmyleswhite/ProjectTemplate documentation built on July 4, 2024, 8:08 p.m.