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

About this list Date view Thread view Subject view Author view Attachment view

From: A.J. Rossini (rossini@blindglobe.net)
Date: Thu 01 Aug 2002 - 10:08:24 EST 

Message-id: <87lm7r4f0n.fsf@jeeves.blindglobe.net>

>>>>> "matthew" == Matthew Dowle <Dowle> writes:

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

Past discussions pointed to PERL libraries for doing this. If I'm not
mistaken, they are probably in the archive somewhere, from about 1-2
years ago. I don't think there currently is a native R solution,
unless you are working with the R plug-in for Gnumeric (but even that
isn't quite "right").

It's a simple programming problem. The tricky part is finding someone
who has time (which can substitute for skill in this case, if enough
time can be found).

best,
-tony 

-- 
A.J. Rossini				Rsrch. Asst. Prof. of Biostatistics
U. of Washington Biostatistics		rossini@u.washington.edu	
FHCRC/SCHARP/HIV Vaccine Trials Net	rossini@scharp.org
-------------- http://software.biostat.washington.edu/ ----------------
FHCRC: M: 206-667-7025 (fax=4812)|Voicemail is pretty sketchy/use Email
UW:   Th: 206-543-1044 (fax=3286)|Change last 4 digits of phone to FAX
(my tuesday/wednesday/friday locations are completely unpredictable.)

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Tue 01 Jun 2004 - 09:31:04 EST