Skip to content
Prev 22281 / 398502 Next

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

Matthew Dowle <matthew.dowle at citigroup.com> wrote:
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 ---)