forum.ksavinetworkinventory.com

I have GNI working fine on widows 10 , all relevant modules loaded correctly including openpyxl etc. as per the instructions.

I can run through some modelling up to and including step 4, producing outputs as expected.

If I try to run a report I get a pop up dialog ... expected See log for more details ... and in the log the following detail: -


2021-03-12T14:26:48 2 Uncaught error while executing algorithm
Traceback (most recent call last):
File "C:/PROGRA~1/QGIS2~1.18/apps/qgis-ltr/./python/plugins\processing\core\GeoAlgorithm.py", line 203, in execute
self.processAlgorithm(progress)
File "C:/Users/XXXX/.qgis2/python/plugins\GniPlannerFTTH\planner_report.py", line 105, in processAlgorithm
self.fitColumnWidth(worksheet)
File "C:/Users/XXXX/.qgis2/python/plugins\GniPlannerFTTH\planner_report.py", line 147, in fitColumnWidth
worksheet.column_dimensions[columnCells[0].column].width = max(length, 4)
File "C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\openpyxl\utils\bound_dictionary.py", line 26, in __getitem__
setattr(value, self.reference, key)
File "C:\PROGRA~1\QGIS2~1.18\apps\Python27\lib\site-packages\openpyxl\descriptors\base.py", line 44, in __set__
raise TypeError('expected ' + str(self.expected_type))
TypeError: expected <type 'basestring'>

2021-03-12T14:26:48 1 There were errors executing the algorithm.


can you help or point me to some way to resolve please. Superb software, would be great if it ran on QGIS 3.. but for now well done.

Which version of qgis are you using?

Hi!
I'm having the exact same problem.
I'm using QGIS 2.18.24.
Windows 10 x64.
openpyxl 2.6.4

Thanks!

Solved!
Downgraded openpyxl version and it worked!

Hi I use windows 10 x64.

hi,
as mentioned b4 i also solved it by downgrading openpyxl. to do that:
run the OSGeo4W shell (installed with QGis) as administrator then issue the command:
python -m pip install --upgrade openpyxl==2.5.4

<a href=https://enhanceyourlife.mom/>priligy review youtube</a> Zhao Ling swung the knife to break several tentative attacks in a row, and Bai Qing at this moment could no longer bear it

One patient died due to acute on chronic liver failure ACLF with acute kidney injury and the other due to cardiac failure <a href=https://fastpriligy.top/>buy priligy australia</a> Katelyn, USA 2022 05 28 23 10 33