Given a 'MS Excel' File it loads the full workbook creating as many variables as sheets exists in the workbook.
readXLworkbook(
filename,
environment = parent.frame(),
verbose = TRUE,
free.warnings = TRUE
)The path and the name to the' MS Excel' File.
Environment were the new variables will be located. By default is parent environment.
If set to TRUE useful messages are shown.
If set to TRUE it shows any warnings
result of loading the content of the book's sheets.
This function was developed by Carles Hernandez-Ferrer (carleshf) in the package "loadxls" hosted on GitHub. As of 2020-07-20 the repo no longer exists. The blog post about the package is below.
https://carleshf87.wordpress.com/2016/01/24/loadxls-r-package/