Re: [R] RExcel issues

Thanks though - didn’t know there was that ecosystem. I will try that list. > On Mar 1, 2018, at 5:37 PM, David Winsemius wrote: > > >> On Mar 1, 2018, at 2:02 PM, Michael Ashton >> wrote: >> >> Hi - >> >> For a while I've used

Re: [R] RExcel issues

No, this is home use. I wasn’t even aware there was a commercial license. > On Mar 1, 2018, at 5:37 PM, David Winsemius wrote: > > >> On Mar 1, 2018, at 2:02 PM, Michael Ashton >> wrote: >> >> Hi - >> >> For a while I've used

Re: [R] RExcel issues

> On Mar 1, 2018, at 2:02 PM, Michael Ashton > 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

[R] 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

Re: [R] Rexcel

Hello, I must tell you once again to address your questions to r-help@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

Re: [R] Rexcel

This is not on topic for this mailing list. See the Statconn website for support for RExcel. --- Jeff NewmillerThe . . Go Live... DCN:jdnew...@dcn.davis.ca.usBasics: ##.#.

Re: [R] Rexcel

Free support for RExcel is available by subscribing to the mailing list at rcom.univie.ac.at and posting questions to the list. On Aug 22, 2013, at 7:04 PM, Jeff Newmiller jdnew...@dcn.davis.ca.us wrote: This is not on topic for this mailing list. See the Statconn website for support for

[R] 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 -

Re: [R] RExcel, ROOo and LibreOffice inquiry

John Kane Kingston ON Canada -Original Message- From: landronim...@gmail.com Sent: Sun, 25 Nov 2012 15:02:16 +0100 To: jrkrid...@inbox.com Subject: Re: [R] RExcel, ROOo and LibreOffice inquiry On Sun, Nov 25, 2012 at 2:38 PM, John Kane jrkrid...@inbox.com wrote: Can you supply

[R] RExcel, ROOo and LibreOffice inquiry

Dear all I'd like to give RExcel a decent spin, mainly to take advantage of Excel's data management facilities and automatic recalculations. However I cannot use this Windows-only solution on the platform of my choice, Linux. Alternatively I've been considering the cross-platform ROOo, the

Re: [R] RExcel, ROOo and LibreOffice inquiry

ON Canada -Original Message- From: landronim...@gmail.com Sent: Sun, 25 Nov 2012 12:52:55 +0100 To: r-help@r-project.org Subject: [R] RExcel, ROOo and LibreOffice inquiry Dear all I'd like to give RExcel a decent spin, mainly to take advantage of Excel's data management facilities

Re: [R] RExcel, ROOo and LibreOffice inquiry

On Sun, Nov 25, 2012 at 2:38 PM, John Kane jrkrid...@inbox.com wrote: Can you supply a link for ROOo ? I don't see it anywhere. Oh, sorry. I thought it was obvious: http://rcom.univie.ac.at/download.html#ROOo Also what do you mean OpenOffice is deprecated? Do you mean in terms of using it

[R] Rexcel question

I am using the worksheet functions of RExcel. I am trying to pass a datatable to a function in the following call: =RApply(O14:O18,D6) Cells O14:O18 contain the definition of the function. This is a function that takes one argument which is a data.table. Cell D6 has the name of the

[R] 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

[R] 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

Re: [R] RExcel

Don't they have their own support mailing list? You should review their documentation for specifics. -- David. On Aug 10, 2011, at 12:24 PM, Dr. Alireza Zolfaghari wrote: 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

Re: [R] [RExcel] please help me to set up RExcel via a remote server

statconnDCOM and RExcel have their own mailing list. Please subscribe at rcom.univie.ac.at and post you question there. On Jun 17, 2011, at 7:55 AM, Takatsugu Kobayashi wrote: Hi RUsers, I am currently tying to use RExcel via R installed in my remote server (CentOS 5.5). Could you please

[R] [RExcel] please help me to set up RExcel via a remote server

Hi RUsers, I am currently tying to use RExcel via R installed in my remote server (CentOS 5.5). Could you please help me set up a R remote server? All I know about the server is its IPAddress. Apologies for my fundamental question. Thank you so much! Taka

Re: [R] RExcel

