Aborted R Session- Fatal Error with library(xlsx) about xlsx HOT 8 OPEN

Interesting! And apologies for the trouble! Does library('rJava'); .jinit() work for you? Crashes at startup are always important to check whether it is xlsx or the Java runtime itself that is causing the problem. I haven't added R 4.2 to CI yet (it is still quite new), but plan to do that!

from xlsx.

For me installing rJava from source removed this issue on 4.2.0 (.jinit() started working and xlsx loading without crash):
install.packages("rJava", repos="https://rforge.net", type='source')

from xlsx.

Hi, having the same issue and it looks like the package is not compatible with R 4.2. When I run the same script on R version 4.1.3, everything works as expected.

from xlsx.

Hi, in my case fails only using RStudio.

from xlsx.

No worries:)
After running library(rJava) and then .jinit(), R Session is aborted and terminated.

from xlsx.

Hello, library('rJava'); .jinit() does not work for me

from xlsx.

Yes, if .jinit() fails, that suggests that the problem is with rJava or your java installation, not necessarily with xlsx. It's also possible that your Java installation conflicts somehow with RStudio running / environment variables that RStudio sets. (I would check the differences in the output of Sys.getenv() between a working / not working environment in the latter case)

Anyhow, xlsx unfortunately requires a functional rJava installation to work. If .jinit() is not working, you are better off asking for help in the rJava community and debugging your Java installation (there are several good debugging steps here). If you want to dispense with the Java dependency, then there are packages like openxlsx that do not have the Java dependency

from xlsx.