B4J Question [XLUtils] - Set row height

udg

Expert
Licensed User
Longtime User
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:
B4X:
'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
 

udg

Expert
Licensed User
Longtime User
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
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…