I know it is possible to integrate R with Excel using packages such as RExcel,but is it possible to use R as a "standalone" invisible computational backend in Excel? For example, my objective is to create statistical programs that use Excel as a front end and leverage R packages in the back end for statistical computations. I would like users to be able to use the Excel workbooks without having to install R.
Asked
Active
Viewed 132 times
1
-
SQL Server 2016 [supports in-database R services](https://msdn.microsoft.com/en-us/library/mt604845.aspx). I can't imaging it would be hard to leverage from Excel using ADO. I haven't played with it yet so I don't know if the [R Client](https://msdn.microsoft.com/en-us/microsoft-r/microsoft-r-getting-started#microsoft-r-client) is COM visible or not. – Comintern Aug 04 '16 at 02:00
-
Try `XLConnect` https://cran.r-project.org/web/packages/XLConnect/index.html – Sathish Aug 04 '16 at 07:22
-
XLConnect allows you to work FROM R into excel workbooks. It does NOT allow you to control R through an excel worksheet. – sconfluentus Aug 06 '16 at 05:44