[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