September 28th, 2013, 1:57 am
I want to be able to manually load some (already cleaned up) data and input some parameters into Excel, press a button, and have fancy statistical analysis done in R, then spit the results (along with pictures) back into Excel.I'm aware of a few existing solutions integrating R and Excel, and some more potential solutions, e.g.- RExcel //won't work due to licensing issues; not compatible with new R versions- ExcelDna + F# RProvider with R.NET //seems a little convoluted, and might be overkill since our 'input data' are usually nice and simple- ExcelDna + C# with Rserve //seems promising, and probably won't be too difficult to write up(??)- Excelsi-R //homebrew open-source Excel addin written in C++ that talks to Rserve, haven't tested it but it doesn't run on 64-bit. Perhaps can be extended.If anyone else was unfortunate enough to have to tackle this problem, I'd appreciate your feedback!