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

2009-05-28 Thread Erich Neuwirth
Using the package rcom (by Thomas Baier) you can do everything you want since you have the full power of COM at your disposal. Dieter Menne wrote: > > > Hans-Peter Suter wrote: >>> If you only have the sheet names, you should use package xlsReadWrite >>> which >>> is rather fast, but has some l

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

2009-05-28 Thread Dieter Menne
Hans-Peter Suter wrote: > >> 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. > > what limitations, i.e. features do you miss? > > Reading of named ranges. Dieter -- View this message

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

2009-05-28 Thread Hans-Peter Suter
2009/5/28 Dieter Menne : > 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. what limitations, i.e. features do you miss? Cheers, Hans-Peter __ R-help@r

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

2009-05-28 Thread 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 met