Home

Excelsi-R

Excelsi-R is Excel's Interface to R---an add-in for Microsoft's Excel spreadsheet that allows Excel to send code to a running GNU R session and retrieve the results. The R session is accessed via Rserve, so the R session may be on a remote computer. R is not required to be installed on the local computer.

Excel integration is necessary in many parts of the business world due to Excel's entrenched position and formatting abilities. A tool like Excelsi-R can add R's statistical and computational power to standard Excel spreadsheets

Requirements:

• Windows XP/7/8
• 32-bit Excel (Excel 2003 and later should work, developed with Excel 2010)
• R with Rserve (can be remote, any platform)

Excelsi-R is licensed under the GNU LGPL.

Installation and Usage

See [User Documentation]

Technical Details

Excelsi-R consists of a windows DLL written in C++ and an Excel add-in written in Excel VBA. An excel formula can send R objects to a VBA function which does basic checking and interface work. It then passes the R object to the DLL which passes it to R via the Rserve protocol and server.

The add-in itself is only tested under Windows because that is what the author and his friends use at work. 32-bit Excel is required---64-bit Excel is not currently supported. Windows itself though can be 64-bit. The remote R server is platform independent---at the author's workplace, the R server runs Linux.

Status (Nov 2014)

Excelsi-R is in beta state. You can download v0.6 now in the Files section. It's useful for some real work tasks, and its interface has been polished compared to previous versions. Please let me know what feedback you have.

See [Changelog] for more information on recent changes.

Acknowledgments

• Excelsi-R is written and maintained by Ben Escoto.
• Aon Benfield, Ben Escoto's employer, has supported Excelsi-R's development.
• Kirsten Singer contributed some of the initial code which created and parsed Excelsi-R code blocks.

Project Admins:

• Ben Escoto

[Jungho Lee]

Any upgraded version. Especially for 64 bit?

[Ben Escoto]

Sorry, I don't have any computer with 64 bit windows on it, so I haven't looked into 64-bit support yet. Hopefully the porting process will be straightforward...