Re: [R] Read shortcuts of MS Excel files through R

2013-09-26 Thread Mark Lamias
sh To: r-help Sent: Thursday, September 26, 2013 4:54 PM Subject: [R] Read shortcuts of MS Excel files through R Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts

Re: [R] Read shortcuts of MS Excel files through R

2013-09-26 Thread Marc Schwartz
Hi, I am not on Windows so cannot test this, but a search reveals that in the R.utils CRAN package by Henrik Bengtsson, there is the readWindowsShortcut() function which may provide some assistance in getting the path to the actual file. Thus: install.package("R.utils", dependencies = TR

Re: [R] Read shortcuts of MS Excel files through R

2013-09-26 Thread Sarah Goslee
Hi, On Thu, Sep 26, 2013 at 4:54 PM, Santosh wrote: > Dear Rxperts, > > Through Windows OS, I created shortcuts (paste as shortcut) to excel > spreadsheets ( with "xlsx" as the file extension). I wasn't able to read > the shortcuts through R and using "read" functions of "xlsx" package. A shortc

[R] Read shortcuts of MS Excel files through R

2013-09-26 Thread Santosh
Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools",