[R] spreadsheet data import

Marta Rufino mrufino at cmima.csic.es
Mon Apr 29 10:25:37 CEST 2002

Helo Tomas,

I just saw the R list email, sory for the lkat reply, but I think nobody
focused on this point, which might be important for "latin" users:

I think your problem as to do with the configuration of your computer. The
decimal separator "oficially" changes from contry to contry, so for example
in Spain it is a comma, although in UK it is a dot, as in R. So, you will
have this problem with most statistical packages,... In windows it is very
simple to solve it permenently:
you go to start> Control pannel> "configuracion regional" and either change
the country to UK, or manually change the character for decimal etc... 
This (as long as I know) does not affect your computer in nothing else,
except for the decimal separator!
BEst regards

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.


	Tomás Revilla



Marta Rufino

Centre Mediterrani d'Investigacions Marines i Ambientals
Passeig Maritim 37-49

Tfno:34 93 230 95 40
Tfax:34 93 230 95 55


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