Hi, colleagues,
This error pops up when I read .xlsx file using Gnarly core mapper Tool in Arcgis.
Traceback (most recent call last):
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\CoreMapper.py", line 57, in <module>
wb = load_workbook(filename=tables[0])
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\excel.py", line 149, in load_workbook
_load_workbook(wb, archive, filename, read_only, keep_vba)
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\excel.py", line 236, in _load_workbook
color_index=wb._colors)
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 327, in read_worksheet
fast_parse(ws, xml_source, shared_strings, style_table, color_index)
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 315, in fast_parse
parser.parse()
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 94, in parse
dispatcher[tag_name](element)
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 291, in parse_data_validation
dv = parser(tag)
File "C:\Users\NY_CAF\Desktop\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\worksheet\datavalidation.py", line 225, in parser
dv = DataValidation(**element.attrib)
TypeError: __init__() got an unexpected keyword argument '{http://schemas.microsoft.com/office/spreadsheetml/2014/revision}uid'
Failed to execute (CoreMapper2).
I have updated my python using
sudo pip install openpyxl --upgrade
and
sudo pip install pyexcel --upgrade
the results:
The directory '/home/ningyu/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
The directory '/home/ningyu/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
Requirement already up-to-date: openpyxl in /usr/local/lib/python2.7/dist-packages
Requirement already up-to-date: et_xmlfile in /usr/local/lib/python2.7/dist-packages (from openpyxl)
Requirement already up-to-date: jdcal in /usr/local/lib/python2.7/dist-packages (from openpyxl)
But no luck, the error still shows up
Could u help? Big big thanks