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

[David Brahm]

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