7

What's the best way to have R functionality in MS SharePoint? Would RExcel work if I import an Excel sheet in SharePoint using Excel Services? Any other options?

2 Answers2

3

If you have SharePoint you must have a SQL Server license, thus why not make a table or database called R_DataAnalysis and then use PowerPivot or PowerView with SSRS to display your data?

Bryan
  • 3,271
  • 2
  • 15
  • 30
1

R exports to flat file very easily with: write.csv(dataframe,'someFile.csv')

These can easily be imported for use in SharePoint BI functionality.

John
  • 41,131
  • 31
  • 82
  • 106