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

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.

Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459