[R] Excel file

TEMPL Matthias Matthias.Templ at statistik.gv.at
Mon Jul 12 17:29:48 CEST 2004


 -----Ursprüngliche Nachricht-----
 Von: TEMPL Matthias 
 Gesendet: Montag, 12. Juli 2004 17:29
 An: 'Pernilla Karlsson'
 Betreff: Re: [R] Excel file
 
 
 It is possible to open the file in R.
 
 ?read.table
 
 excelfile <- read.table("../file.txt", sep=",", header=T)
 
 when you have a komma as seperator and a header in your .txt file.
 
 The seperator and the header should be set correctly.
 
 
 Or save your excel file in the .csv format and do
 
 read.csv(...)
 
 Best,
 Matthias
 
> > -----Ursprüngliche Nachricht-----
> > Von: Pernilla Karlsson [mailto:pernilla.karlsson at mednut.ki.se]
> > Gesendet: Montag, 12. Juli 2004 17:17
> > An: R-help at stat.math.ethz.ch
> > Betreff: [R] Excel file
> > 
> > 
> > Hi,
> > 
> > How do I open an excel file in R? I have save the excel file
> > in unicode text format, but it is not possible to open the 
> file in R.
> > 
> > /Pernilla
> > 
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://www.stat.math.ethz.ch/mailman/listinfo> /r-help
> > PLEASE 
> > do read the posting guide! 
> > http://www.R-project.org/posting-guide.html
> > 
>




More information about the R-help mailing list