[R] spreadsheet data import

ripley@stats.ox.ac.uk ripley at stats.ox.ac.uk
Fri Apr 26 13:57:18 CEST 2002

On Fri, 26 Apr 2002, [windows-1252] Tomás Revilla wrote:

> Hi colleages!
> I want to import data from ms-excel and other spreadsheet formats
(lotus, etc). Does exist any way to do it within
> R?

There exist several ways, and R has a manual `R Data Import/Export' to
explain them to you.  Since you haven't even told us what OS you are
using, it is hard to be more specific.  On Windows (and you mailed in a
Windows character set), RODBC can read directly from the spreadsheet.

> The main problem is that many spreadsheet data use comma as decimal
separator and not the point as needed in R
> (and many software for Linux), so importing data first as a tab separated
values does not solve this problem.

That's not correct.  Look at the manual, and functions read.delim2 and

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

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