Skip to content
Prev 872 / 1236 Next
Original Raw

[R-gui] RExcel and Rcmdr view/edit buttons

Erich Neuwirth 
Simple Answer:
You can start Rcmdr from Excel in a way it keeps all its menus
and buttons on its own window.

RExcel -> RCommander -> with separate menus does that.

(You have to use RExcel -> Start R) to get the RCommander submenu.

More complex answer:

Do you know that when you right click in a cell in Excel, you can
immediately transfer a dataframe between Excel and R in both directions?
So to edit a dataframe:
create a new worksheet,
right click in the upper left cell,
Use Get Dataframe,
change what you want to change
press ctrl-shft-return (selecting the whole dataframe)
rightclick and use Put Dataframe

There is no need at all to use .csv when transferring data between R and
Excel.
In fact that is one of the reasons I wrote RExcel!

Please have a look at the demo workbooks in RExcel, especially the one
aboout Data transfer.