Displaying 20 results from an estimated 6000 matches similar to: "REXcel problem"
2009 Jan 30
1
run query using rexcel runrfile and rodbc sql query
Hi,
I'm using R-2.8.1 for windows. I wrote a script calls the RODBC
package to run sql queries against an oracle database. It runs fine
when run from the rconsole and returns a data.frame with a summary for
a set of experiments. I want to run this script using the
rinterface.RunRFile command in an excel plugin, using the rexcel
package. When I run the code from my excel plugin I
2013 Aug 22
0
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
library(forecast)
zz <- ts(zz,freq=365,start=c(2009,1))
etsz <- ets(zz,model='AAN')
etszP <- forecast(etsz,h=34)
write.table(etszP)
How
2011 Aug 10
1
RExcel
Hi list,
I used to work with RExcel in excel 2003. Now in 2007, I tried the same
RExcel, but it did not work. I got R version 12. I downloaded/installed the
latest version of RExcel 3.2.0 from http://sunsite.univie.ac.at/rcom/. It
has added the RExcel add-ins, but when I click on starting R in add-ins, I
get the following sequentional errors:
Errors:
SCtools not available
SCTools can not be
2012 Oct 27
1
help install RExcel
Hello,
I just installed RExcel but I have some problems. I am writing you the set
of commands that I used:
> install.packages("RExcelInstaller", "rcom", "rsproxy")
> library(rcom)
> comRegisterRegistry()
> library(RExcelInstaller)
> installstatconnDCOM()
> installRExcel()
But when I select RStart from add-ins I see this written "No R server
2011 Apr 01
4
Rexcel path problem
Hi,
I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the
content of my Rscript. The bottom part shows the error message form the
R console.
It seems that Excel is opening the R console without any problems.
The problem I am seeing is that Rinterface.RRun instruction is
interpreting the "\T"
2011 Jun 06
1
Question with RExcel
Dear all,
I?m doing some simulation studies in order to compare the estimates (and estimated standard deviations) from the ARMA(2,1) Model with an estimator that I?ve constructed. For carrying out the simulations I created a VBA project within Excel.
Now, I?m using the RExcel tool for running the R commands in the VBA project. I run 2500 simulation using the ?arima? function from R and it worked!
2004 Nov 14
1
overflow in RExcel (PR#7368)
Full_Name: Isto Aho
Version: 2.0.0
OS: Windows XP
Submission from: (NULL) (80.186.9.143)
Hi,
The bug can be reproduced as follows. Install R 2.0.0 and RExcel.
Take an excel sheet having 65000 rows and 11 columns, integer values.
Give the 'context' command 'put R val' for the large enough selection
of rows. (I didn't check, how many are needed, but it seems that
10000 rows
2011 Aug 11
1
Capture R-Console Output to Excel with RExcel
Hello All
I've just started to use RExcel instead of CMD Batches. But I don't get
the console output to an data.frame and push to Excel.
With the CMD batch you got the console out relatively easy with
C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile%
to a file. But how can I get it to Excel with RExcel an VBA?
Thanks,
Dario
[[alternative HTML version deleted]]
2013 Aug 22
1
Rexcel
Hello,
I must tell you once again to address your questions to
r-help at r-project.org
And since there was no subject line, I've made up one.
Your question seems to be a question about excel, and I really can't
help you. Maybe someone else can.
But if you write.table(etszP) can't you read that file into excel?
Rui Barradas
Em 22-08-2013 15:57, siddhartha.geddam at eclerx.com
2013 Aug 22
0
Rexcel macro query
*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
library(forecast)
zz <- ts(zz,freq=365,start=c(2009,1))
etsz <- ets(zz,model='AAN')
etszP <- forecast(etsz,h=34)
2004 Oct 06
1
RExcel : problem with error handler?
Dear R-help,
Call RInterface.StartRServer ' Works fine
Call RInterface.RRun("objects()") ' Works fine
Call Rinterface.RRun( other R commands which do not generate errors, the
demos etc ) ' Works fine
But ...
Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it
appears
After about 90 seconds a dialog box appears "Microsoft
2012 Oct 25
2
Egarch (1,1) with Student t distribution in RExcel
Hi
I want to implement Egarch (1,1) with t distribution model using RExcel and VBA.
May I know the syntax.
Following is the code that I 'm using.
rinterface.RRun "spec=ugarchspec(variance.model=list(model=(eGARCH),garchOrder=c(1,1)), mean.model=list(armaOrder=c(1,1), arfima=FALSE), distribution.model=(std))"
rinterface.RRun "fit = ugarchfit(Data = b, spec = spec)"
2009 Aug 31
1
RE xcel - two problems - Running RExcel & Working Directory error
Hi,
I am using RExcel both at work and at home and am facing a couple of
challenges. The one at home is that when using RExcel and trying to run any
code that involves changing the working directory, I get the following
error.
Error in command:
setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n
cannot change working directory
The one at office is more
2008 Oct 07
1
FW: Reading Data
Rahul Agarwal
Analyst
Equities Quantitative Research
UBS_ISC, Hyderabad
On Net: 19 533 6363
hi let me explain you the problem
we have a database which is in this format
Stocks 30-Jan-08 28-Feb-08 31-Mar-08 30-Apr-08
a 1.00 3.00 7.00 3.00
b 2.00 4.00 4.00 7.00
c 3.00 8.00 655.00 3.00
d 4.00 23.00 4.00 5.00
e 5.00 78.00 6.00 5.00
and we have a query
2010 Apr 18
2
how to use Excel VBA's Shell() to call and execute R file
I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like
this:
setwd("C:/R_test")
rnorm(100)
write(rnorm(100),"data.txt")
q(save="no", runLast = F)
Next I would like use an Excel VBA/macro Shell() function to call R and
execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)*
I wrote an Excel macro RunRcode like this:
Sub
2009 Nov 04
0
Possible bug in RTERM (PR#14043)
Full_Name: Andy Ashley
Version: 2.10.0
OS: Windows XP SP3
Submission from: (NULL) (91.105.184.105)
I am updating a legacy program which called Rterm from within Excel VBA as
follows:
Rexe = """C:\Program Files\R\R-2.4.0\bin\Rterm.exe"""
Roptions = ""
env_vars = " R_USER=" & dirname
cmdstring = Rexe & Roptions &
2010 Oct 30
1
R & VBA
Hi List,
Is there any way to pass on directly VBA variable content into a R variable?
on windows XP & using R 2.12.0
I have installed RExcel addin (with associated D(COM))
>> It function fine when trying to pass Excel Range to R but I failed (sorry if it is only my own limitation, search till now unsuccessful) to find out how to pass directly VBA array into R
Below an example -
2009 Jul 27
1
creating and populating an environment
Hi, I often work with R by writing long(ish) Excel-VBA macros
interspersed with calls to R via RExcel. A typical example of this would
be:
Sub VBAMacro()
'fetch some data from an excel sheet
'do some basic stuff on said data
'transfer data from vba to R
'run some R statements
'get data back to vba
'show results on the excel sheet
'clean R by deleting all vars
2009 Oct 07
1
RExcel
Hello-
I am a Graduate Assistant for an instructor who has written programs for
statistics calculations such as binomial distributions and regressions.
The programs had worked with no problem in Excel 2003. Now we are trying to
use it with Excel 2007, and we are having some trouble.
I have downloaded RandFriends and have ran the binomial distribution
process in 2007 Excel and have received an
2004 Nov 14
1
excel/r interface
Dear all,
I am quite new to R and for preofessional reasons I was interested in the R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula =RApply("pchisqr", 30, 1) Excel returns the message "could not start Rserver". Any suggestions how to fix this. How do run this