xlcEdit: Editing data sets in an Excel file editor
Description
Provides the capability to edit an object/data.frame in an Excel file
editor. After editing, the object is restored in the R session with the
corresponding changes.
Usage
xlcEdit(obj, pos = globalenv(), ext = ".xlsx")
Arguments
obj
Object (data.frame) to edit.
pos
Where to look for the object specified by obj.
See pos argument of get for more
information.
ext
Extension to use for the Excel file being created. Defaults
to ".xlsx".
Value
Invisibly returns the value of the xlcRestore operation.
Details
This function uses xlcDump and xlcRestore to
dump objects to and restore objects from Excel files. An OS command is invoked
to open the temporary Excel file in the default editor. Changes to the file have
to be saved in order for them to take effect in the restored object.