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

[Warnes, Gregory R]

The Perl Archive CPAN has a module called 'Spreadsheet::WriteExcel' that
claims to "write formatted text and numbers to a cross-platform Excel binary
file".

It should be a simple matter to write a perl script that reads csv and
writes XLS using this.

-Greg

> -----Original Message-----
> From: rossini at blindglobe.net [mailto:rossini at blindglobe.net]
> Sent: Wednesday, July 31, 2002 8:08 PM
> To: Dowle, Matthew [EQRE]
> Cc: 'r-help at lists.R-project.org'
> Subject: Re: [R] exportData(foo,"foo.xls","EXCEL") for R ?
> 
> 
> >>>>> "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 at u.washington.edu	
> FHCRC/SCHARP/HIV Vaccine Trials Net	rossini at 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 at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
> _._._._._._._._._
> 


LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._