Re: [R] Importing an Excel spreadsheet

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

andy <geek_show <at>> 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 mailing list PLEASE do read the posting guide 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 Please read the posting guide before posting to the list.

list of date sections of archive