CODEWITHSUNDEEP
rexceluser-interfacerexcelvba
J. Doe.
J. Doe.

Reputation: 1305

How can I implement complex R model in Excel?

I have developed a complex model in R and I need for users of this model to run it through excel without having R installed in their local machine. Elsewhere, I would build a self-contained executable a la dll or .exe

However, I do not see how I can do this with R, particularly as I am using a lot of libraries/packages that are not part of R base.

What I need is for users to launch excel, make a selection and pass this information into R. R would then run the model and export the output back to excel.

The R inputs are 3:
         1) Company Names       (list of excel cells)
         2) Period              (list of cells)
         3) Method 0,1,2,3,all  (drop-down)



The R outputs are 3:
         1) Dataset (dataframe or similar)
         2) Set of graphs (at least 4)
         3) Classification table

The outputs will then be passed into excel which acts as the GUI. Ideally, I would like users to be able to interact with the charts or change a value in the inputs section in excel and update the R-sourced chart.

I have looked into Rexcel and BERT but I don't think they can accommodate what I am after.

Thank you

Upvotes: 1

Views: 460

Answers (0)

Related Questions