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, 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