B4J Question APOI formula

[DAKTECXXL]

Hello, it does not work evaluate, when the table is in another sheet

Formula = + Table24 [[# This row], [ASSEMBLY H.]] + Table24 [[# This row], [DIRECT H.]] + Table24 [[# This row], [TRAVEL H.]] + Table24 [ [#This row], [H.NAVE]] + Table24 [[# This row], [H. DRIVING]]


org.apache.poi.ss.formula.FormulaParseException: The specified named range 'Table24' does not exist in the current workbook.

Excuse my English.

 Dim jo como JavaObject = xls
        Dim evaluator As JavaObject = jo.RunMethodJO ("getCreationHelper", Null) .RunMethodJO ("createFormulaEvaluator", Null)   
        Log ("EVALUATOR =" & evaluator.RunMethodJO ("evaluar", Array (row.getCell (12))). RunMethod ("formatAsString", Null))
 [/ CODE]

I also try with ...

[CODE=b4x]        Dim chlp As XSSFCreationHelper = xls.CreationHelper
        Dim eval As XSSFFormulaEvaluator = chlp.createFormulaEvaluator
        Dim evaluatedcell As XSSFCell = eval.evaluate(row.getCell(12))

does not work, result ...

 

[Erel]

You should use XLUtils with B4J.

 

[DAKTECXXL]

Sorry I got confused, it is a B4A question, in B4J it works perfectly

 

[behnam_tr]

Sorry I got confused, it is a B4A question, in B4J it works perfectly

check this :

[XLUtils] Writing Excel Workbooks

Main concepts and reading MS Excel workbooks with XLUtils: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/#content Writing workbooks is also simple but does require a bit more code. There are several types that we will use, in addition to...

www.b4x.com

 

[DAKTECXXL]

Thanks for your prompt reply but ...
- XLUtils: a b4xlib (only B4J) that adds more functions and utilities.
and I need it for B4A

 

[Erel]

Start a new thread in the correct forum.