Reading excel file in ACP using scripting

Josef Behal · May 2023

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 · May 2023

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

Loading...

https://discuss.ansys.com/home/leaving?allowTrusted=1&target=https%3A%2F%2Fansyshelp.ansys.com%2Faccount%2Fsecured%3Freturnurl%3D%2FViews%2FSecured%2Fcorp%2Fv231%2Fen%2Facp_ug%2Facp_up_Extend_Python_Env.html

Cookies are small text files stored on your computer that tell us when you're signed in. To learn how to allow cookies, check the online help in your web browser.

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 · June 2023

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 · June 2023

Yes exactly. Glad it worked!

Reading excel file in ACP using scripting

Welcome!

Comments

Loading...

Welcome!

Welcome!

Quick Links

Categories