Post package installation (xlsx)
i Installed Java, then installed package ( Gdata) , then Active Perl.
But still not able to read xlsx file.
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.NullPointerException
I recommend trying the {readxl} package and the read_xlsx() function, or alternatively use the {openxlsx} package and read.xlsx() which does not have the Java dependency.
If you want to read excel file that is encrypted/ password protected you need the library(xlsx) to read the file.
library(openxlsx) or library(readxl) not useful in that case.
library(excel.link) could be used but it gives error if you windows 10.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.