Hi Dan,
You can save your .xls as .csv, set up your directory under the file where you
saved it, then
widge= read.csv("WidgeOne.csv", header=T)
It should work.
Kathleen.
> From: [email protected]
> Date: Wed, 24 Aug 2011 18:31:21 -0400
> To: [email protected]
> CC: [email protected]
> Subject: Re: [R] Importing data from MS EXCEL (.xls) to R XXXX
>
> Hi Dan,
>
> You might try
>
> require(gdata)
> ?read.xls
>
> HTH,
> Jorge
>
>
> On Wed, Aug 24, 2011 at 6:20 PM, Dan Abner <> wrote:
>
> > Hello everyone,
> >
> > What is the simplest, most RELIABLE way to import data from MS EXCEL (.xls)
> > format to R? In the past I have used the read.xls() function from the
> > xlsReadWrite package, however, I have been wrestling with it all afternoon
> > long with no success. I continue to receive the following error message:
> >
> >
> > > {widge<-read.xls("F:\\Classes\\Z1.Data\\stat.3010\\WidgeOne.xls",
> > + colNames=TRUE,sheet=1)}
> > Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
> > Incorrect number of arguments (11), expecting 10 for 'ReadXls'
> >
> > Any insight/suggestions/assistance is appreciated.
> >
> > Thank you,
> >
> > Dan
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > [email protected] 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.
> >
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [email protected] 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.
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
