R in Excel (RRO + MKL as scripting language in Excel)
Microsoft recently acquired Revolution Analytics:
http://revolutionanalytics.com/
Revolution R Open with MKL is an open source derivative of R (RRO + MKL). Addingin RRO to Excel is a natural fit and will extend the scripting utility of .xlsx in Enterprise environment. The package developments alone are worth considering this integration.
21 comments

Graham W Griffiths commented
Have downloaded the Berttoolkit and run the examples  very impressed.
Have created a short application that creates the finance function MACD. This went well, but some of the Bert documentation was difficult to find or appeared nonexistent.
Nevertheless, in my opinion, the Bert addin has great potential.

Clifford Dibble commented
If you are interested in using R from within Excel today, please check out "Basic Excel R Toolkit" at berttoolkit.com.

Anonymous commented
"Yes, we’re considering providing R integration with Excel in the future"
You're actually considering this? We can't even get the R.Execute function in Power Query, although it's just a matter of enabling the function.

Anonymous commented
Yes, please!! Consider R in Excel first than Python. I vote R integrated in Excel functions, this will grow exponentially the R community

Jacek Kotowski commented
In the meantime see a viable temporary solution: https://cran.rproject.org/web/packages/excel.link/index.html
There is also an example excel file that allows writing R commands and executing them within the excel sheet cells and ranges. 
pato lobos commented
Any update here guys? Power BI got it, why not Office 365? I really need this :( !!!!

Imke Feldmann commented
I would very much welcome the Rintegration into Power Query / Get&Transform rather than directly into Excel, like this: https://excel.uservoice.com/forums/304921excelforwindowsdesktopapplication/suggestions/15544569addrunrscriptoptiontoexcel2016andexcel

balakrishna sappa commented
Structured Data Values in Power Query (Field, Record, Table & List) and Objects in R (Vector, Factor, Matrix, Array, Data Frame & List) have a lot of similarities too.

balakrishna sappa commented
It would be great to have native support for R scripting in Excel, so one can call R builtin functions from within Excel or script custom R functions and then call them from within Excel. It would be great to see if we can have the functionality of controlling Excel from within the native R scripting environment like in BERT. That would make Excel powerful than ever.

Serban Dragne commented
I would find this quite useful. I use BERT to connect R to Excel which is a bit hit and miss in terms of reliability. Native solution would be very welcome indeed!

Anonymous commented
Yes please consider this, please add R.Execute command to excel power query like in power bi

Deepak Agrawal commented
Well well well .....this will make Excel jack of all trades!!! Desperately awaiting the same....

Imke Feldmann commented
Support!
Hopefully the "Rintegration" that has been introduced into PowerBI will flow to Power Query in Excel soon. Of course it would be even better, if we wouldn't have to run R separately but natively (or as an AddOn?) in Excel. 
pato lobos commented
Guys, now you have Visual Studio R Tools, Power BI with R, Azure ML with R, SQL Server and R, Microsoft Server... please go with this, if we can turn just 1% of Excel users into R user, then it will be a real revolution, around 250K R user are around the world, 1% of excel users will be 6 million people!! This is the future for Office, also integration with Word, so to publish research papers etc.

Patrick O'Beirne commented
There is RExcel from the University of Vienna:
http://rcom.univie.ac.at/download.html 
Anonymous commented
A seamless R / Excel mashup is the obvious choice for rapid prototyping of analytics and an accessible user interface. For oneoff models that may be sufficient.
Would love to see something beyond XLConnect. RExcel is a small shop, so I don't know where that's going.

Anne Marie Cooper commented
Agreed R+Excel r a natural fit (excuse the pun). Two of my favorite things together. Awesome! Apparently I need to get out more...

Brian Griner commented
Anyone tried R commander? Seems pretty good functionally and 100% open source.

Amit commented
R + Excel

Arthur Zubarev commented
Excel and R go together as bread and butter