19.01.2023 - 17:02
Uhr
Hi, How can I import data from an excel or csv file?
Support Forum
- Forum
- CAD Parametric Modelling
- PythonParts
Open Excel file in a Pythonpart [Gelöst]
Lösung anzeigen Lösung verbergen
20.01.2023 - 07:45
Uhr
*
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
20.01.2023 - 06:41
Uhr
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
20.01.2023 - 07:45
Uhr
*
[Lösung]
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
17.03.2023 - 12:09
Uhr
Hello @Horst_Hohmann
I was looking at Allplan API and I can´t find openpyxl.
Where can I find more information about such functions?
20.03.2023 - 15:35
Uhr
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