Attach a custom (User defined xla) function to a workbook - how can this be done?

Please let me know if it is possible to attach an *.xla programatically using Aspose.Cells API. I can't seem to find anything in the Java docs?

-Chris-

Hi Chris,

Well, I think you may try to set it as an add-in function, you can call Cell.setAddInFormula method to set an add-in formula / function if it works. See the API Reference: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/com/aspose/cells/cell.html

Thank you.

I find it odd that the method is under Cell (VBA code to do anyhting, not just to a cell), but this may be what I was looking for. I'll let you know if it works.

-Chris-

If the formulas in the XLA add-in are used in thousands of cells, do I have to find each cell that might use the formula and use SetAddInFormula in each of them?

Hi,

Well, yes, your understanding is correct!

Thank you.

In an environment where every second counts, this would not be acceptable!

We should be able to simply set the XLA globally, and all cells refer to it.

Do you have any plans to change this?

Hi,

Could you give us your sample file that you want to get? After knowing your actual requirement, we can further investegate whether we can implement your need or not.

Thank you.