[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