How to read Multiple Sheets from an excel dynamically using Snaplogic

sys.path.append() can be used to import external jars (Java / Jython) to a script that you may have in place.

Steps:

1. Place a copy of the package / .jar file that you intend to use as part of the script in a directory on the Groundplex node (say under: /opt/snaplogic/<DIR_FOR_EXT_JARS>/…)
2. If you have multiple node(s) dedicated to run the SnapLogic service, repeat Step (1) for all nodes
3. Update your script in the “Script” snap to import the external library as follows:

import sys
.
.
sys.path.append(’/opt/snaplogic/<DIR_FOR_EXT_JARS>/sample.jar’)
.
.

Note: The above method would work only for a “Script” snap based pipeline execution(s) done on Groundplex node(s).