B4J Question EXCEL FUNCTIONS

[h.drose]

Hi,

How can I get the first empty cell on a sheet of excel?
Im new on this compilator, Im currently migtrate from MS Visual Basic,
So this what Ineed, on Visual Basic must be like:
( last_line = Range("A" & Rows.Count).End(xlUp).Row + 1 )

 

[DonManfred]

XLUtils / jPOI 5 - Read and write MS Excel workbooks

As written here, I plan to make it easier to read and write Excel workbooks. The solution is based on three components: - Apache POI - https://poi.apache.org/ Large open source project that provides APIs for Microsoft documents. Note that the files are accessed directly, it doesn't depend on the...

www.b4x.com

 

[Erel]

result.BottomRight points to the last non-empty row.

 

[h.drose]

Thanks Erel it work