Displaying 20 results from an estimated 700 matches similar to: "RExcel"
2010 Aug 09
1
RExcel: "Sctools not available"
I have a problem with RExcel which I have now installed on top of R 2.11.0.
The problem had been posted in 2009 on the forum by someone else, but no
(useful) response had been uploaded.
The issue is that
whenever I am trying to start R from excel, or by clicking the[
RExcel2007 with
RCommander] icon....., I get the following messages boxes :
"SCTools not available "
then:
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
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
2008 Nov 13
0
REXcel problem
> Hi,
>
> I am trying to run a code in Excel using VBA from R, using
> Rexcel.....but everytime I am getting this error.
Error - 2147220502 in module Recel.Rserver
Error running expression
Eval(parse(text="setwd(\"H:\\....
> I am using R-2.8.0 and R.2.7
> Please help.
>
>
>
> << OLE Object: Picture (Device Independent Bitmap) >>
>
2006 Aug 31
2
DCOM 1.3.5 Exception from HRESULT: 0x80040013 on iR.Init("R")
Hallo Everyone,
I have a problem getting R DCom to work on a MS Server 2003. I am using
Visual Studio 2005 to use some statistical functions from R. I have
installed DCOM 1.3.5. but as soon as the statement iR.Init("R") is executed
I get the following error:
Exception from HRESULT: 0x80040013
I have checked the path and the environmental variables and there are none
associated with
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
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
2013 Sep 01
0
cannot install RExcel
I have followed the instructions according to:
http://rcom.univie.ac.at/download.html#RExcel
-- "You will have to install
. a suitable version of R (I have installed R 3.0.1, CRAN Amsterdam)
. a matching version of rscproxy
. statconnDCOM or rcom with statconnDCOM
Download RExcel 3.2.13
2009 Oct 05
0
Apply R in Excel through RExcel
ryusuke:
It sounds like you need to have (D)COM server to be able to work on the background. As for the foreground, rcom is what you need and it appears to be working OK. I am out of my office right now but I'll back to work next week and I will be able to explain in more detail how the applications I tied together work with RExcel and R. You can download the latest staconnDCOM.latest.exe from
2011 Sep 09
0
RExcel - RunRFile Errors
Hi,
I am using RExcel and trying to pass a line of code into R. When I select
the cell and choose "Run Code" from the RExcel menu then it seems to work
fine.
The problem I face is a need to write a macro to do this operation, as I
need to set up a user interface in excel for other users who don't know how
to use R.
In R to run my entire code I simply write on line:
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 May 17
0
Hi! Help using FitARMA package in RExcel
Hi all :)
Before posting, I used the "search" function to find a solution, but I
wasn't lucky.
I'm using RExcel; I've read several examples which explain how to call in
RExcel an R function via =RApply(...) but I don't understand how may I
include in the function several numeric arguments.
Take this example: I want to use the following R function from
2018 Mar 01
0
RExcel issues
> On Mar 1, 2018, at 2:02 PM, Michael Ashton <m.ashton at enduringinvestments.com> wrote:
>
> Hi -
>
> For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R
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
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)
2005 Apr 12
0
Can you subset with the context of RExcel
Hi all,
I am trying to use RExcel at the moment. I am able to get it to work for
simple commands, but I can't seem to get it to work when I subset the data.
So for example, if I start RExcel, and then 'Put R var' with the following:
1 1 2
2 1 2
3 1 2
4 1 2
5 1 2
6 1 2
7 1 2
8 1 2
9 1 2
10 1 2
and set it to variable x, then I 'run R' on the code 'z <- t(x)' and
2018 Mar 01
3
RExcel issues
Hi -
For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R command)"
Recently that macro started blowing up, returning #RErrors, and when I try to trace the error I find that it is
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
2009 Jul 28
1
R Excel
Hi,
whenever
am trying to start R from excel, or by clicking the[ RExcel2007 with
RCommander] icon....., i got the following messages boxes :
SCTools not available
then:
there seems to be no R process connected
to excel
though both r and excel starts after I click the Icon!!
Please help
Hassan
[[alternative HTML version deleted]]
2003 May 15
2
Unable to load lapack.dll when using RExcel add-in
I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute
"x<-rbind(c(1,2),c(1,-1))
z<-solve(x)",
I get the following error:
"Error in solve.default(x): lapack routines could not be loaded.
In addition: Warning message:
unable to load shared library "C:\Program