Re: [R] Importing an Excel spreadsheet

From: ken knoblauch <knoblauch_at_lyon.inserm.fr>
Date: Thu, 20 Mar 2008 22:33:13 +0000 (UTC)

andy <geek_show <at> dsl.pipex.com> writes:
> I am trying to import an *.xls spreadsheet into R. I am doing this as
> follows:
> > read.table(file("A5_DL.xls"))
> 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).
> Thanks
>
> Andy
read.table deduces that your data set has 34 elements, not 26, according to the error message. Could there be spaces in the column names?

ken



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. Received on Thu 20 Mar 2008 - 22:35:37 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 20 Mar 2008 - 23:30:23 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive