[R] Excel *.xls files, RODBC

Marc Schwartz MSchwartz at MedAnalytics.com
Mon Dec 6 18:22:12 CET 2004


On Tue, 2004-12-07 at 04:09 +1100, James Muller wrote:
> There is also a perl module that converts excel files to .csv on CPAN. 
> It works fine for everything I've ever used it for, which is really 
> simple stuff, i.e. no cells defined by functions.
> 
> steps involved:
> 1. go to www.cpan.org and find the package, download it
> 2. ensure you have the necessary setup to do things with perl, otherwise 
> set them up
> 3. install the package
> 4. use it as the perl script instructs (i.e. <scriptname> --help or 
> something similar)
> 
> Cheers
> 
> James

There is also the read.xls() function in the gdata package, which is
part of the gregmisc bundle on CRAN.

HTH,

Marc Schwartz




More information about the R-help mailing list