R-snippet XLConnect error

[chefor99]

Hi all
I’m facing the following problem with the R-snippet in KNIME. I’ve installed XLConnect severally using the R.exe console in the KNIME repository, but it still keeps showing up. My KNIME and R versions are up to date. I have installed Rserve as well
Thanks in advance

[mlauber71]

I would recommend using a standalone R version and RStudio to manage it. And you should check your versions of RServe and Cairo package:

KNIME R Snippet node is not working fine in the latest version of macOS (Big Sur 11.2.3)

@mariaangelesjs welcome to the KNIME forum. If you encounter problems with R and KNIME and MacOSX there are more articles and hints to explore: The error sounds like some paths might be missing. Did you follow all the hints from the official KNIME and R guide and can you check which versions of the named packages you have. You can check your installation here. If the code does not work in KNIME/R maybe you try to check the versions in RStudio.

[dpowyslybbe]

I believe this is a XLConnect issue as opposed to a KNIME issue.

On one laptop Version 1.0.1 works for me using R 4.0.0 and KNIME. I’ve another laptop running R 3.6.3 that I tried to install XLConnect (v 1.0.3) on and it fails with the same error as you.

I briefly saw that there’s some threads elsewhere on the web talking about the same issue so I’m happy to wait for the next XLConnect version to rectify it. Since what I was trying to do could be done by the openXLSX package I used that instead.

[chefor99]

@mlauber71 this did not work