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 <[EMAIL PROTECTED]> 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.