From: Jonathan P Daily jda...@usgs.gov Cc: r-help r-help@r-project.org; r-help-boun...@r-project.org Sent: Mon, April 11, 2011 11:39:12 AM Subject: Re: [R] RExcel It is asking the obvious, but did you run the commands from the rcom package after installation (see inline ***s

[R] RExcel

Hi, I am installing Excel using package RExcelInstaller. When I tried to run installRExcel() I got this error message: You don not have the R package rcom installed. The (D)COM server installed which will aloow you to use the background server in RExcel. Since rcom is not installed,

Re: [R] RExcel

when its empty? Does the room, the thing itself have purpose? Or do we, what's the word... imbue it. - Jubal Early, Firefly r-help-boun...@r-project.org wrote on 04/11/2011 02:08:02 PM: [image removed] [R] RExcel array chip to: r-help 04/11/2011 02:12 PM Sent by: r

Re: [R] RExcel

: [R] RExcel It is asking the obvious, but did you run the commands from the rcom package after installation (see inline ***s)? -- Jonathan P. Daily Technician - USGS Leetown Science Center 11649 Leetown Road Kearneysville WV, 25430 (304) 724-4480 Is the room still

[R] 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

Re: [R] Rexcel path problem

Jorge, This looks like an R on Windows problem, it is unrelated to VBA. You have the statement (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) which is invalid R. You need to use either forward slashes or double-back-slashes in R commands. See the R for Windows

Re: [R] Rexcel path problem

On 01-04-2011, at 16:12, Jorge Nieves wrote: 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

Re: [R] Rexcel path problem

Use / instead of \ in the path. --- Jeff Newmiller The . . Go Live... DCN:jdnew...@dcn.davis.ca.us Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with

Re: [R] Rexcel path problem

/rbdd_jsmp.aspx - Original Message From: Jorge Nieves jorge.nie...@moorecap.com To: r-h...@stat.math.ethz.ch Sent: Fri, April 1, 2011 7:12:39 AM Subject: [R] 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

[R] Rexcel for mac

Is there anything out there which replicates the functionality of RExcel on a mac? I have Excel for mac, and would just like something which makes its easy to put sheets into R as a dataframe etc. __ R-help@r-project.org mailing list

Re: [R] Rexcel for mac

On Feb 4, 2011, at 4:36 AM, Clayton Coffman wrote: Is there anything out there which replicates the functionality of RExcel on a mac? I have Excel for mac, and would just like something which makes its easy to put sheets into R as a dataframe etc. On OSX, I believe that the two primary

Re: [R] Rexcel for mac

On Fri, Feb 4, 2011 at 5:36 AM, Clayton Coffman clayton.coff...@gmail.com wrote: Is there anything out there which replicates the functionality of RExcel on a mac?  I have Excel for mac, and would just like something which makes its easy to put sheets into R as a dataframe etc. See:

Re: [R] RExcel doesn't get active dataset

Please subscribe to the rcom mailing list at rcom.univie.ac.at RExcel questions are handled on that list. On 12/20/2010 9:24 PM, jryan.dani...@gmail.com wrote: Hey everyone When I try to 'get active dataframe' from the context menu in excel using Rcmdr menus in excel, only the header and

[R] RExcel doesn't get active dataset

Hey everyone When I try to 'get active dataframe' from the context menu in excel using Rcmdr menus in excel, only the header and first row of data gets copied to the excel spread sheet. No clue why this is happening. I followed the instructions from 'R through Excel' pg 25-26. I'm using excel

[R] 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

[R] Rexcel

Hello, I am trying to use RExcel and I would like to know if it is possible to use in excel the following function I made for R Pron = function(path=C:\\Quantil Aplicativos\\Genercauca\\V5\\){ library(timeSeries) library(maSigPro) ### CARGAR FUNCIONES

Re: [R] Rexcel

22, 2010 8:11:39 PM Subject: [R] 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

Re: [R] Rexcel

Em 22/11/2010 10:11, Luis Felipe Parra escreveu: 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

Re: [R] Rexcel

a) RExcel has its own mailing list (as the documentation tell you). Please post RExcel related questions to the mailing list accessible at rcom.univie.ac.at b) For running code at startup, you have to create a worksheet (not a workbook) named RCode in your workbook. On 11/22/2010 7:15 PM,

[R] 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

Re: [R] RExcel: Sctools not available

Please post any qeustions regarding RExcel to the rcom-l mailing list. You can subscribe at rcom.univie.ac.at On Aug 9, 2010, at 1:42 PM, Andreas Scherer wrote: 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

[R] Rexcel dataframe import adds 23:00:00 to dates

I construct a 2 x 2 table in Excel which contains the following: Date Value 12/31/20081.0 If I transfer this range to Rexcel with a put dataframe operation to a variable x, then x$Date is displayed as Date 1 2008-12-30 23:00:00 The datetime value is

Re: [R] RExcel + RCOM + Linux

Remote server has to be a Windows machine also. RExcel uses (D)COM which is Windows-specific On 2/22/2010 9:14 AM, Philipp Rappold wrote: Dear all, does anyone know if it is possible to connect a Windows RExcel instance to a linux R instance? Within Rexcel, I find the option Remote

[R] RExcel + RCOM + Linux

Dear all, does anyone know if it is possible to connect a Windows RExcel instance to a linux R instance? Within Rexcel, I find the option Remote Server Address, but I wonder what the installation procedure on my linux (ubuntu) R looks like (if possible at all)? Thanks Philipp

[R] 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

Re: [R] RExcel

Please post this kind of questions to the rcom mailing list. You can subscribe at rcom.univie.ac.at __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide

[R] RExcel/ RCom

Hi All Apologies if this is not the correct mailing list for this question. I have installed RExcel and RCom from CRAN. R is indicating that I need an additional file/package statconnDCOM from rcom.univie.ac.at I have been trying to access this website over the last 2 days be it appears to

[R] 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

[R] 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

[R] RExcel foreground and background server

Dear all, I have a question regarding background and foreground server in RExcel: Can somebody explain the main difference between them? As far as I understood from the RExcel webpage, for both of them one needs rights for access to Windows registries. The only difference that I can see so far

[R] 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

[R] RExcel - foreground server

Hi, I have a problem using RExcel with a foreground server: in RExcel menu as well as in the window called by set server the foreground server option is grayed out. I have installed the rcom package and also tried to open R and type require(rcom), as explained on