[R-SIG-Mac] [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.



-- 
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