[R] spreadsheet data import

Jonathan Baron baron at cattell.psych.upenn.edu
Fri Apr 26 14:14:00 CEST 2002

On 04/26/02 07:45, 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? 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.

See the help for read.table().  There are several different
versions of that for different kinds of delimiters and an option
"dec" to specify the kind of decimal point.

In general, the help files are very useful.

Jonathan Baron, Professor of Psychology, University of Pennsylvania
Home page: http://www.sas.upenn.edu/~baron
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