[R] Importing an Excel spreadsheet

[Petr PIKAL]

r-help-bounces at r-project.org napsal dne 20.03.2008 23:44:05:

> Bryan K Woods wrote:
> > If you open the spreadsheet in Excel you can then do "Save as..." and 
> > select type CSV (comma-delimited text). Once you have the data in CSV 
> > format, you can use the R function read.csv to import the data.
> >
> > Cheers,
> > Bryan
> >
> > andy wrote:
> >> Hello
> >>
> >> I am trying to import an *.xls spreadsheet into R. I am doing this as 

> >> follows:
> >>
> >>  > read.table(file("A5_DL.xls"))
> >>
> >> But obtain the error:
> >>
> >> Error in type.convert(data[[i]], as.is = as.is[i], dec = dec, 
> >> na.strings = character(0)) :
> >> invalid multibyte string at '?????'
> >>
> >> So I copied it all over to a text document and tried to import that, 
> >> thus:
> >>  > read.table("A5.txt")
> >>
> >> The error I got then was:
> >>
> >> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, 
> >> na.strings, :
> >> line 26 did not have 34 elements
> >>
> >> Having gone over the line in question, it all seems to be the same as 

> >> any other row. I really don't want to have to manually re-enter the 
> >> data (some 98 rows x 26 columns).
> >>
> >> Can someone advise me on what I am overlooking here please.
> >>
> >> Thanks
> >>
> >> Andy
> >>
> >> 
> >
> That did it - thanks!!

Or you can in Excel select the part in question, press Ctrl-C and in R 
write

mydata <- read.delim("clipboard")

Regards

Petr

> 
> Very steep learning curve ... so appreciate your help.
> 
> Cheers
> 
> Andy
> 
> -- 
> 
> "If they can get you asking the wrong questions, they don't have to 
worry 
> about the answers." - Thomas Pynchon, "Gravity's Rainbow"
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.