Re: [Rcom-l] Installing RExcel on a windows machine with Excel 2002(sp3)
I still do not understand exactly what happens
in your problem.
I do not get any output displayed either in Excel or in
R when I do something like this.
Please describe in detail what you are doing.
D'Antuono, Mario wrote:
> Sorry Erich.
>
> I thought it was the latest version RandFriends v2072 3.0-3 that we were
> installing? from your WIKI page?
>
> I guess my question is why does RExcel need to set Rserver when it should be
> part of the installation?
>
> My colleague managed to go down the RExcel menu and set the Rserver. Hurrah!
> Thanks for your very good RExcel help file.
>
> As explained in my email she was using an IBM R50 laptop running Windows XP
> 2002 SP3 and Excel 2002 sp3.
>
> All ok now. I am now aware of what to do if anything goes wrong. But not sure
> why Rserver is not set?
> Thank you.
>
>
> Secondly, do you want me to send the second query to a separate email to the
> RCOM newsgroup?
> i have this data set and i selected the following lines in Excel sheet and I
> said Run R in via REXCEL menu
>
>
> eg1 = read.csv('eg1.csv',header=TRUE)
> aov1= aov(yield~ factor(Treatment)+factor(Block),data=eg1)
> anova(aov1)
>
> eg1.csv has 12 records
> plot Block Treatment yield
> 1 1 D 4.6
> 2 1 A 7.3
> 3 1 C 5.5
> 4 1 B 6.3
> 5 2 A 6.6
> 6 2 C 5.4
> 7 2 D 4.1
> 8 2 B 5.9
> 9 3 B 5.6
> 10 3 D 3.5
> 11 3 C 4.9
> 12 3 A 6
>
> WHY DOES RExcel echo the data as well as each instruction? Can i switch this
> off? i tried options(ECHO=FALSE) in R program but to no avail? Your advice
> please?
>
> Kind regards,
> Mario.
>
>
> This e-mail and files transmitted with it are privileged and confidential
> information
> intended for the use of the addressee. The confidentiality and/or privilege
> in this e-mail is
> not waived, lost or destroyed if it has been transmitted to you in error. If
> you received this
> e-mail in error you must
> (a) not disseminate, copy or take any action in reliance on it;
> (b) please notify the Department of Agriculture and Food, WA immediately by
> return e-mail to the sender;
> (c) please delete the original e-mail.
>
> This email has been successfully scanned by
> McAfee Anti-Virus software.
> Department of Agriculture and Food WA
>
>
>
>
> ___
> Rcom-l mailing list
> [email protected]
> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
> More information (including a Wiki) at http://rcom.univie.ac.at
>
>
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.173 / Virus Database: 270.7.5/1706 - Release Date: 10/3/2008
> 6:17 PM
>
--
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
___
Rcom-l mailing list
[email protected]
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
RE: [Rcom-l] Installing RExcel on a windows machine with Excel 2002(sp3)
Sorry Erich.
I thought it was the latest version RandFriends v2072 3.0-3 that we were
installing? from your WIKI page?
I guess my question is why does RExcel need to set Rserver when it should be
part of the installation?
My colleague managed to go down the RExcel menu and set the Rserver. Hurrah!
Thanks for your very good RExcel help file.
As explained in my email she was using an IBM R50 laptop running Windows XP
2002 SP3 and Excel 2002 sp3.
All ok now. I am now aware of what to do if anything goes wrong. But not sure
why Rserver is not set?
Thank you.
Secondly, do you want me to send the second query to a separate email to the
RCOM newsgroup?
i have this data set and i selected the following lines in Excel sheet and I
said Run R in via REXCEL menu
eg1 = read.csv('eg1.csv',header=TRUE)
aov1= aov(yield~ factor(Treatment)+factor(Block),data=eg1)
anova(aov1)
eg1.csv has 12 records
plot Block Treatment yield
11 D 4.6
21 A 7.3
31 C 5.5
41 B 6.3
52 A 6.6
62 C 5.4
72 D 4.1
82 B 5.9
93 B 5.6
10 3 D 3.5
11 3 C 4.9
12 3 A 6
WHY DOES RExcel echo the data as well as each instruction? Can i switch this
off? i tried options(ECHO=FALSE) in R program but to no avail? Your advice
please?
Kind regards,
Mario.
This e-mail and files transmitted with it are privileged and confidential
information
intended for the use of the addressee. The confidentiality and/or privilege in
this e-mail is
not waived, lost or destroyed if it has been transmitted to you in error. If
you received this
e-mail in error you must
(a) not disseminate, copy or take any action in reliance on it;
(b) please notify the Department of Agriculture and Food, WA immediately by
return e-mail to the sender;
(c) please delete the original e-mail.
This email has been successfully scanned by
McAfee Anti-Virus software.
Department of Agriculture and Food WA
<>___
Rcom-l mailing list
[email protected]
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
Re: [Rcom-l] Installing RExcel on a windows machine with Excel 2002 (sp3)
This can have a few different reasons.
To be able do diagnose we need more details.
Which version of RAndFriends, which version of Windows,
which version of Excel?
Was RExcel installed from the same account (admin account)
as it then was started?
Your example code is not enough to understand what your problem ist.
It is 2 lines of R code.
How did you want to get the data to R?
How did you run the code?
Mario D'Antuono wrote:
> Dear all,
>
> I discussed with Erich and he suggested that all problems or queries be
> sent to the list.
>
> So this is my first time here and i am still unsure of protocols and if
> there is any FAQ available. i do not like to search the Rcom archives
> because I do not know the keywords to use.
>
> (i) I installed the HUGE RandFriends setup and it worked BEAUTIFULLY on
> my IBM Thinkcentre with Excel 2002 (sp3) with high security in Excel for
> macros. NO need to do anything!
>
> But I am trying to get RExcel to work on other Windows machines in my
> Department. But we have many people with a variety of windows machines
> and of varying manufacturers and probably of so many versions of Excel?
>
> SO 1 of my collegues who is an office 800km away has an IBM R50 laptop
> and she got the following error when she tried to Start R from RExcel
> window after following my installation notes.
>
>
> The image in the email says "No R server configured. Please set RServer
> to work with RExcel."
>
> What does this mean? I am not an Excel person nor Rserver person? I was
> hoping that the basic installation of RandFriends would have configured
> everything?
>
> I just want use it to enter data and then let my people use R to analyse
> it via the RExcel menu. I do not want my colleagues who are agricultural
> scientists to be computer experts. I went to the RExcel menu and then
> trying various tricks with Set Rserver (like foreground, Rgui, etc and
> jiggling by guesses) and i got R to talk to RExcel.
>
> I can jiggle to get this to work but is there an easy installation
> option that is not set properly so that a non-statistician/mathematician
> can get this to easily work? Have i missed a help page somewhere? There
> are so many things to learn and obviously if there is a simple FAQ like
> in R that might give me a way to point people to that info?
>
> For example why did my installation work ok? I did not have to go and
> set RServer?
>
> I think people need a simple set of steps and hopefully just get in the
> car and drive. The simple steps are to make sure there is petrol, water,
> oil, battery and and tyres are OK and then GO! i am not a mechanic just
> a user.
>
> Please tell me what is wrong with my installation and why it has not set
> the Rserver on a different machine?
>
> Sorry if i do not really want to learn about how it works but just run
> it. Life is too short to be worrying about the how the machine is
> constructed etc.
>
> I just want to install the beautiful setup file from Erich and start
> RExcel and GO!
>
> Your advice and help is much appreciated.
>
> (ii) If i may be bold to ask 1 more question in this email please?
>
> I have a simple example
> setwd('c:/mydir')
> eg1 = read.csv('test.csv',header=TRUE)
>
> test.csv has 2 lines
> x,y
> 1,2
>
> Why does RExcel return the data matrix when i did not say print(eg1) to
> the R output in Excel? I even tried making a function to return
> invisible (x) after the read.csv function in my function?
>
> Suppose i had 100,00 records ? would it return 100,000 cells to Excel?
> A!
>
> Your help most appreciated and of course the RExcel work is of most
> interest to me and my 300 colleagues/customers in my department all over
> Western Australia!
>
> M.
>
> Mario D'Antuono
> -
> Biometrician
> Department of Agriculture and Food
> Government of Western Australia
> 3 Baron-Hay Court
> South Perth 6151 Western Australia
> -
> Telephone (08) 9368 3848
> Mobile 0400 576 764
> www.agric.wa.gov.au/biometrics
>
>
>
>
>
>
>
> This e-mail and files transmitted with it are privileged and
> confidential information
> intended for the use of the addressee. The confidentiality and/or
> privilege in this e-mail is
> not waived, lost or destroyed if it has been transmitted to you in
> error. If you received this
> e-mail in error you must
> (a) not disseminate, copy or take any action in reliance on it;
> (b) please notify the Department of Agriculture and Food, WA immediately
> by return e-mail to the sender;
> (c) please delete the original e-mail.
>
> This email has been successfully scanned by
> McAfee Anti-Virus software.
> Department of Agriculture and Food WA
>
>
>
>
> _
