[R] EXCEL FILE

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Thu May 8 21:10:13 CEST 2003


Joel Kincaid <jfkincaidsu at netscape.net> writes:

> Use 'save as' in excel to create 'foo.csv' and then
> 
> read.csv(file='foo.csv',sep',',header=T)

Those are the defaults... read.csv(file='foo.csv') should do. Use
header=FALSE if the header is absent. Notice also that in some
locales, CSV files have "," for decimal separator and ";" for the
value. That's where read.csv2 is relevant.

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




More information about the R-help mailing list