Message-ID: <15689.19420.403417.208740@gargle.gargle.HOWL>
Date: 2002-08-01T14:55:24Z
From: David Brahm
Subject: exportData(foo,"foo.xls","EXCEL") for R ?
In-Reply-To: <104952988@toto.iv>
Matthew Dowle <matthew.dowle at citigroup.com> wrote:
> 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.
Another possibility may be to create an ascii file in the SYLK format, see:
<http://www.jkrieger.de/programming/delphi/sylk.txt>
<http://www.worldgate.ca/~rschulz/misc/sylksum.doc>
If your SYLK file has extension ".xls", it is automatically read by Excel
without any manual interaction, and acts a lot like a true .xls binary. Try it
with the following very simple example:
(--- snip here and save as "db.xls" ---)
ID;PBrahm's SYLK example
F;K;G
F;W1 1 8
F;W2 2 8
P;FArial;M200;L9
P;FArial;M200;SB;L9
P;FArial;M200;SI;L9
P;FArial;M200;SBI;L9
P;FArial;M200;SB;L13
F;X1;Y1;FF0C;SM5TBL
C;K"a"
F;X2;Y1;FF0C;SM5TBR
C;K"b"
F;X1;Y2;FF3G;SBL
C;K1.000
F;X2;Y2;FF3G;SBR
C;K2.000
E
(--- end snip ---)
--
-- David Brahm (brahm at alum.mit.edu)
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._