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

[Andrew C. Ward]

Drs Lumley and Dalgaard have already outlined R ways of interchanging data 
with Excel. Other alternatives are to
see if the other program can accept a text or CSV file instead
write an R routine for exporting XLS files. Perhaps the format is 
documented by Microsoft?

If S-PLUS has the required features it makes sense to continue using it. 
It's not really possible for open-source software and developers to match 
the resources of commercial companies. There are often license fees 
associated with reading and writing proprietary data formats, and the 
source code for doing so is generally not available. In my experience, R is 
very flexible in enabling data to be shared between a wide variety of 
programs on a number of platforms.


Regards,

Andrew C. Ward

CAPE Centre
Department of Chemical Engineering
The University of Queensland
Brisbane Qld 4072 Australia
andreww at cheque.uq.edu.au



On Thursday, August 01, 2002 9:40 AM, Dowle, Matthew [EQRE] 
[SMTP:matthew.dowle at citigroup.com] wrote:
>
> 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
> 
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.  
_._._._
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._