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