[R] spreadsheet data import

[Marta Rufino]

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
Marta  




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.

Thanks,

	Tomás Revilla

    

><((((º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><((((º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><((((º>
`·.¸¸.·´¯`·.¸.·´¯`·...¸><((((º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><((((º>`·.¸¸.·´

Marta Rufino

Centre Mediterrani d'Investigacions Marines i Ambientals
(CMIMA). CSIC
Passeig Maritim 37-49
08003  BARCELONA

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