Using the openpyxl module in an embedded Python class

I need to insert sheets into an excel workbook. This was challenging to do with just IRIS/Zen so I thought I could use the openpyxl Python library in an embedded Python method within IRIS. But I am encountering issues when executing Python code from within IRIS.

1. Environment Setup:
   • The Python version in the system is 3.6, and the openpyxl module is installed and accessible when running Python directly from the command line (python3).
   • However, when attempting to use openpyxl within an IRIS class method using [Language = python], I encounter errors like "module openpyxl has no attribute 'load_workbook'" or "no attribute 'version'".
   • The list of classes from print(dir(openpyxl)) when run from python3 and within an IRIS class method is different
2. Attempts to Resolve:
   • I confirmed that openpyxl is correctly installed, and the module works as expected in the command line, showing the correct version when running import openpyxl; print(openpyxl.__version__).
   • However, inside IRIS, using the same code results in errors.
3. Problem:
   • It seems that IRIS is not correctly recognizing or accessing the openpyxl module or certain attributes, such as load_workbook and __version__, which are available in the standalone Python environment.

Request for Help:

• What is the correct way to access and use the openpyxl module from within IRIS Python, and how can I resolve the module access issues that are preventing it from working in this environment?