Data Intelligence, Business Analytics
The main features are:
RExcel only works on Microsoft Windows (XP, Vista or 7) and with Excel 2003, 2007, 2010, but only in the 32-bit version. It uses the statconnDCOM (available from the same site as RExcel) server and for certain configurations additionally the rcom package (available from CRAN) to access R from within Excel.
(extract from Wikipedia)
I had problems with data being imported correctly directly from Excel, so I gave up on using it. Now, I try to stick to csv files for import.
I have concerns about the reliability factor, also, in the age of big data, I feel that you need a solution which scales better.
Power pivoting data from a server through excel and analysing it using R syntax but with the script run on the server would be a more powerful model, but I don't know of a solution that does this.
I have a single txt file contains 8 million records, can I import into R and perform analysis? If it possible please share the procedure/protocol.