xlcEdit

0th

Percentile

Editing data sets in an Excel file editor

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.

Keywords
misc, utilities
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".

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.

Value

Invisibly returns the value of the xlcRestore operation.

Note

This function only works under Windows and MacOS with a corresponding Excel file editor, e.g. MS Excel or LibreOffice. Attempts to use this function under another OS will result in an error being thrown.

See Also

xlcDump, xlcRestore, writeNamedRegion, writeWorksheet, writeNamedRegionToFile, writeWorksheetToFile

Aliases
  • xlcEdit
Examples
# NOT RUN {
myObj = mtcars
xlcEdit(myObj)
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.