Android Question jxl setAutoSize is not working

[Mostez]

Based on this example,

I applied the example as it is, but the code editor marked this line in red and reported this message:
clsSysTools - 286: Unknown member: runmethod

Dim jcell As JavaObject = sheet1.RunMethod("getColumnView", Array(ColumnIndex))

I modified the code to this, but at run time I get this error:
java.lang.RuntimeException: Method: setAutoSize not found in: jxl.CellView

For i = 0 To Table.Columns.Size - 1
            Dim c As B4XTableColumn = Table.Columns.Get(i)
            Dim Cn As String = c.Title
            Dim cell As WritableCell
            cell.InitializeText(i, 0, Cn)
            cell.SetCellFormat(cellFormat)
            sheet1.AddCell(cell)
            'sheet1.SetColumnWidth(i, 15)

            Dim jsheet As JavaObject = sheet1
            Dim jcell As JavaObject = jsheet.RunMethod("getColumnView", Array(i))'= sheet1.RunMethod("getColumnView", Array(i))
            jcell.RunMethod("setAutoSize", Array(True))
            jsheet.RunMethod("setColumnView", Array(i, jcell))
        Next

Any ideas hot to fix this?

 

[Erel]

It should be jsheet1 instead of sheet1. I've updated the code.

 

[Mostez]

Thanks Erel
EDIT: sorry, but I tried the code and I've got this error as in screenshot

 

[Mostez]

Finally I got it
it should be 'setAutosize' not 'setAutoSize' as found in CellView.java source file, here is the final code
Thanks so much Erel, your jxl example saved me a lot of work

Dim jsheet As JavaObject = sheet1
Dim jcell As JavaObject
jcell = jsheet.RunMethod("getColumnView", Array(i))
jcell.RunMethod("setAutosize", Array(True))
jsheet.RunMethod("setColumnView", Array(i, jcell))

 

[Erel]

Fixed.