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/