Reply to topic  [ 2 posts ] 
Formulas using custom functions 
Author Message

Joined: Wed May 09, 2007 8:36 am
Posts: 14
Location: Israel
Reply with quote
Post 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
Profile

Joined: Sat Apr 22, 2006 10:20 am
Posts: 5
Reply with quote
Post 
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
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.