[R] Re ad & name multiple excel sheets using RODBC
dieter.menne at menne-biomed.de
Thu May 28 14:40:09 CEST 2009
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.
filepath <- "workbook.xlsx"
tabls = list()
channel <- odbcConnectExcel2007(filepath)
for (i in 1:2)
tabls[[i]] = sqlQuery(channel, paste("SELECT * from
odbcClose(channel) # I prefer an explicit odbcClose, but generic close.RODBC
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.
More information about the R-help