Stack Overflow
Stack Overflow

Questions tagged [rexcel]

RExcel is an addin for Microsoft Excel that allows access to the statistics package R from within Excel.

44 questions
15
votes
3 answers

Numerical column in Excel gets converted as logical

When I try to import data into R studio from Excel, the number columns are getting imported as Logical in R. Is there a way to import these columns as a number into R? The column in Excel has been formatted to number. I am using read_excel to import…
Hisho
  • 305
  • 1
  • 3
  • 9
9
votes
1 answer

RExcel Error: There seems to be no R process connected to Excel

Today when I run "start R" from RExcel addin menu in Excel, I get the error messages: There seems to be no R process connected to Excel But it is OK before today, and also work now when setting the system time to the date before today, such as…
Jason
  • 131
  • 2
7
votes
2 answers

R in SharePoint

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?
user1302169
  • 71
  • 2
5
votes
3 answers

Run R script in Excel

There isn't a lot of information on how to do this. I tried to study a blog online and implemented the following code in VBA(with the path of the R file):- Sub RunRscript() 'runs an external R code through Shell 'The location of the RScript…
Bunty
  • 51
  • 2
  • 3
  • 8
4
votes
3 answers

RExcel in R 3.0.x

RAndFriends, which includes all the items needed to run RExcel, includes just R 2.15.2. I am currently using the latest version of R but rcom 2.3.1 and rscproxy 2.0.5, which I am currently using, do not allow me to start an R server within…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
4
votes
0 answers

x-axis labels in facet_wrap for ggplot2

Possible Duplicate: add “floating” axis labels in facet_wrap plot I am creating a panel of time series charts in RExcel using ggplot2. I have seen in many examples that the default when using ggplot2 seems to be to put the x-axis labels at the…
overflowname
  • 1,993
  • 3
  • 13
  • 12
3
votes
2 answers

Exporting output from R into an open Excel workbook

I've found the package XLConnect to be useful for exporting matrices to a CLOSED workbook, but does anyone know how to write to an OPEN workbook? Alternatively, does anyone know of code one can write in VBA to import a matrix from an R script…
Mike
  • 1,049
  • 5
  • 20
  • 46
2
votes
1 answer

Active Cells of Excel In RExcel

Cells in MS-Excel are always actives. Formulas update automatically when any value is modified. In R-Excel, I put data into R array/Dataframe and use it in a formula, and get the output. When I change any data, I have to do all steps again to get…
Faisal Afzal Siddiqui
  • 21
  • 1
2
votes
1 answer

To use RInterface.GetArrayToVBA inside VBA function with arrays

Let an Excel spreadsheet to be connected to R through RExcel and you want to write a VBA function which calls some R functions. In your Excel spreadsheet you have a couple of simple arrays like the following ones: The code could be something like…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
1
vote
0 answers

RExcel clashes when attempting to download a file in csv format

I am working on an Excel file that has embedded RExcel and calls a function from R through RApply in thousands of cells. The problem that I encounter is when I try to download some files in CSV format, I obtained a message which states that a severe…
san
  • 11
  • 2
1
vote
0 answers

Is it possible to use R as a "standalone" invisible computational backend in Excel?

I know it is possible to integrate R with Excel using packages such as RExcel,but is it possible to use R as a "standalone" invisible computational backend in Excel? For example, my objective is to create statistical programs that use Excel as a…
RTrain3k
  • 845
  • 1
  • 13
  • 27
1
vote
0 answers

How can I implement complex R model in Excel?

I have developed a complex model in R and I need for users of this model to run it through excel without having R installed in their local machine. Elsewhere, I would build a self-contained executable a la dll or .exe However, I do not see how I…
J. Doe.
  • 1,255
  • 1
  • 12
  • 25
1
vote
0 answers

Does Rexcel work for Excel 2013?

I followed the instructions from http://homepage.univie.ac.at/erich.neuwirth/php/rcomwiki/doku.php?id=wiki:how_to_install step by step and installed the Rexcel for my Excel 2013, I found the GUI interface doesn't appear in Excel. And I tried the VBA…
Paul Liu
  • 31
  • 1
  • 6
1
vote
1 answer

Does RInterface.GetArrayToVBA() always return an array?

Referring to this question from Wilmott Forums, I've just written the following function: Public Function KmeansPrice(ByVal priceArray As Range, _ ByVal clustersNumber As Integer) As Double ' Following rows are…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
1
vote
1 answer

call R ggplot with Rexcel

I click on a excel macro button which uses RExcel to execute an R script that generates a matrix [,1] [,2] [,3] [,4] [,5] [,6] [,7] [1,] 0 0 -3 -3 -3 -3 -2 [2,] 0 0 0 0 4 4 4 [3,] 0 0 0 1 2…
hedgedandlevered
  • 2,314
  • 2
  • 25
  • 54
1
2 3