similar to: Rexcel question

Displaying 20 results from an estimated 3000 matches similar to: "Rexcel question"

2009 Mar 27
0
RExcel rcom Server Loading The Wrong Version of R
Hi, I'm pretty new to R and VERY new to RExcel. I've just finished setting it up and I'm having some problems. My first Issue is that if I attempt to use a function like RApply("sum", A1:A4) from within excel it gives me an error saying "There seems to be no R process connected to the server" I can then see an R Console open up and I get a message saying R
2009 Feb 06
0
RExcel waiting for OLE action
When I run a macro that uses RExcel, I get a dialog box that says "Microsoft Excel is waiting for another application to complete an OLE action." There is no error in the RExcel commands in the macro, of that I am sure. The box appears to be related to the inclusion of RunRFile commands. The macro will run through the second RunRFile command, but will not execute the
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
2010 Nov 22
4
Rexcel
Hello I am new to RExcel and I would like to run a source code form the excel worksheet. I would like to run the following code source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r") from the excel wroksheet. Does anybody know how to do this? Thank you Felipe Parra [[alternative HTML version deleted]]
2007 Oct 09
0
Using Rexcel: How to work with a range of data?
Hi, I am trying to use an R function over a column of data I have in my excel spreadsheet. I do the following:- 1) assign an object (calling it xaxis) to the data by typing in =Rput("xaxis",a1:a10), where my data is shown in cells a1:a10 Now I wish to arrive at the mean of these numbers and am doing the following in another cell:- =Rapply("mean","xaxis") This
2008 Apr 17
0
RExcelInstaller
RExcelInstaller_2.0-15 installs RExcel, an add-in for Excel, which connects R and Excel. RExcel allows to transfer data between R and Excel, writing VBA macros using R as a library for Excel, and calling R functions as worksheet function in Excel. RExcel integrates nicely with R Commander (Rcmdr), turning R Commander's menus into Excel menus. It comes with a comprehensive set of example
2008 Mar 20
2
I need help integrating ggplot2 into Excel
Dear all I use ggplot2 extensively for my plotting routines and rexcel to have the best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5) I can run my ggplot functions, such as qplot(...), in scratchpad mode, but not in Macro nor Worksheet functions mode. I have tried the following in Macro mode: Call RInterface.RRun("library(ggplot2)") ... Call
2013 Feb 11
1
Putting an array from excel into R Studio
Dear All, I have been using RExcel for some time and find two features especially useful: i) The ability to select part of a worksheet and put it into R ii) The way of viewing the code, the output and the alerts in separate panes. The rest of R Excel I don't really use. The major benefit for me is i) as I can use the excel as a sort of fast access database which is convenient to edit. I can
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
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
2007 Oct 18
0
Nice reference to R
Just saw this in the Windows Secret blog: Get official and unofficial fixes for Excel By Brian Livingston Despite the hotfix that Microsoft recently released for Excel 2007, as I described on Oct. 11, some math errors that you should know about still lurk in both Excel 2007 and Excel 2003. I'll bring you up to date and explain how you can get better results from Excel. Baier and
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
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
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
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