CODEWITHSUNDEEP
javar
bswan23
bswan23

Reputation: 41

Error using XLConnect in R: NoSuchMethodError (Java): org.apache.xmlbeans.XmlCursor.close()V

I have been using the XLConnect package to read in password protected worksheets in R. Recently, the following error appeared when attempting to read in the file. Is anyone familiar with this error?

Error: NoSuchMethodError (Java): org.apache.xmlbeans.XmlCursor.close()V

Session Information:

R version 4.2.2 (2022-10-31 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19044)

Matrix products: default

locale:
[1] LC_COLLATE=English_United States.utf8  LC_CTYPE=English_United States.utf8    LC_MONETARY=English_United States.utf8
[4] LC_NUMERIC=C                           LC_TIME=English_United States.utf8    

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

other attached packages:
[1] XLConnect_1.0.6

loaded via a namespace (and not attached):
 [1] compiler_4.2.2  fastmap_1.1.0   cli_3.4.1       htmltools_0.5.3 tools_4.2.2     rstudioapi_0.14 yaml_2.3.6      rmarkdown_2.17 
 [9] knitr_1.40      xfun_0.34       digest_0.6.30   rJava_1.0-6     rlang_1.0.6     evaluate_0.17   fortunes_1.5-4

I have updated XLConnect.

Upvotes: 2

Views: 1462

Answers (2)

bswan23
bswan23

Reputation: 41

Looks like the issue was resolved by the package developers. I tried out the solutions below, and it worked for me.

Full thread: https://github.com/miraisolutions/xlconnect/issues/181

Specific fix: https://github.com/miraisolutions/xlconnect/issues/181#issuecomment-1299911543

Upvotes: 2

ecco
ecco

Reputation: 51

I have exactly the same problem with the same R & XLConnect versions, and didn't find any workout yet. Most probably have to switch to openxlsx since I need to get things done.

Upvotes: 0

Related Questions