EasyXLS
http://forum.easyxls.com/

Formulas using custom functions
http://forum.easyxls.com/viewtopic.php?f=5&t=48
Page 1 of 1

Author:  teniel [ Wed May 09, 2007 8:44 am ]
Post subject:  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

Author:  exari [ Thu May 10, 2007 6:33 am ]
Post subject: 

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

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/