Control R from Excel
[This article was first published on R by Emmanuel Jjunju, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Here is a simple script modified from univie.ac.at that you can just run in R. Follow the instructions in the ensuing dilaogue boxes after running the script. Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
This RExcel interface will help you if you tend to work with people whose knowledge of R is weak but you want them to be able to use R-scripts that you share with them.
And the result: A new toolset complete with R_menus under the Addins Ribbon in Excel.
More customisations are described on univie.ac.at. Other
ways for working with R and Excel can be found here http://www.r-bloggers.com/a-million-ways-to-connect-r-and-excel/
To leave a comment for the author, please follow the link and comment on their blog: R by Emmanuel Jjunju.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.