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
Lisa Wang said the following on 12/7/2006 3:01 PM:
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
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)
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