[R] Absolute path in gdata library

[David Winsemius]

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 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.

David Winsemius, MD
Alameda, CA, USA