createFreezePane and setColumnWidth

8 views

Skip to first unread message

unread,

Nov 30, 2021, 6:30:34 AM11/30/21

to R-package-xlsx

I want to format the 2nd sheet of an Excel file I've created wih write.xlsx()

I get that:

V<- loadWorkbook("vectors VA’ and K. Year 2014.xlsx")

> sheets <- getSheets(V)

> createFreezePane (sheets[(2)], 1, 2, startRow=NULL, startColumn=NULL)

Error in .jcall(sheet, "V", "createFreezePane", as.integer(colSplit - :

RcallMethod: cannot determine object class

> setColumnWidth(sheets[(2)], 2,400)

Error in .jcall(sheet, "V", "createFreezePane", as.integer(ic), as.integer(colWidth * :

java.lang.ClassNotFoundException

What is wrong. Thank you to help me. I know nothing of jeva

Reply all

Reply to author

Forward

0 new messages