On Nov 7, 2012, at 2:58 PM, r wrote:
> Dear list,
> I have some .xls files that I need to read into R. I am able to do so
> using read.xls in the gdata package, however the helper functions
> sheetNames and sheetCount fail. This is the error:
>
> Unable to open file '~/SharedFolder/MyData/mydata.xls'.
> Warning: running command ''/usr/bin/perl'
> '/usr/local/lib/R/site-library/gdata/perl/sheetCount.pl'
> '~/SharedFolder/MyData/mydata.xls'' had status 2
>
> Googling I found that the problem is caused by the use of the absolute
> path ("~/SharedFolder/MyData/") instead of
> "/home/r/SharedFolder/MyData/". I use the absolute path because I work
> from different computer connected to a shared folder.
>
> This is the discussion I found:
> http://stackoverflow.com/questions/11737906/path-specification-when-using-the-r-package-gdata
>
> Is there a way to solve this problem??
> path.expand("~/")
[1] "/Users/davidwinsemius/"
>
> Best
> Riccardo
>
> ______________________________________________
> R-help@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.
David Winsemius, MD
Alameda, CA, USA
______________________________________________
R-help@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.
