Reading excel file in ACP using scripting

Josef Behal

Hi I would like to read excel file in ACP, but I'm not able to import for example openpyxl module. I need to use excel because of some further calculations in it.

Is there any way how to install this package?

Pernelle Marone-Hitz

Hi @Josef Behal , thanks for creating a new post. Please refer to this page of the ACP documentation:

https://ansyshelp.ansys.com/account/secured?returnurl=/Views/Secured/corp/v231/en/acp_ug/acp_up_Extend_Python_Env.html

ACP is delivered with a frozen Python, the Python environment cannot be modified with standard modules such as pip. Nevertheless, it is possible to import and use Python modules within ACP which are not delivered with the installation (matplotlib, for example). You can do this by creating a virtual Python environment (VENV) and adding this environment to the ACP Python path.

Josef Behal

By adding you mean extendin sys.path property by the path leading to venv with my custom library right? Something like that worked for me.

Thank you for an advice.

Pernelle Marone-Hitz

Yes exactly. Glad it worked!