[R] there is no "xls" reader in R?

Gabor Grothendieck ggrothendieck at gmail.com
Thu Apr 20 18:29:58 CEST 2006


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 single file and in the situation that there is junk
on the first few lines of the spreadsheet you could use the skip= argument
to read.csv to skip over that.   I don't think the RODBC approach can
handle that.


On 4/20/06, Gabor Grothendieck <ggrothendieck at gmail.com> wrote:
> 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 <comtech.usa at gmail.com> 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]]
> >
> > ______________________________________________
> > 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
> >
>




More information about the R-help mailing list