[R] spreadsheet data import

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Fri Apr 26 13:54:54 CEST 2002

Tomás Revilla <trevilla at strix.ciens.ucv.ve> writes:

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

Oh yes it does. Notice the "dec" argument and read.delim2().

   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
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