CellBlock function is giving an error related to class after minimal specification

[GreyMerchant]

Hi there,

I posted this problem on stackoverflow too but got no help there. I hope you can assist?

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.

[shruti-par]

Hi, I am facing a similar error, although I don't think Cellblock is causing it. @GreyMerchant could you please tell me if and how you were able to resolve this issue?