Skip to main content
Question

Importing openpyxl

  • July 22, 2019
  • 8 replies
  • 137 views

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

stalknecht
Contributor
Forum|alt.badge.img+21
  • Contributor
  • 305 replies
  • 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

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+21
  • Contributor
  • 305 replies
  • July 23, 2019

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

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+21
  • Contributor
  • 305 replies
  • July 23, 2019

@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

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

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+21
  • Contributor
  • 305 replies
  • July 24, 2019

@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/