Re: [R] RExcel issues

[Michael Ashton]

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 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

[Michael Ashton]

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 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

[David Winsemius]

> 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

[Michael Ashton]

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

[Rui Barradas]

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

[Jeff Newmiller]

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

[Erich Neuwirth]

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

[Geddam Siddharth]

*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]

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

[Liviu Andronic]

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

[John Kane]

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

[Liviu Andronic]

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

[blue honour]

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

[kball_ea]

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

[Dr. Alireza Zolfaghari]

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

[David Winsemius]

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

[Erich Neuwirth]

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

[Takatsugu Kobayashi]

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

[Erich Neuwirth]

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

[array chip]

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

[Jonathan P Daily]

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

[array chip]

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

[Jorge Nieves]

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

[Richard M. Heiberger]

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

[Berend Hasselman]

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

[Jeff Newmiller]

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

[Felipe Carrillo]

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

[Clayton Coffman]

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

[Marc Schwartz]

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

[Gabor Grothendieck]

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

[Erich Neuwirth]

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

[jryan . daniels]

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

[Luis Felipe Parra]

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

[Luis Felipe Parra]

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

[Stephen Liu]

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

[csrabak]

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

[Erich Neuwirth]

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

[Andreas Scherer]

 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

[Erich Neuwirth]

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

[Peter Quirk]

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

[Erich Neuwirth]

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

[Philipp Rappold]

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

[Benjamin Ward]

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

[Erich Neuwirth]

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

[Brecknock, Peter]

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

[Chiquoine, Ben]

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

[joseph . g . boyer]

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

[Irina Ursachi]

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

[Rahul-A.Agarwal]

 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

[Werner Wernersen]

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.