I am using EasyXLS Professional for Java V6.0
I have written VBA functions inExcel which I would like to access from my java workbook.
I can see that EasyXLS supports the built in Excel functions
e.g.
 | | |
| Code: String formula2 = "=SUM(A1:A2)+SUM(A3:A4)"; xlsMainTable.easy_getCell("A51").setValue(formula2); | |
| | |
However let us say that I have defined a VBA function called GetYea()
When I try the following code
| | |
| Code: String formula3 = "=GETYEA(2)"; xlsMainTable.easy_getCell("A52").setValue(formula3); | |
| | |
then EasyXLS just puts =GETYEA in the cell
Thank you very much