[R] Reading Excel files from within R.

Alistair Merrifield Alistair.Merrifield at med.govt.nz
Thu Jan 11 04:12:18 CET 2001


Dear all,

I am interested in reading Excel spreadsheets (*.xls) directly into R (I am
using version 1.1.1 at the moment). I have not had much luck so far. 

For the time being, I have been converting Excel files to comma delimited
files (*.csv) and reading these into R (using commands such as "read.csv").
This works well, but it would be more efficient if I could read the Excel
files directly.

I have noticed that there is an Excel interface for R. However, this seems
to be a backwards approach to my problem . I would prefer to read Excel into
R, not use R in Excel!

I am sure this cannot be an uncommon thing to want to do (given that Excel
is a popular programme), although I have not had much success searching in
the CRAN archives for information. Any comments would be appreciated.

Cheers, Al.


Al Merrifield

Energy Analyst
Energy Modelling & Statistics
Ministry of Economic Development
PO Box 1473
Wellington
NEW ZEALAND

Phone: (04) 470 2338
Fax:     (04) 473 9930
E-mail: Alistair.Merrifield at med.govt.nz



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