Skip to content
Prev 8890 / 398502 Next
Original Raw

Reading Excel files from within R.

Yves Gauvreau 
You already use the simplest method I can think of that is comma delimited
files.

I think we'll probably never see this as part of R for obvious reasons but
what would be very nice is to have an ActiveX interface. That is the
possibility of creating an Ole object and using it's properties and methods.

The next best thing I can think of would be to use an intermediary DLL that
would create and use Ole objects (such as Excel) and transfer the data you
need and/or do whatever else you could think of. But it would be a lot of
work just to transfer data back and forth.

Maybe a much simpler approach would be to use a vbscript | jscript |
perl-script. Any of these is Ole aware and you could write an R function to
run your script which would extract the data you want, put it in a file that
R can read back. That is the quickest and easiest expedient you could use to
control everything from R.

Regards.

Yves Gauvreau
B.E.F.P. Universit? du Qu?bec ? Montr?al
cyg at sympatico.ca
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

Thread (7 messages)

Alistair Merrifield Reading Excel files from within R. Jan 10 Yves Gauvreau Reading Excel files from within R. Jan 10 Dirk Eddelbuettel Reading Excel files from within R. Jan 10 M. Edward (Ed) Borasky Reading Excel files from within R. Jan 10 Brian Ripley Reading Excel files from within R. Jan 11 Alexandre Fayolle Reading Excel files from within R. Jan 11 Yves Gauvreau Reading Excel files from within R. Jan 11