EasyXLS - View topic - Formulas using custom functions

View unanswered posts | View active topics It is currently Wed Nov 27, 2024 5:29 pm

Formulas using custom functions

Moderators: daniela, claudiu, oana

Page 1 of 1

[ 2 posts ]

Print view

Previous topic | Next topic

Formulas using custom functions

Author

Message

teniel

Joined: Wed May 09, 2007 8:36 am
Posts: 14
Location: Israel

Formulas using custom functions

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

Wed May 09, 2007 8:44 am

exari

Joined: Sat Apr 22, 2006 10:20 am
Posts: 5

EasyXLS doesn't support custom functions.
A list of all supported functions is available in the User Guide:
http://www.easyxls.com/manual/html/pr ... mulas.html
and inside this PDF:
http://www.easyxls.com/docs/EasyXLS ... sSheet.pdf

Thu May 10, 2007 6:33 am

Page 1 of 1

[ 2 posts ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum