2020-07-15 04:45 PM - last edited on 2021-09-15 11:57 AM by Noemi Balogh
Solved! Go to Solution.
2020-07-17 03:21 PM
pip3 uninstall openpyxlAfter this first command it will ask for a confirmation, type in y to proceed.
pip3 install -Iv openpyxl==3.0.3In-house at Graphisoft our tests used (and still uses) the previous version of openpyxl (3.0.3), that's the reason why our tests passed and we didn't detect this issue. We have to fix our tests to always use the latest 3rd party libraries.
2020-07-15 06:47 PM
2020-07-15 07:34 PM
JSN wrote:FYI:
3) Are the Python Snippets from the experimental addon for 23.3000 not supported anymore as I get several traceback errors or might this be a general permiossion issue of my IT system?
2020-07-16 08:49 AM
TMA_80 wrote:
From the getting started pdf ( it is somhow strange to announce a feature and make it invisible ?!!!) :
To use Python Palette, switch on the Python Palette Experimental Feature on the Work Environment dialog. The palette can be opened from the Palettes menu.
1. Launch ARCHICAD
2. Go to Options > Work Environment > More Options
3. Under Experimental Features, switch on "Enable Python Palette" checkbox
4. Open the Python Palette from Window > Palettes > Python Palette
2020-07-16 09:15 AM
poco2013 wrote:- Ah yes thx for pointing this out, I will check this out out by modifying the experimental scripts later.
JSN wrote:FYI:
3) Are the Python Snippets from the experimental addon for 23.3000 not supported anymore as I get several traceback errors or might this be a general permiossion issue of my IT system?
The Python Snippets from the experimental version are not supported in the new version in 24. The new version uses a http: interface which can be used either internally in Archicad or completely external with a open Archicah instance.
However, the old experimental snippets can be easily modified to work by just adding the appreciate "connect" commands to open the interface.
A revised (new) excel example is given on the new Python site which will accomplish this.
https://graphisoft.com/downloads/python
Do You have any specific questions?
Traceback (most recent call last): File "C:\Test\Room report generator test\room_report.py", line 198, in <module> wbFiller.SaveWorkbook(outputPath) File "C:\Test\Room report generator test\room_report.py", line 116, in SaveWorkbook self._fillWorkbook(workbook) File "C:\Test\Room report generator test\room_report.py", line 169, in _fillWorkbook worksheet = workbook.copy_worksheet(base) File "C:\Program Files\Python37\lib\site-packages\openpyxl\workbook\workbook.py", line 419, in copy_worksheet cp.copy_worksheet() File "C:\Program Files\Python37\lib\site-packages\openpyxl\worksheet\copier.py", line 41, in copy_worksheet self.target.merged_cells = copy(self.source.merged_cells) File "C:\Program Files\Python37\lib\copy.py", line 88, in copy return copier(x) File "C:\Program Files\Python37\lib\site-packages\openpyxl\worksheet\cell_range.py", line 503, in __copy__ n.ranges.append(copy(r)) File "C:\Program Files\Python37\lib\copy.py", line 88, in copy return copier(x) File "C:\Program Files\Python37\lib\site-packages\openpyxl\worksheet\cell_range.py", line 150, in __copy__ title=self.title) TypeError: __init__() got an unexpected keyword argument 'min_col' === Process aborted ===Seems like that it files to write the file, but the "Excel Export" script is workwing flawlessly so I don't think that it is lacking permissions. Maybe someone can tell me more about where to continue investigating. Thx!
2020-07-16 10:41 AM
2020-07-16 10:53 AM
2020-07-16 12:12 PM
2020-07-17 02:01 PM
Minh Nguyen
Technical Support Engineer
GRAPHISOFT
2020-07-17 03:21 PM
pip3 uninstall openpyxlAfter this first command it will ask for a confirmation, type in y to proceed.
pip3 install -Iv openpyxl==3.0.3In-house at Graphisoft our tests used (and still uses) the previous version of openpyxl (3.0.3), that's the reason why our tests passed and we didn't detect this issue. We have to fix our tests to always use the latest 3rd party libraries.