# Kymera Office Document Module

**URL:** <https://forum.inductiveautomation.com/t/kymera-office-document-module/8376>\
**Category:** 3rd Party Modules\
**Created:** [April 28, 2014, 10:21am UTC](https://forum.inductiveautomation.com/t/kymera-office-document-module/8376 "2014-04-28T10:21:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![patricia.martin](https://avatars.discourse-cdn.com/v4/letter/p/7cd45c/32.png) [@patricia.martin](https://forum.inductiveautomation.com/u/patricia.martin)\
**Post date:** [April 28, 2014, 10:21am UTC](https://forum.inductiveautomation.com/t/kymera-office-document-module/8376/1 "2014-04-28T10:21:28Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [April 28, 2014, 11:36pm UTC](https://forum.inductiveautomation.com/t/kymera-office-document-module/8376/2 "2014-04-28T23:36:52Z")

</div>

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](https://poi.apache.org/spreadsheet/eval.html)

---

<div class="post-metadata">

**Author:** ![patricia.martin](https://avatars.discourse-cdn.com/v4/letter/p/7cd45c/32.png) [@patricia.martin](https://forum.inductiveautomation.com/u/patricia.martin)\
**Post date:** [April 29, 2014, 9:28am UTC](https://forum.inductiveautomation.com/t/kymera-office-document-module/8376/3 "2014-04-29T09:28:29Z")

</div>

Thanks that was exactly what I was asking for.
