[R] How to use read.xls in R

[Francisco J. Zagmutt]

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