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
1
vote
0 answers

Usage of ETS R codes through RExcel macros in VBA

Issue: Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(“Sheet1!B2:D8”) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 …
siddharth
  • 21
  • 2
1
vote
1 answer

RExcel code automation

Objective: I am using Rexcel to run the ETS model. I want to automate the below mentioned code through VBA. Issue: The issue being faced is that vba does not execute the code after the second double quote i.e. in the ETS code mentioned below, the…
siddharth
  • 21
  • 2
1
vote
2 answers

Recovering datas from an Excel/ActiveX spreadsheet

I'm having the following issue: I've an Excel spreadsheet with a lot of VBA codes and ActiveX controls, including RExcel formulas. The Excel version is 2007. When I try to open this file, Task Manager says Excel isn't answering and something starts…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
1
vote
2 answers

Wrapping very long functions in RExcel VBA?

When you want to use R functions in VBA via RExcel, you have to use RInterface.RRun "..." Then, if you'd like to define your own R function, you can simply RInterface.RRun "y <- function(x) { ... }" If y is made up by more than one command line,…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
1
vote
1 answer

What alternatives are out there to RExcel?

We are having problems with RExcel and I am trying to find alternatives. Our users like to use Excel and our developers like to do stats in R. So, we use Excel as a front end for data entry, analyze in R, and present results in Excel. Because of…
adamleerich
  • 5,741
  • 2
  • 18
  • 20
0
votes
0 answers

Excel BERT R package "Yield Curve" Nelson Siegel estimation : Error in matrix(0, nrow(Coeff), length(maturity)) : non-numeric matrix extent

I am using Basic Excel R Toolkit (BERT) to code R functions for Excel, and I want to use the Nelson Siegel estimation function "NSrates" which is under the R package "Yield Curve". For that, I have written an R function in BERT, with the goal of…
Anas HAMOUTNI
  • 21
  • 1
  • 5
0
votes
1 answer

Rstudio - RDCOMCLIENT writing a dataframe to excel generates special characters

While writing some dataframe to excel, via asCOMArray, most of the data is fine. But due to encoding problem, some characters like " - " gets converted to : " †" ; "é" gets changed to : "é" Here lies the code example : xlApp <-…
sayan chakraborty
  • 21
  • 2
0
votes
0 answers

Issue with reading in Excel file in R

I am running into an issue and I don't know how to get through it. I am reading in an excel file in my R code. When I read in the file, the date format in some columns automatically changes into a different format compared to one that is originally…
Jay
  • 67
  • 4
0
votes
1 answer

How can I get a user input from Excel in R dynamically?

I'm using Excel to call a script in R. R eventually generates a graph, on the basis of which I want the user to be able to see and give an input. Is there any way to get an input into R from Excel during runtime? Thanks
Karan Parmar
  • 1
  • 4
0
votes
1 answer

convert Datatable to csv file in R

I uploaded an excel file into shiny R using following code: Server.r #reative function to read a table MDPData<-reactive({ file1<-input$MDPhistorical if(is.null(file1)){return()} z<-as.data.frame(read.xlsx(file1$datapath,sheetName =…
user
  • 592
  • 6
  • 26
0
votes
0 answers

Rcpp error through RExcel

I have a problem in using Rcpp from Rexcel. (especially, sourceCpp() function) I'm running a 64-bit Windows 10 platform. I installed R ver 3.3.1 and RExcel. I also installed Rtools by Rtools34.exe. I can use RExcel properly if I don't use…
Chris
  • 9
  • 2
0
votes
1 answer

Run user-defined R function from VBA

I have a problem while I am trying to call a R function I have created, in VBA. The problem does not come from the connection between VBA and R, but when my R code has to call my own function, the program stops. To make it clearer, here is the R…
Carlotta
  • 1
  • 1
0
votes
1 answer

Is there a way to run R while in Excel?

I have data frames in Excel, that I'd like to run models on and return predictions and summary stats. Currently, I export the data to R, run a linear model and return the coefficients using XLConnect. While this works for linear models, it does…
IJH
  • 167
  • 1
  • 11
0
votes
1 answer

R, Rexcel, create macro that counts of words in and excel worksheet

I have following macro with the use of Rexcel that doesn't work. I have a list of words in range A1:A2 (mydf) and i want to count the occurence of a specific word (hello) but following doesn't work well. Could someone help me understand? Sub…
Yasmine Nouri
  • 103
  • 11
0
votes
1 answer

RExcel in 2016 not working

I usually work with RExcel and had no problems with it until today that I tried running some code. I tried the same code on December 30th and it worked perfectly but today I got the "There seems to be no R process connected to Excel" error. I…
J Pablo Lozano
  • 3
  • 2
1
2
3