Skip to main content

Jama Connect Interchange User Guide

Jama Connect to Excel Functions

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.

Jama_Connect_to_Excel_functions.png

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 that reference Excel macros or Excel tables. For details on supported functions, see the Apache POI website.