What alternatives are out there to RExcel?

1
votes

We are having problems with RExcel and I am trying to find alternatives. Our users like to use Excel and our developers like to do stats in R. So, we use Excel as a front end for data entry, analyze in R, and present results in Excel.

Because of the problems we are having with RExcel, however, I would really like to have a different solution. Assuming that we cannot remove Excel or R from the equation, are there other ways of connecting them besides RExcel? My searching on the internet has not been helpful.

[edit]

I've been asked to phrase this as a problem that SO can solve. I need to take data input in Excel, pass it to R, and get data back. RExcel is not allowed and the transfer needs to be transparent to the user. How do I do this?

1
excelrrexcel
Give us your mysterious RExcel problems and maybe we can solve them. Otherwise this Q will get closed as not constructive... As someone said in another Q recently: "Stack Overflow is not a recommendation system" – Spacedman
However, there is a wiki page with ways of communicating between R and Excel here – BenBarnes
@BenBarnes: thanks for the link. – adamleerich
While I agree, I noted that "chatty, open-ended questions" are among the most highly rated questions, and that there are even users who specialized in asking these. – Dieter Menne
You said RExcel was not allowed because you were having "problems" with it. Its not unreasonable for me to ask what those problems are, because if we can fix them then problem solved. I'd rather make sure they were unsurmountable before wasting my time trying to do something else, especially when even you admit you don't know what your question is about... – Spacedman

1 Answers

0
votes

Perhaps such an alternative is writing functions for Excel in C# with ExcelDNA and R.Net libraries.

Some info: https://github.com/Excel-DNA/Samples/tree/master/UsingRDotNet How to get ExcelDNA work with R.Net