[R] can't read excel file with read.xls()

[array chip]

Thanks for the link, very useful. A simple fix to the code using normalizePath(), or full path name.

read.xls(normalizePath("ttt.xls"))



--- On Fri, 4/2/10, Gabor Grothendieck <ggrothendieck at gmail.com> wrote:

> From: Gabor Grothendieck <ggrothendieck at gmail.com>
> Subject: Re: [R] can't read excel file with read.xls()
> To: "array chip" <arrayprofile at yahoo.com>
> Cc: r-help at stat.math.ethz.ch
> Date: Friday, April 2, 2010, 7:05 PM
> Read about the bugs and workarounds
> on this page:
> http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel
> 
> On Fri, Apr 2, 2010 at 6:56 PM, array chip <arrayprofile at yahoo.com>
> wrote:
> > Hi, I encountered a problem of not being able to read
> in an excel spreadsheet using read.xls() in the xlsReadWrite
> package. can anyone help? Here is an example code
> >
> >
> > write.xls(matrix(1:9,nrow=3),"ttt.xls")
> > read.xls("ttt.xls")
> > Error in read.xls("ttt.xls") :
> >  Unexpected error. Message: Can't find the file
> "ttt.xls"
> >
> > The "ttt.xls" file was created in the current working
> folder successfully.
> >
> > Thanks
> >
> > John
> >
> > ______________________________________________
> > 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.
> >
>