Re: [R] How to use read.xls in R

From: Francisco J. Zagmutt <gerifalte28_at_hotmail.com>
Date: Fri 08 Dec 2006 - 00:52:22 GMT

Or alternatively you can use xlsReadWrite package

install.packages(xlsReadWrite)
library(xlsReadWrite)
read.xls("sampledata.xls")

Regards,

Francisco

Dr. Francisco J. Zagmutt
College of Veterinary Medicine and Biomedical Sciences Colorado State University

Gabor Grothendieck wrote:
> You need perl installed for it to work.
> Although you normally would not need to use them note the
> verbose= and perl= arguments on the read.xls command.
>
> If you don't want to install perl try using RODBC:
>
> library(RODBC)
> z <- odbcConnectExcel("/a.xls")
> dd <- sqlFetch(z,"Sheet1")
> close(z)
>
>
> On 12/7/06, Lisa Wang <lisawang@uhnres.utoronto.ca> wrote:
>> Hello there,
>>
>> In gdata package, read.xls is to be used for reading excel data (from
>> windows).
>> The following is my code:('C:/session/sampledata.xls' is where the file
>> is stored)
>>
>> data1<-read.xls('C:/session/sampledata.xls',sheet=1)
>>
>> and I got the following error message:
>> Error in system(cmd, intern = !verbose) : perl not found
>>
>> Could you please tell me what I have done wrong and how I should do it?
>>
>> Thanks a lot
>>
>> Lisa Wang
>> Princess Margaret Hospital, Toronto, Ca
>> tel:416 946 4551
>>
>> ______________________________________________
>> R-help@stat.math.ethz.ch 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@stat.math.ethz.ch 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@stat.math.ethz.ch 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. Received on Fri Dec 08 11:57:29 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 08 Dec 2006 - 01:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.