B4J Question [XLUtils] - Set row height

[udg]

Hi all,
using jPOI5+XLUtils to create an Excel workbook. How do I set the height of a row to an absolute value or to something taller than what I obtain simply setting its style?
Should I revert to POI functions (e.g. sheet0.PoiSheet.GetRow(0).Height=xxx) or is there something ready available in XLUtils?

Example code:

'Title Font
    Dim tfont As PoiFont
    tfont.Initialize(Workbook.PoiWorkbook)
    tfont.Name = "Arial"
    tfont.Bold = True
    tfont.Size = 18
    tfont.SetColor(xui.Color_Black)

Dim TitleStyles As List = Array(Workbook.CreateStyle.FontOther(tfont),Workbook.CreateStyle.HorizontalAlignment("CENTER").ForegroundColor(xl.COLOR_YELLOW))

The resulting row height looks one exactly adjusted on the content height; I'd like a bit of margin both top and bottom.

Thank you

 

[Erel]

sheet.GetRow(xl.AddressName("A1")).Height = 100

 

[udg]

Thank you, Erel.
Is it the height value in 1/72" ? So setting it at 72 gives a row of about 2.54cm?
BTW, this seems what we get with sheet.PoiSheet.GetRow(0).Height=xxx

 

[Erel]

Yes.