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", "Ljava/lang/Object;", "invokeMethod", cl,  :
  java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
stream, nor an OOXML stream
> read.xlsx2(exf,1)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  :
  java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
stream, nor an OOXML stream


Would truly appreciate your suggestions.

Regards,
Santosh

	[[alternative HTML version deleted]]

