search

colearendt / xlsx

An R package to interact with Excel files using the Apache POI java library
https://colearendt.github.io/xlsx/
85 stars 32 forks source link

Nasty-sounding warning at the first use of xlsx #94

Open EmmanuelCharpentier opened 6 years ago

EmmanuelCharpentier commented 6 years ago

I just saw this : 

> library(xlsx)
Le chargement a nécessité le package : rJava
Le chargement a nécessité le package : xlsxjars
> D1 <- read.xlsx(file="Données.xlsm", header=FALSE,
+                     sheetName="Info Générale",
+                     rowIndex=3:32, colIndex=1:12,
+                     colClasses=c("numeric", rep("character",2), "character",
+                                  "numeric", rep("logical",6),"character"))
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.poi.util.SAXHelper (file:/usr/local/lib/R/site-library/xlsxjars/java/poi-ooxml-3.10.1-20140818.jar) to method com.sun.org.apache.xerces.internal.util.SecurityManager.setEntityExpansionLimit(int)
WARNING: Please consider reporting this to the maintainers of org.apache.poi.util.SAXHelper
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
>

I haven't the foggiest idea of the meaning of this warning. It seems, though, that the culprit may exist in some XML library you happen to use, not in xlsx itself.

HTH...

colearendt commented 6 years ago

Thanks for the report... that's a menacing one! Very curious

IrelCM commented 3 days ago

Hello, I'm having the same problem trying to compile my RMD. The compilation stops when I use this function write.xlsx()

WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.apache.poi.util.SAXHelper (file:/home/ibpc/R/x86_64-pc-linux-gnu-library/4.4/xlsxjars/java/poi-ooxml-3.10.1-20140818.jar) to method com.sun.org.apache.xerces.internal.util.SecurityManager.setEntityExpansionLimit(int) WARNING: Please consider reporting this to the maintainers of org.apache.poi.util.SAXHelper WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release

Thanks. Irelka