Re ad & name multiple excel sheets using RODBC
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 limitations in the non-commercial version.
what limitations, i.e. features do you miss?
Reading of named ranges. Dieter
Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459