Folks: An additional issue is that worksheet names must conform to ODBC/SQL standards; so, for example, Excel permits worksheet names with embedded spaces, but RODBC does not handle them (or at least, I was not able to get to to do so), as this is not permitted in the standards.
-- Bert Gunter Genentech Non-Clinical Statistics South San Francisco, CA "The business of the statistician is to catalyze the scientific learning process." - George E. P. Box > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chuck Cleland > Sent: Saturday, December 04, 2004 7:10 AM > To: Rolf Turner > Cc: [EMAIL PROTECTED] > Subject: Re: [R] Excel *.xls files, RODBC > > 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) > > Are you indicating the name of the worksheet you want within the > *.xls file? I suspect there could be additional issues on a > non-Windows > OS that I don't know about. > > hope this helps, > > Chuck Cleland > ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
