0

I am having some specific problems with xlsx package after having moved to a newer version of R (4.0.5).

You will see that we have an error here for CellBlock function and the only object of note is the sheet itself as the rest are very stock standard things.

Browse[4]> xlsx::CellBlock(sheet, 1, 1, 100, 100, create = TRUE)
Error in .jcall("java/lang/Class", "Ljava/lang/Class;", "forName", cl,  : 
  RcallMethod: cannot determine object class
Error in (function (cond)  : 
  error in evaluating the argument 'Class' in selecting a method for function 'new': java.lang.StackOverflowError
Browse[4]> sheet
[1] "Java-Object{Name: /xl/worksheets/sheet1.xml - Content Type: application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml}"

For full background you will see sheet above but I will include the lines that produced sheet as well:

wb <- createWorkbook(type = "xlsx")

sheet <- createSheet(wb, sheetName = "New loadings")

Some of the packages relevant to the problem above:

rJava_1.0-6  
xlsxjars_0.6.1 
xlsx_0.6.5 

Let me know if you require more info.

0 Answers0