Jama Connect® to Excel Functions (JCI)

Author: Amanda Jennewein

Date: June 21, 2024

Audience: Everyone

Environmental details: Jama Connect Interchange™

Summary:

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.

Note

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.