[R] Excel *.xls files, RODBC

Rajarshi Guha rxg218 at psu.edu
Sat Dec 4 19:38:17 CET 2004


On Sat, 2004-12-04 at 14:32 -0400, Rolf Turner wrote:
> Chuck Cleland wrote:
> 
> > The following works for me under WinXP Pro to create "myframe" as a 
> > data frame:
> > 
> > library(RODBC)
> > z <- odbcConnectExcel("c:/myfolder/mydata.xls")
> > myframe <- sqlFetch(z, "Sheet1")
> > close(z)
> 
> It would appear then, that there is NO WAY to read Excel files into R
> save by transporting them to a Windoze system, saving them as .csv
> files and then transporting these back reading them into R.  A bit
> unsatisfactory, but it ***is*** a workaround.

To stay on Linux one possibility would be to use perl:
http://www-106.ibm.com/developerworks/linux/library/l-pexcel/




More information about the R-help mailing list