Error loading xlsx package

Yesterday we moved to Windows 7 in our company, and also updated the java packages, as well as R (up to 2.14).

Then I tried to download the xlsx package because I rely heavily on it, but I get the following error:

Error : .onAttach in attachNamespace()
Error: .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook")

I tried the following, but this did not work:

Sys.setenv(PATH=paste(Sys.getenv("PATH"),"C:\\Program Files (x86)\\Java\\jre6\\bin\\client",collapse=';')) 
options(java.parameters = "-Xmx1000m")

Since I never work with java, I have no idea what I can do. Could you help me?

Thank!

sessionInfo () R version 2.14.1 (2011-12-22) Platform: i386-pc-mingw32 / i386 (32-bit version)

locale: [1] LC_COLLATE = German_Austria.1252 LC_CTYPE = German_Austria.1252
[3] LC_MONETARY = German_Austria.1252 LC_NUMERIC = C
[5] LC_TIME = German_Austria.1252

included base packages: [1] stats graphics grDevices utils datasets base methods

: [1] xlsxjars_0.4.0 rJava_0.9-3

( ): [1] tools_2.14.1 xlsx_0.4.2


, XLConnect .EDIT: , , :

Error: NoSuchMethodError (Java): org.apache.xmlbeans.XmlOptions.setSaveAggressiveNamespaces()Lorg/apache/xmlbeans/XmlOptions;

, , Java. XLConnect!

, ?

+3
1

. , .

## Example where error occurs: 
install.packages('xlsx', lib='\\network\R\library')
library('xlsx', lib='\\network\R\library'))

, R, . , install.packages( "xlsx" ) , .

+4

All Articles