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

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Thu Aug 1 02:09:50 CEST 2002

"Dowle, Matthew [EQRE]" <matthew.dowle at citigroup.com> writes:

> Thanks for the reply. 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. I already have this working in S-PLUS and I was thinking of
> porting to R. I saw the Excel-R-Interface mentioned in the archives so maybe
> I could call Excel to load up the .csv and save as an .xls, but I'd prefer
> to keep things simple if possible and write the .xls format directly from R.
> Its got to be possible since Insightful managed to do it, now whether its
> difficult??

Insightful can licence and incorporate closed-source libraries and
obtain information under nondisclosure agreements... (not that I know
how Insightful operates, but the publicly available information is
certainly scarce).

R can speak ODBC via the RODBC package. An .xls file can be used as an
ODBC source. This can be used to read spreadsheets (after some
headbanging in setting up the DSN, I recall), so you might also write
into them with sqlSave()? Read Ch4 in the R Data Import/Export  manual
and you'll know roughly what I know.

   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
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

More information about the R-help mailing list