Open Excel file in a Pythonpart [Vyřešeno]


Hi, How can I import data from an excel or csv file?

Show solution Hide solution

Hi Daniele,

you can use openpyxl, which is part of the Allplan installation.

We have also included a utility (Utils.TabularDataUtil) that allows you to read an Excel (read_xlsx) or csv (read_csv) file into a table.

Best regards
Horst

Hi Daniele, for example you can use "pandas".
The documentation is very good and it is feature rich.
You have to install it manually to your site-packages.

VG
Marcus

Hi Daniele,

you can use openpyxl, which is part of the Allplan installation.

We have also included a utility (Utils.TabularDataUtil) that allows you to read an Excel (read_xlsx) or csv (read_csv) file into a table.

Best regards
Horst

Hello @Horst_Hohmann
I was looking at Allplan API and I can´t find openpyxl.
Where can I find more information about such functions?

I guess Openpyxml is an independent python package.
It should be located somewhere in the allplans python folder under /lib/site-packages.
This could be the documentation:
https://openpyxl.readthedocs.io/en/stable/

br
marcus

VG
Marcus