Android Question jXL row height

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 9, 2021

• #2

Better to use XLSheetWriter.AutoSizeColumn.

About the row height:

B4X:

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.

 

Upvote 0

M

Mostez

Well-Known Member

Licensed User

Longtime User

• Sep 9, 2021

• #3

Erel said:

I'm not sure what you mean with jXL

Click to expand...

I mean jexcel library

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 9, 2021

• #4

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

 

Upvote 0

M

Mostez

Well-Known Member

Licensed User

Longtime User

• Sep 9, 2021

• #5

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

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Sep 9, 2021

• #6

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.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 9, 2021

• #7

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.

 

Upvote 0

M

Mostez

Well-Known Member

Licensed User

Longtime User

• Sep 9, 2021

• #8

Erel said:

jPOI + XLUtils are B4J only libraries.

Click to expand...

I wish for sooner B4A version.
Thanks

 

Upvote 0