Is it possible to write a custom function such that when POI encounters a
reference it uses my function in Java instead of trying to use the Excel
function?
The actual case I have is that a spreadsheet I am working with has a VBA module
and a function from that module is referenced a lot(but POI can't seem to
evaluate cells that reference it). The function itself isn't very large and
could be recoded in Java somewhat easily.
So suppose that my function is something like MyFoo(B45, D34) - is there
someway for me to implement MyFoo as a Java class and then register it with
POI? I've been looking at the source for POI and it seems like this is
possible, but I can't figure out how. In particular the UDFFinder interface
defines functionality that allows looking up user defined functions, but it's
not clear if "user defined" means something defined in Excel or in Java.
Can anyone shed some light on this for me?
Thanks in advance for any pointers or hints of where to look for more
information.
Sincerely,
Jon
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
