Kymera Office Document Module

Hi,

I’m playing around with Kymera Office Document Module but it’d be nice to have some info about its API, any help?

If not possible, I’m trying to figure out how to create, modify and save an excel file with formulas. Right now I can open a template, modify it and save it but for some reason the new file doesnt execute those formulas. I think it could be the way I created it. Any suggestion?

Hello Patricia,
The API we are using is the Apache Commons POI libraries. After modifying your cells, you need to update the formulas with a Formula Evaluator. More information can be found at the following URL:

poi.apache.org/spreadsheet/eval.html

Thanks that was exactly what I was asking for.