Android Question Excel library - Auto column size.

[NJDude]

I was checking the Excel library and I would like to know how to set the auto column sizing, I haven't seen anything about that.

Thanks

 

[Erel]

Based on this answer: https://stackoverflow.com/a/2128445/971547

Sub SetAutoSize(ColumnIndex As Int)
Dim jsheet as JavaObject = sheet1
Dim jcell As JavaObject = jsheet1.RunMethod("getColumnView", Array(ColumnIndex))
jcell.RunMethod("setAutosize", Array(True))
jsheet.RunMethod("setColumnView", Array(ColumnIndex, jcell))
End Sub

 

[Erel]

Another option is to create a worksheet with Excel, load it, modify it as needed and save it as a new worksheet.

 

[NJDude]

Thanks