The Sharp-R Add In requires Windows 7 and above along with Office 2010 or above. It will work with Office 365 except for the basic web only version. The following 3 pre-requisites must also be installed,
- .Net Framework 4.6.2, obtained from Microsoft.
- Visual Studio Tools for Office Runtime V 4.0, obtained from Microsoft.
- R version 3.2 or greater, obtained from the R Project.
The local R installation must also have a version of ggplot2 version 2.2.1 and R.Devices packages. If R isn’t installed on the target machine then installing the current version (3.3.2) along with the 2 packages will insure the above requirements for R are met. If the local R installation is version 3.2.4 revised then due to the unconventional naming of this installation it will not work with Sharp-R
A check is made at start up and if any of these packages are not found then the Add In will be unable to run until they are installed.
By default Sharp-R will connect to the local R version that is compatible with the version of Excel. So if you are running 64 bit Excel then Sharp-R will connect to 64bit R. There is now the ability to select different R installations, so Sharp-R can work with R installations like Microsoft R Open.
For automatic R connection must be installed with the default options to save a version number in the registry as this is what Sharp-R uses to automatically locate the R installation, this requires administrator rights.
Installation is straight forward, simply double click the downloaded msi installer and follow the prompts. Assuming the requirements are met then the Add In is available next time Excel is started. The first time Excel starts after install a final confirmation will be required. The Add In is then accessible through the Sharp-R Tab.
The Add In is installed on a per user basis and does not require administrator rights, although the 3 requirements do.
Before any functions are accessible from the Function control, function files must be set using the ‘Functions’ button on the ribbon. The download includes 2 sample function files with some basic functions. There are some brief notes on how to use the Functions and the Chart Builder.
We are currently working on some better documentation, but in the meantime here is a video that explains how to set up the functions and R connection.