[R] Reading Excel files from within R.

About this list Date view Thread view Subject view Author view Other groups

Subject: [R] Reading Excel files from within R.
From: Alistair Merrifield (Alistair.Merrifield@med.govt.nz)
Date: Thu 11 Jan 2001 - 13:12:18 EST 

Message-ID: <EDFD920FC713D31186FF0008C7731C0E02977B35@wnant21.moc.govt.nz>

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@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@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

About this list Date view Thread view Subject view Author view Other groups

This archive was generated by hypermail 2b25 : Thu 01 Feb 2001 - 16:14:40 EST