Skip to content

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

1 message · A.J. Rossini

#
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