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 Winsemiuswrote: > > >> 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 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 some kind of OLE error. I can't seem to >> find anything about it online and it's hard to replicate for someone else >> since you'd have to have my installation and my spreadsheet. >> >> But I thought I'd ask the community and see if anyone else has had this >> problem recently with Rexcel. I'm calling solnp from within the RRun >> command, but again...it worked for a long time and I don't think it's the >> inputs that are wonky. Perhaps an update of R was incompatible with Rexcel? >> I've updated Rexcel to 3.2.16 but it made no difference. > > I'm pretty sure that RExcel is a commercial program and I assume that > licensed users are expected to bring problems to the vendor. > > http://rcom.univie.ac.at/contact.html > > >> >> Any suggestions of what to try will be warmly entertained! >> >> Thanks, >> >> Mike >> >> Michael Ashton, CFA >> Managing Principal >> >> Enduring Investments LLC >> W: 973.457.4602 >> C: 551.655.8006 > > I assume with that address you have a commercial license. > > -- > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' > -Gehm's Corollary to Clarke's Third Law > > > > __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 Winsemiuswrote: > > >> 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 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 some kind of OLE error. I can't seem to >> find anything about it online and it's hard to replicate for someone else >> since you'd have to have my installation and my spreadsheet. >> >> But I thought I'd ask the community and see if anyone else has had this >> problem recently with Rexcel. I'm calling solnp from within the RRun >> command, but again...it worked for a long time and I don't think it's the >> inputs that are wonky. Perhaps an update of R was incompatible with Rexcel? >> I've updated Rexcel to 3.2.16 but it made no difference. > > I'm pretty sure that RExcel is a commercial program and I assume that > licensed users are expected to bring problems to the vendor. > > http://rcom.univie.ac.at/contact.html > > >> >> Any suggestions of what to try will be warmly entertained! >> >> Thanks, >> >> Mike >> >> Michael Ashton, CFA >> Managing Principal >> >> Enduring Investments LLC >> W: 973.457.4602 >> C: 551.655.8006 > > I assume with that address you have a commercial license. > > -- > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' > -Gehm's Corollary to Clarke's Third Law > > > > __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 some kind of OLE error. I can't seem to > find anything about it online and it's hard to replicate for someone else > since you'd have to have my installation and my spreadsheet. > > But I thought I'd ask the community and see if anyone else has had this > problem recently with Rexcel. I'm calling solnp from within the RRun command, > but again...it worked for a long time and I don't think it's the inputs that > are wonky. Perhaps an update of R was incompatible with Rexcel? I've updated > Rexcel to 3.2.16 but it made no difference. I'm pretty sure that RExcel is a commercial program and I assume that licensed users are expected to bring problems to the vendor. http://rcom.univie.ac.at/contact.html > > Any suggestions of what to try will be warmly entertained! > > Thanks, > > Mike > > Michael Ashton, CFA > Managing Principal > > Enduring Investments LLC > W: 973.457.4602 > C: 551.655.8006 I assume with that address you have a commercial license. -- David Winsemius Alameda, CA, USA 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 started blowing up, returning #RErrors, and when I try to trace the error I find that it is some kind of OLE error. I can't seem to find anything about it online and it's hard to replicate for someone else since you'd have to have my installation and my spreadsheet. But I thought I'd ask the community and see if anyone else has had this problem recently with Rexcel. I'm calling solnp from within the RRun command, but again...it worked for a long time and I don't think it's the inputs that are wonky. Perhaps an update of R was incompatible with Rexcel? I've updated Rexcel to 3.2.16 but it made no difference. Any suggestions of what to try will be warmly entertained! Thanks, Mike Michael Ashton, CFA Managing Principal Enduring Investments LLC W: 973.457.4602 C: 551.655.8006 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 file into excel? Rui Barradas Em 22-08-2013 15:57, siddhartha.ged...@eclerx.com escreveu: Hi Rui thanks a lot for your reply for my previous query, was of great help to me. I am facing one last query on the following given issue. 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 can I import the output table at the end of the code from RExcel to Excel using Rexcel Macros? Other option I have tried is: Rinterface.getarray “etszP”, Range(“Sheet1!Z1”) The output in this case is not in the desired format. _ Sent from http://r.789695.n4.nabble.com __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/BatteriesO.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --- Sent from my phone. Please excuse my brevity. Rui Barradas ruipbarra...@sapo.pt wrote: 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 file into excel? Rui Barradas Em 22-08-2013 15:57, siddhartha.ged...@eclerx.com escreveu: Hi Rui thanks a lot for your reply for my previous query, was of great help to me. I am facing one last query on the following given issue. 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 can I import the output table at the end of the code from RExcel to Excel using Rexcel Macros? Other option I have tried is: Rinterface.getarray “etszP”, Range(“Sheet1!Z1”) The output in this case is not in the desired format. _ Sent from http://r.789695.n4.nabble.com __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 RExcel. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 - ts(zz,freq=365,start=c(2009,1)) etsz - ets(zz,model='AAN') etszP - forecast(etsz,h=34) *write.table(etszP)* How can I import the output table at the end of the code from RExcel to Excel using Rexcel Macros? Other option I have tried is: Rinterface.getarray etszP, Range(Sheet1!Z1) The output in this case is not in the desired format i.e not in the form of a table, the values are displayed horizontally separated by commas, making it possible to separate them even with a delimiter. -- Regards, G.Siddharth Phone: +91 8698902787 MBA (Marketing) 2011-13* **SCMHRD** | Symbiosis Centre for Management and Human Resource Development* -- *Disclaimer: The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited, and all liability arising therefore is disclaimed. If you received this in error, please contact the sender and delete the material from any computer. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email. Please be aware that the entire content of this e-mail and replies to it may be monitored by the sender's institution for quality assurance, policy compliance and/or security purposes.* * * [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 It should have been. I must need new glasses. Also what do you mean OpenOffice is deprecated? Do you mean in terms of using it with ROOo? Otherwide OOo, now under new management at Apache is under active development under the name Apache Open Office. Sun/Oracle discontinued developing OOo and donated it to Apache, which to my surprise made a recent release. However many Linux distros switched to LibreOffice, originally forked from OOo in 2010. To my understanding LibO is the project that should be followed by end-users. I am not a close follow of the AOO/LibreOffice saga but as far as I know there are good points to each and certainly from my reading of the OOo forums there is no particular reason in general to go with one or the other. Each one has its own peculiarities and minor bugs so which to use seems a matter of personal pereference and specific need at any givin point in time. I suspect the move to LibreOffice with many distros was more a pollcy decision when OOo 's fate was in question. Since the Apache move, it looks like AOO is going to be quite viable. I think that LibreOffice offers a bit better compatibility with MS products. I use both on Ubuntu 12.10 quite happily. Since ROOo is beta and rather outdated, I was wondering if there were an effort to bring an RExcel-like functionality to recent LibO or Gnumeric releases. Not the slightest idea about that. Sorry I cannot help. You might want to post a question on one of the OOo forums about it. I did not see ROOo in the AOO extensions bank so I'd be worried about it. Regards Liviu FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family! Visit http://www.inbox.com/photosharing to find out more! __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 OpenOffice equivalent of RExcel, but in this case the problem is that the only release available is a beta version from 2009. I wouldn't want to use that for any serious work, nor I am sure that it works with LibreOffice (as OpenOffice is deprecated). Thus is anyone aware of a cross-platform Gnumeric or LibreOffice solution that emulates what RExcel does for Excel on Windows? Regards Liviu -- Do you know how to read? http://www.alienetworks.com/srtest.cfm http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader Do you know how to write? http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RExcel, ROOo and LibreOffice inquiry
Can you supply a link for ROOo ? I don't see it anywhere. Also what do you mean OpenOffice is deprecated? Do you mean in terms of using it with ROOo? Otherwide OOo, now under new management at Apache is under active development under the name Apache Open Office. John Kane Kingston 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 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 OpenOffice equivalent of RExcel, but in this case the problem is that the only release available is a beta version from 2009. I wouldn't want to use that for any serious work, nor I am sure that it works with LibreOffice (as OpenOffice is deprecated). Thus is anyone aware of a cross-platform Gnumeric or LibreOffice solution that emulates what RExcel does for Excel on Windows? Regards Liviu -- Do you know how to read? http://www.alienetworks.com/srtest.cfm http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader Do you know how to write? http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 with ROOo? Otherwide OOo, now under new management at Apache is under active development under the name Apache Open Office. Sun/Oracle discontinued developing OOo and donated it to Apache, which to my surprise made a recent release. However many Linux distros switched to LibreOffice, originally forked from OOo in 2010. To my understanding LibO is the project that should be followed by end-users. Since ROOo is beta and rather outdated, I was wondering if there were an effort to bring an RExcel-like functionality to recent LibO or Gnumeric releases. Regards Liviu __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 data.table object. When I call the function this way, D6 is passed to the function as a string, not as a data.table. So I get an error. How can I fix this? I know that there is a data.table in R workspace with this name... I just can't seem to pass it to the function... [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 know how to use R. In R to run my entire code I simply write on line: source(S:/Folder/FileName.R) As mentioned in RExcel I can run by selecting the cell and choosing Run Code. I have tried to write the macro for this operation as the following: Sub FindIndex() ' To run the price index in R Application.DisplayAlerts = False Rinterface.StartRServer Rinterface.RunRFile S:/Folder/FileName.R 'RInterface.StopRServer Application.DisplayAlerts = True End Sub But it returns the error Error when sourcing R file S:/Folder/FileName.R I have also tried a simple RInterface.RRun(source(S:/Folder/FileName.R)) But it did not work. Can anyone help me in writing this macro? Thanks in advance. -- View this message in context: http://r.789695.n4.nabble.com/RExcel-RunRFile-Errors-tp3800748p3800748.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 add-ins, I get the following sequentional errors: Errors: SCtools not available SCTools can not be loaded. could not start Rserver There seems to be no R proecess conneceted to Excel I used to install Rsrv200.exe, and do not know if I still need to install it in this version. Any help, please, thanks, Alireza [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 loaded. could not start Rserver There seems to be no R proecess conneceted to Excel I used to install Rsrv200.exe, and do not know if I still need to install it in this version. Any help, please, __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RExcel
rcom has its own mailing list. Please subscribe at rcom.univie.ac.at and post all questions there. On 4/12/2011 1:04 AM, array chip wrote: Yes, I did, and no error message. And comRegisterRegistry() returns NULL, not sure if that matters John 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)? -- Jonathan P. Daily Technician - USGS Leetown Science Center 11649 Leetown Road Kearneysville WV, 25430 (304) 724-4480 Is the room still a room 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-help-boun...@r-project.org 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, foreground mode will be unavailable. You may continue with the installation, but in most circumstances you probably should cancel current installation, install the package rcom properly (do not forget to run the commands library(rcom) comRegisterRegistry() immediately after installation) and after that run this installer once again But rcom package was installed without any problem, somehow the installer keeps saying that rcom is not installed. Any suggestions? Thanks John sessionInfo() R version 2.12.2 (2011-02-25) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 [2] LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] RExcelInstaller_3.1-13 rcom_2.2-3.1 rscproxy_1.3-1 loaded via a namespace (and not attached): [1] tools_2.12.2 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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, foreground mode will be unavailable. You may continue with the installation, but in most circumstances you probably should cancel current installation, install the package rcom properly (do not forget to run the commands library(rcom) comRegisterRegistry() immediately after installation) and after that run this installer once again But rcom package was installed without any problem, somehow the installer keeps saying that rcom is not installed. Any suggestions? Thanks John sessionInfo() R version 2.12.2 (2011-02-25) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 [2] LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] RExcelInstaller_3.1-13 rcom_2.2-3.1 rscproxy_1.3-1 loaded via a namespace (and not attached): [1] tools_2.12.2 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [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 a room 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-help-boun...@r-project.org 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, foreground mode will be unavailable. You may continue with the installation, but in most circumstances you probably should cancel current installation, install the package rcom properly (do not forget to run the commands library(rcom) comRegisterRegistry() immediately after installation) and after that run this installer once again But rcom package was installed without any problem, somehow the installer keeps saying that rcom is not installed. Any suggestions? Thanks John sessionInfo() R version 2.12.2 (2011-02-25) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 [2] LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] RExcelInstaller_3.1-13 rcom_2.2-3.1 rscproxy_1.3-1 loaded via a namespace (and not attached): [1] tools_2.12.2 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RExcel
Yes, I did, and no error message. And comRegisterRegistry() returns NULL, not sure if that matters John 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)? -- Jonathan P. Daily Technician - USGS Leetown Science Center 11649 Leetown Road Kearneysville WV, 25430 (304) 724-4480 Is the room still a room 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-help-boun...@r-project.org 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, foreground mode will be unavailable. You may continue with the installation, but in most circumstances you probably should cancel current installation, install the package rcom properly (do not forget to run the commands library(rcom) comRegisterRegistry() immediately after installation) and after that run this installer once again But rcom package was installed without any problem, somehow the installer keeps saying that rcom is not installed. Any suggestions? Thanks John sessionInfo() R version 2.12.2 (2011-02-25) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 [2] LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] RExcelInstaller_3.1-13 rcom_2.2-3.1 rscproxy_1.3-1 loaded via a namespace (and not attached): [1] tools_2.12.2 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the \T part of the path as an R command. It does not recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester() Rinterface.StartRServer Rinterface.RRun (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path) a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x %*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file = savefile) Rconsole message Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. Loading required package: rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape in character string starting source('X:\T Jorge Nieves [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 FAQ 2.16. Further RCOM questions should be addressed to the rcom list. You can sign up at rcom.univie.ac.at Rich On Fri, Apr 1, 2011 at 10:12 AM, Jorge Nieves jorge.nie...@moorecap.comwrote: 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 part of the path as an R command. It does not recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester() Rinterface.StartRServer Rinterface.RRun (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path) a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x %*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file = savefile) Rconsole message Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. Loading required package: rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape in character string starting source('X:\T Jorge Nieves [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://www.r-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 part of the path as an R command. It does not recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester() Rinterface.StartRServer Rinterface.RRun (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path) a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x %*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file = savefile) Rconsole message Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. Loading required package: rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape in character string starting source('X:\T R is just telling you that it doesn't recognize \T as a valid escape sequence in a character string. See R for Windows FAQ 2.16 and 5.1. Use \\ instead of a single \ as path separator or use the forward slash /. Berend __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --- Sent from my phone. Please excuse my brevity. Jorge Nieves jorge.nie...@moorecap.com 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 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 part of the path as an R command. It does not recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester() Rinterface.StartRServer Rinterface.RRun (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path) a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x %*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file = savefile) Rconsole messa ge Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. Loading required package: rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape in character string starting source('X:\T Jorge Nieves [[alternative HTML version deleted]]_ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Rexcel path problem
Jorge: You can run save your scripts in the same folder where your wokbook is and run it like this: Sub Scatter() Call rinterface.StartRServer 'Put the dataframe into R Call rinterface.PutDataframe(scatter, DownRightFrom(Range(RData!A1)), WithRowNames:=False) Call rinterface.RRun(attach(scatter)) 'Run the RScatter script rinterface.RunRFile ThisWorkbook.Path \RScatter.r Call rinterface.StopRServer End Sub I Felipe D. Carrillo Supervisory Fishery Biologist Department of the Interior US Fish Wildlife Service California, USA http://www.fws.gov/redbluff/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. 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 part of the path as an R command. It does not recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester() Rinterface.StartRServer Rinterface.RRun (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path) a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x %*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file = savefile) Rconsole message Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. Loading required package: rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape in character string starting source('X:\T Jorge Nieves [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 options will be: 1. The read.xls() function in the gdata package from CRAN. This requires Perl, which is installed by default on OSX. 2. Using RODBC from CRAN along with an ODBC driver from Actual Tech (http://www.actualtech.com/product_access.php). I believe that both will handle at least up through Office 2008 based files. I am not sure about Office 2011 however, if you have the latest version of Office for OSX. Also, as an FYI, there are two relevant R SIG lists: https://stat.ethz.ch/mailman/listinfo/r-sig-mac and https://stat.ethz.ch/mailman/listinfo/r-sig-db HTH, Marc Schwartz __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows -- Statistics Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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 2010, Rcmdr v 1.6-0 and R 2.11.1. Much appreciate any help Sent via my BlackBerry from Vodacom - let your email find you! __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 2010, Rcmdr v 1.6-0 and R 2.11.1. Much appreciate any help Sent via my BlackBerry from Vodacom - let your email find you! __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 source(paste(path,\\fUtilidades\\BackwardSelectionNC.r,sepfile://futilidades//BackwardSelectionNC.r%22,sep =)) source(paste(path,\\fUtilidades\\CriteriosDeComparacion.r,sepfile://futilidades//CriteriosDeComparacion.r%22,sep =)) dataTSORG-read.csv('entrada.csv', header = TRUE, sep = ,, quote=\, dec=.,fill = TRUE, comment.char=) dataTSORG = ts(dataTSORG, start=c(1950,1), frequency=12) dataTSORG = as.timeSeries(dataTSORG) X = prcomp(dataTSORG[,2:40])$x return(X) } Does somebody know if its possible? and if so how can I do it? Thank you Felipe Parra [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Rexcel
Hi, For RExcel I would suggest subscribing; http://mailman.csd.univie.ac.at/listinfo/rcom-l They have a website on; http://rcom.univie.ac.at/ B.R. Stephen L - Original Message From: Luis Felipe Parra felipe.pa...@quantil.com.co To: r-help r-help@r-project.org Sent: Mon, November 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 this? Thank you Felipe Parra [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 do this? Thank you Felipe, Look at the section Startup in the RExcel help. In a nutshell, if you want the code to run immediately at the loading of the spreadsheet, create a workbook called RCode and put your source there. Other options are available. See the docs. -- Cesar Rabak __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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, csrabak wrote: 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 do this? Thank you Felipe, Look at the section Startup in the RExcel help. In a nutshell, if you want the code to run immediately at the loading of the spreadsheet, create a workbook called RCode and put your source there. Other options are available. See the docs. -- Cesar Rabak __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 RCommander] icon., I get 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!! Could you please help me with this issue? Thank you very much. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 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: there seems to be no R process connected to excel though both r and excel starts after I click the Icon!! Could you please help me with this issue? Thank you very much. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific Computing University of Vienna [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 one hour less that it should be - i.e. it hasn't taken US Daylight Saving Time into account. My system locale is UTC-5 (Boston). I'm running R 2.10.1, RExcel 3.0.19, Excel 2007 (32-bit), Windows 7 Ultimate (64-bit). Is there a way to adjust the locale for Rexcel so it converts the date correctly? -- View this message in context: http://n4.nabble.com/Rexcel-dataframe-import-adds-23-00-00-to-dates-tp1735089p1735089.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 Server Address, but I wonder what the installation procedure on my linux (ubuntu) R looks like (if possible at all)? Thanks Philipp __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 downloaded RandFriends and have ran the binomial distribution process in 2007 Excel and have received an error that says: Compile error in hidden module: UFDBinomial However, ther are two demo excel files in the RExcel file called RdemoDens. When I open the first RDemoDens excel file, I can run the processes and they work fine. When I run the second RDemoDens excel file, or a blank excel 2007 file, the processes do not work and I get the error message. I am trying to figure out what is different about the first RDemoDens excel file that allows the calculations to process correctly. I am thinking that something in the macro library in the demo must be different than what is in a blank excel document. I just cannot seem to figure out what it is. One thing that I did notice is that there are two different RExcel files in the RExcel folder. One is labled RExcel and one is labed RExcel 2007. What are the difference between these two RExcel files? I am not sure if this has anything to do with the problem, but perhaps the excel demo in which our calculations work uses the correct RExcel file while a regular excel 2007 document does not call the correct one. If anyone has an idea about what might be happening here, or who else I could ask about the situation, I would appreciate any input. Thanks, Ben Ward [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
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 http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 be down. Does anyone know when this site is likely to be back up and/or know of an alternative source for the statconnDCOM file? Kind regards Pete This e-mail may contain confidential or proprietary information belonging to the BP group and is intended only for the use of the recipients named above. If you are not the intended recipient, please immediately notify the sender and either delete this email or return to the sender immediately. You may not review, copy or distribute this email. Within the bounds of law, this part of BP retains all emails and IMs and may monitor them to ensure compliance with BP's internal policies and for other legitimate business purposes. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 can then see an R Console open up and I get a message saying R Server not available. The weird thing is that the r console that opens up is R 2.7.1 and I did all of the installation of rcom and rexcel on R 2.7.2. I've tried uninstalling 2.7.1 but I get an error saying that it can not find the unistall file. Is it possilbe that When I installed R 2.7.2 I did something wrong that is causing this problem? If I start running R2.7.2 and then open excel and try using Rapply it works perfectly but I don't want to have to manually start R every time. The second question I have is in regards to using RApply to call R functions which rely on functions in other libraries. I've resorted to creating a function in my excel file which looks something like... Cell Function A1 getLibs-function(){ A2 library(MBESS) A3 library(corpcor) A4 } B1 =rproc(A1:A4) C1 =rApply(getLibs) Is their a better way to go about accomplishing this? Thanks in advance for any insights you have either of these quesitons Ben ___ This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are solely for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. If you have received this communication in error, please notify the sender immediately and delete this message from your system. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 macro will run through the second RunRFile command, but will not execute the Worksheet.Pictures.Insert statements or the GetArray statements until the user clicks OK on the dialog box. Any insight into how I can avoid the dialog box would be appreciated. The macro is below. It's your basic, send-to-R, run R, retrieve-from-R macro. Call Rinterface.StartRServer Call Rinterface.RRun(rm(list = ls())) Call Rinterface.RRun(dev.off()) Call Rinterface.PutArray(mat1, Range(DATA_INPUT_OUTPUT!B7:I506)) Call Rinterface.PutArray(mat2, Range(DATA_INPUT_OUTPUT!J7:Q506)) Call Rinterface.PutArray(cpd, Range(DATA_INPUT_OUTPUT!A7:A506)) Call Rinterface.PutArray(name_of_assay_one, Range(DATA_INPUT_OUTPUT!B1)) Call Rinterface.PutArray(name_of_assay_two, Range(DATA_INPUT_OUTPUT!B2)) Call Rinterface.RunRFile(C:\Program Files\R\MDR Programs\AM_ACT_Macros.R) Call Rinterface.RunRFile(C:\Program Files\R\MDR Programs\AM_ACT.R) Worksheets(GRAPHS).Range(B58).Select Worksheets(GRAPHS).Range(B58).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\var_means_both.jpg).Select Worksheets(GRAPHS).Range(B84).Select Worksheets(GRAPHS).Range(B84).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\var_means_one.jpg).Select Worksheets(GRAPHS).Range(B110).Select Worksheets(GRAPHS).Range(B110).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\var_means_two.jpg).Select Worksheets(GRAPHS).Range(B136).Select Worksheets(GRAPHS).Range(B136).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\normality_one.jpg).Select Worksheets(GRAPHS).Range(B162).Select Worksheets(GRAPHS).Range(B162).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\normality_two.jpg).Select Worksheets(GRAPHS).Range(B188).Select Worksheets(GRAPHS).Range(B188).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\one_two.jpg).Select Worksheets(GRAPHS).Range(B214).Select Worksheets(GRAPHS).Range(B214).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\pvalue_mean.jpg).Select Worksheets(GRAPHS).Range(B240).Select Worksheets(GRAPHS).Range(B240).Clear Worksheets(GRAPHS).Pictures.Insert(C:\TEMP\pvalue_hist.jpg).Select Call Rinterface.GetArray(pred_output$quant_one, Range(ASYM_MAX_ANALYSIS!A33:A37)) Call Rinterface.GetArray(pred_output$quant_two, Range(ASYM_MAX_ANALYSIS!I33:I37)) Call Rinterface.GetArray(sd_output$sd_one, Range(ASYM_MAX_ANALYSIS!B33:B37)) Call Rinterface.GetArray(sd_output$sd_two, Range(ASYM_MAX_ANALYSIS!J33:J37)) Call Rinterface.GetArray(sd_output$iqr_one, Range(ASYM_MAX_ANALYSIS!D33:D37)) Call Rinterface.GetArray(sd_output$iqr_two, Range(ASYM_MAX_ANALYSIS!L33:L37)) Call Rinterface.GetArray(pred_output$quant_one, Range(ASYM_MAX_ANALYSIS!A42:A46)) Call Rinterface.GetArray(pred_output$pred, Range(ASYM_MAX_ANALYSIS!C42:C46)) Call Rinterface.GetArray(pred_output$up_cb, Range(ASYM_MAX_ANALYSIS!I42:I46)) Call Rinterface.GetArray(pred_output$low_cb, Range(ASYM_MAX_ANALYSIS!K42:K46)) Call Rinterface.GetArray(sd_output$sd_ee[1], Range(ASYM_MAX_ANALYSIS!E50)) Call Rinterface.GetArray(pv_data$pool_sd, Range(ASYM_MAX_ANALYSIS!C55)) Call Rinterface.GetArray(pv_data$lin_sd_comb, Range(ASYM_MAX_ANALYSIS!D55)) Call Rinterface.GetArray(pv_data$const_sd_comb, Range(ASYM_MAX_ANALYSIS!I55)) Call Rinterface.GetArray(pv_data$CV_sd_comb, Range(ASYM_MAX_ANALYSIS!J55)) Call Rinterface.GetArray(pv_data$lin_sd_one, Range(ASYM_MAX_ANALYSIS!D58)) Call Rinterface.GetArray(pv_data$const_sd_one, Range(ASYM_MAX_ANALYSIS!I58)) Call Rinterface.GetArray(pv_data$CV_sd_one, Range(ASYM_MAX_ANALYSIS!J58)) Call Rinterface.GetArray(pv_data$lin_sd_two, Range(ASYM_MAX_ANALYSIS!D61)) Call Rinterface.GetArray(pv_data$const_sd_two, Range(ASYM_MAX_ANALYSIS!I61)) Call Rinterface.GetArray(pv_data$CV_sd_two, Range(ASYM_MAX_ANALYSIS!J61)) Call Rinterface.GetArray(pv_data$N_one, Range(ASYM_MAX_ANALYSIS!C64)) Call Rinterface.GetArray(pv_data$N_two, Range(ASYM_MAX_ANALYSIS!D64)) Call Rinterface.GetArray(pv_data$lin, Range(ASYM_MAX_ANALYSIS!I64)) Call Rinterface.GetArray(pv_data$FO, Range(ASYM_MAX_ANALYSIS!J64)) Call Rinterface.RRun(dev.off()) Call Rinterface.StopRServer Joe Boyer Statistical Sciences Renaissance Bldg 510, 3233-D Mail Stop RN0320 8-275-3661 cell: (610) 209-8531 [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal,
[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 is that for the installation of the background server, one needs the R(D)COM package, whereas for the foreground server installation, the rcom package is required. Further more, does anyone know, how Excel proccesses and R processes communicate? Is it possible for more than one Excel-process to communicate with more than one R process? Thank you in advance! Best regards, Irina Ursachi. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 (Device Independent Bitmap) [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[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 http://sunsite.univie.ac.at/rcom/excel/index.html, but it does not help. What am I missing? Many thanks, Werner __ Dem pfiffigeren Posteingang. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.