XLConnect (version 0.2-9)

xlcDump: Dumping data sets to Excel files

Description

Dumps data sets to Excel files by writing each object to a separate worksheet.

Usage

xlcDump(list, ..., file = "dump.xlsx", pos = -1, overwrite = FALSE)

Arguments

list

character vector of names of objects inside environment pos to dump into an Excel file. Objects will be written using writeWorksheet - as such any

...

Arguments that will be passed to the ls function for getting a list of object names in case the list argument is missing.

file

Excel file to which objects will be dumped. Can be an existing or a new file. Defaults to "dump.xlsx".

pos

Environment in which to look for 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 enviro

overwrite

logical specifying if data should be overwritten if objects with the same name have already been dumped to the Excel file.

Value

• Named logical vector specifying if objects have been dumped or not. An object may not be dumped because there was an issue with the coercion to a data.frame or the object already existed (and overwrite = FALSE) in the workbook.

Details

Each object is written to a separate worksheet named by the name of the object. Objects are written using the writeWorksheet method - as such any object will be coerced to data.frame.

See Also

xlcRestore, writeNamedRegion, writeWorksheet, writeNamedRegionToFile, writeWorksheetToFile, xlcEdit

Examples

require(datasets)
xlcDump(c("airquality", "CO2", "iris", "PlantGrowth", "swiss"),
        file = "myDump.xlsx", pos = "package:datasets")
xlcRestore(file = "myDump.xlsx", overwrite = TRUE)