Skip to main content
Question

Importing openpyxl


Forum|alt.badge.img

Hello All,

I am trying to import an external module named openpyxl in FME but unfortunately isn't able to setup the environment. Can anyone please help me with identifying what all is required to setup the module in FME?

Every time i try to run it inside the python shutdown script it throws the error as module doesn't exist.

8 replies

stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • July 22, 2019

You should use the same python version you've installed the library to.

I think the python interpreter in FME is different from the one you use for the openyxl outside FME


Forum|alt.badge.img
stalknecht wrote:

You should use the same python version you've installed the library to.

I think the python interpreter in FME is different from the one you use for the openyxl outside FME

In the scripting part i am using Esri ArcGis Desktop(Python 2.7)

 

and for the translation i am using FME Python 2.7


stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • July 23, 2019
asabhinavgreats wrote:

In the scripting part i am using Esri ArcGis Desktop(Python 2.7)

 

and for the translation i am using FME Python 2.7

On which version did you install the openpyxl? Does it work apart from FME?


Forum|alt.badge.img
stalknecht wrote:

On which version did you install the openpyxl? Does it work apart from FME?

@stalknecht 2017 FME Version. Its working inside the python shutdown script independent of the workbench operation.


stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • July 23, 2019
asabhinavgreats wrote:

@stalknecht 2017 FME Version. Its working inside the python shutdown script independent of the workbench operation.

Sorry, maybe I'm confused. Was it working in earlier version and you try it now in a newer version. If yes try to use the same interpreter.


Forum|alt.badge.img
stalknecht wrote:

Sorry, maybe I'm confused. Was it working in earlier version and you try it now in a newer version. If yes try to use the same interpreter.

I tried it for the first time in FME 2017 using the interpreters mentioned above in pics and it isn't working. I changed the interpreters also but still the issue is prevailing.


Forum|alt.badge.img
stalknecht wrote:

Sorry, maybe I'm confused. Was it working in earlier version and you try it now in a newer version. If yes try to use the same interpreter.

@stalknecht I am not sure how to use this link Installing python packages to FME Desktop


stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • July 24, 2019
asabhinavgreats wrote:

@stalknecht I am not sure how to use this link Installing python packages to FME Desktop

Here is a link on how to install and use PIP: https://www.liquidweb.com/kb/install-pip-windows/

Here is alink how to install the openpyxl:

https://openpyxl.readthedocs.io/en/stable/


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings