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?
> Ahhhhhhhhhhhhhhhh!
>
> 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 <http://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
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Rcom-l mailing list
> Rcom-l@mailman.csd.univie.ac.at
> 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/1702 - Release Date: 10/1/2008
> 9:05 AM
>
--
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
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
