Page 1 of 1

Unable to produce reports.

Posted: Fri Mar 12, 2021 2:32 pm
by robertT-B
I have GNI working fine on widows 10 :D , 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.

Re: Unable to produce reports.

Posted: Mon Mar 15, 2021 5:34 am
by gni_support
Which version of qgis are you using?