[R] Re ad & name multiple excel sheets using RODBC

[Dieter Menne]

simeon duckworth wrote:
> 
> I'd like to be able to read multiple sheets from an excel workbook and use
> the sheet name to name the resulting dataframe using RODBC.  
> 

In Microsoft theory, something like the below should be ok (note the $), but
never managed to get this to work. The same method works perfectly when you
have name ranges within a spreadsheet.

If you only have the sheet names, you should use package xlsReadWrite which
is rather fast, but has some limitations in the non-commercial version.

Dieter


library(RODBC)
filepath <- "workbook.xlsx"
tabls  = list()
channel <- odbcConnectExcel2007(filepath)
for (i in 1:2)
  tabls[[i]] =  sqlQuery(channel, paste("SELECT * from
[Tabelle",i,"$]",sep=""))
odbcClose(channel) # I prefer an explicit odbcClose, but generic close.RODBC
should work.



-- 
View this message in context: http://www.nabble.com/Read---name-multiple-excel-sheets-using-RODBC-tp23760020p23760912.html
Sent from the R help mailing list archive at Nabble.com.