Hi, How can I import data from an excel or csv file?
- Forum
- CAD Parametric Modelling
- PythonParts
Open Excel file in a Pythonpart [Vyřešeno]
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