Jama Connect® to Excel Functions (JCI)

Amanda Jennewein
Amanda Jennewein
  • Updated

Author: Amanda Jennewein

Date: June 21, 2024

Audience: Everyone

Environmental details: Jama Connect Interchange™


This module brings the power of Microsoft Excel Functions into Jama Connect. When a user enters data in Jama Connect, the entered values are sent to an Excel template where a function or calculation is run. The resulting value is sent back to Jama Connect and automatically entered in another read-only field, as specified in the configuration.

Screenshot 2024-06-21 at 11.57.41 AM.png


The Excel Functions module uses an Excel SDK (Apache POI 5.2.3) to run functions in memory. The SDK doesn’t currently support functions referencing Excel macros or tables. For details on supported functions, see the Apache POI website.

Additional Information

Jama Connect Interchange User Guide

Jama Connect Interchange™ Excel Templates



Please feel free to leave feedback in the comments below.

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.