#' Multi Excel reader function
#'
#' @param file_path The path of your file
#'
#' @import readxl
#'
#' @return a dataframe
#' @export
#'
multi_excel <- function(file_path) {
assert_that(is.dir(dirname(file_path)))
all_sheets <- excel_sheets(file_path)
result <- lapply(all_sheets,function(sheet) {read_excel(file_path,sheet = sheet)})
return(result)
}
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.