exportData(foo,"foo.xls","EXCEL") for R ? - R-help

Wed, Jul 31, 2002 6:54 PM #

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._