none
Integration between Microsoft R and Excel RRS feed

  • Question

  • Are there any plans (or existing product) to better integrate Microsoft R and Excel? Or pointers to materials?

    I am looking for an integration which will allow VBA to call R routines where R has control of VBA object model.

    Something like the R BERT library https://bert-toolkit.com/ 


    MikeCro

    Thursday, July 26, 2018 7:14 AM

All replies

  • Did you try this:

    https://github.com/Microsoft/mls-excel-app

    Thursday, July 26, 2018 7:42 PM
  • Thanks Efrat.

    Are you saying that the "Machine Learning Server Excel Add-in" provides an open interface between Excel/VBA and R?

    That is what I need. But I can't see how to access that from the documentation.

    Mike


    MikeCro

    Friday, July 27, 2018 5:58 PM
  • You can publish R services to Machine Learning server:

    https://docs.microsoft.com/en-us/machine-learning-server/operationalize/how-to-deploy-web-service-publish-manage-in-r

    and then use he Excel add-in to call these R services from Excel.  

    Monday, July 30, 2018 9:35 PM