import_list | R Documentation |
Use import()
to import a list of data frames from a vector of file names or from a multi-object file (Excel workbook, .Rdata file, zipped directory in a zip file, or HTML file)
import_list(
file,
setclass = getOption("rio.import.class", "data.frame"),
which,
rbind = FALSE,
rbind_label = "_file",
rbind_fill = TRUE,
...
)
file |
A character string containing a single file name for a multi-object file (e.g., Excel workbook, zip file, or HTML file), or a vector of file paths for multiple files to be imported. |
setclass |
An optional character vector specifying one or more classes
to set on the import. By default, the return object is always a
“data.frame”. Allowed values include “tbl_df”, “tbl”, or
“tibble” (if using tibble), “arrow”, “arrow_table” (if using arrow table; the suggested package |
which |
If |
rbind |
A logical indicating whether to pass the import list of data frames through |
rbind_label |
If |
rbind_fill |
If |
... |
Additional arguments passed to |
If rbind=FALSE
(the default), a list of a data frames. Otherwise, that list is passed to data.table::rbindlist()
with fill = TRUE
and returns a data frame object of class set by the setclass
argument; if this operation fails, the list is returned.
import()
, export_list()
, export()
## For demo, a temp. file path is created with the file extension .xlsx
xlsx_file <- tempfile(fileext = ".xlsx")
export(
list(
mtcars1 = mtcars[1:10, ],
mtcars2 = mtcars[11:20, ],
mtcars3 = mtcars[21:32, ]
),
xlsx_file
)
# import a single file from multi-object workbook
import(xlsx_file, sheet = "mtcars1")
# import all worksheets, the return value is a list
import_list(xlsx_file)
# import and rbind all worksheets, the return valye is a data frame
import_list(xlsx_file, rbind = TRUE)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.