Message-
From: roger bos [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 6:14 AM
To: Ko-Kang Kevin Wang
Cc: R-help@stat.math.ethz.ch
Subject: Re: [R] there is no xls reader in R?
I like to use the RODBC package for doing this. Here is my
code sample:
xls
Have a look at the read.xls() in gdata package.
HTH,
Kevin
Michael wrote:
Currently I have to convert all my xls into csv before I can read it in
and process the excel data in R...
Is there a way to directly read in xls data?
Thanks a lot!
[[alternative HTML version deleted]]
I like to use the RODBC package for doing this. Here is my code sample:
xls - odbcConnectExcel(fname)
rawdata.temp - sqlFetch(xls, rawdata, max=2800)
close(xls)
fname is the full path to the file and rawdata is the name of the excel
sheet I want to import. I tried one
Just one other thought. There is a command line program
called xlHtml that you can find via google that will convert xls files to csv
and its used like this assuming you have placed it
somewhere in your path:
read.csv(pipe(xlHtml -te -xc:1-10 -csv myfile.xls))
Its handy since its just a
On Thu, Apr 20, 2006 at 12:29:58PM -0400, Gabor Grothendieck wrote:
Just one other thought. There is a command line program
called xlHtml that you can find via google that will convert xls files to csv
and its used like this assuming you have placed it
somewhere in your path:
Currently I have to convert all my xls into csv before I can read it in
and process the excel data in R...
Is there a way to directly read in xls data?
Thanks a lot!
[[alternative HTML version deleted]]
__
R-help@stat.math.ethz.ch mailing
Read the manual _R Data Import/Export_ which is shipped with R.The
section 8 Reading Excel spreadsheets will tell what you want.
2006/4/20, Michael [EMAIL PROTECTED]:
Currently I have to convert all my xls into csv before I can read it in
and process the excel data in R...
Is there a way to
See:
http://finzi.psych.upenn.edu/R/doc/manual/R-data.html#Reading-Excel-spreadsheets
Also the RDCOMClient package (find it via google) and rcom (on CRAN)
can control Excel from R and can be used.
On 4/19/06, Michael [EMAIL PROTECTED] wrote:
Currently I have to convert all my xls into csv