Android Question jXL row height

[Mostez]

Is it possible to set row height with respect to cell content, just like auto set col width in this example

TIA

 

[Erel]

Better to use XLSheetWriter.AutoSizeColumn.

About the row height:

Dim sheet As XLSheetWriter = DocWriter.CreateSheetWriterByIndex(0)
sheet.PutString(XL.AddressName("C3"), $"sld;kfjlksdjf
sdfkljskljdf
sdf
sdf ksldjf lksdfj "$)
sheet.SetStyle(XL.AddressName("C3"), DocWriter.CreateStyle.WrapText(True))
sheet.GetRow(XL.AddressName("C3")).Height = -1

I'm not sure what you mean with jXL, but you should use jPOI + XLUtils.

 

[Mostez]

I'm not sure what you mean with jXL

I mean jexcel library

 

[Erel]

XLUtils + POI are 1,000 times more powerful and simpler to use.

 

[Mostez]

how to use it with B4A, I've got an error message says 'Library XLUtils is not compatible with B4A'

 

[DonManfred]

You started this thread about jexcel which, from the name, must be an B4J Library.
But in fact you are talking about excel-Library. without J in the name.
XLUtils + POI are B4J Libraries.

 

[Erel]

Actually I missed that it is a B4A question. Sorry.
You should use jExcel (which is indeed a B4A + B4J library).

jPOI + XLUtils are B4J only libraries.

 

[Mostez]

jPOI + XLUtils are B4J only libraries.

I wish for sooner B4A version.
Thanks