[R] exportData(foo,"foo.xls","EXCEL") for R ?

[Dowle, Matthew [EQRE]]

Thanks for the reply. I do however need to create an .xls binary from R. The
system I'd like R to talk to only accepts .xls format files and this needs
to be automatic. I already have this working in S-PLUS and I was thinking of
porting to R. I saw the Excel-R-Interface mentioned in the archives so maybe
I could call Excel to load up the .csv and save as an .xls, but I'd prefer
to keep things simple if possible and write the .xls format directly from R.
Its got to be possible since Insightful managed to do it, now whether its
difficult??

Regards,
Matthew

-----Original Message-----
From: Thomas Lumley [mailto:tlumley at u.washington.edu]
Sent: 01 August 2002 00:21
To: Dowle, Matthew [EQRE]
Cc: 'r-help at lists.R-project.org'
Subject: Re: [R] exportData(foo,"foo.xls","EXCEL") for R ?


On Wed, 31 Jul 2002, Dowle, Matthew [EQRE] wrote:

>
> r-help,
>
> Is there a package available for R which allows you to export data
directly
> to .xls, much like exportData(foo,"foo.xls","EXCEL") in S-PLUS ?  If not,
is
> anyone working on this, or thinking about working on this?

The simplest solution is to use write.table() to produce a comma-separated
text file, which Excel will read.

The help page for write.table gives an example

	-thomas
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._