xlcRestore

0th

Percentile

Restoring objects from Excel files

Restores objects from Excel files that have been dumped using xlcDump.

Keywords
utilities, file
Usage
xlcRestore(file = "dump.xlsx", pos = -1, overwrite = FALSE)
Arguments
file

Excel file from which to restore objects. This is normally a file that has been produced with xlcDump. Defaults to "dump.xlsx".

pos

Environment into which to restore objects. Can be specified either as an integer specifying the position in the search list, as a character naming an element in the search list or as an environment. Defaults to -1 which refers to the current environment.

overwrite

logical specifying if data objects should be overwritten if they already exist inside the environment pos.

Value

Named logical vector specifying if objects have been restored or not. An object may not be restored because there was an issue with reading the data from the worksheet or the object already existed in the environment pos (and overwrite = FALSE).

See Also

xlcDump, readNamedRegion, readWorksheet, readNamedRegionFromFile, readWorksheetFromFile, xlcEdit

Aliases
  • xlcRestore
Examples
# NOT RUN {
require(datasets)
xlcDump(c("airquality", "CO2", "iris", "PlantGrowth", "swiss"),
        file = "myDump.xlsx", pos = "package:datasets")
xlcRestore(file = "myDump.xlsx", overwrite = TRUE)
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.