属性表输出为xlsx格式【脚本工具分享】
9 个评论
pip不执行呀,提示不是内部或外部命令
脚本加载进去,没有parameters啊?
worksheet.write(i, ii, rr)
raise TypeError("Unsupported type %s in write()" % type(token))
Failed to execute (属性表输出为xlsx格式).
raise TypeError("Unsupported type %s in write()" % type(token))
Failed to execute (属性表输出为xlsx格式).
失败信息如下:
Traceback (most recent call last):
File "D:\Program Files (x86)\ArcGIS\Desktop10.8\ArcToolbox\Toolboxes\2fff.py", line 24, in <module>
worksheet.write(i, ii, rr)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 88, in cell_wrapper
return method(self, *args, **kwargs)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 447, in write
return self._write(row, col, *args)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 527, in _write
raise TypeError("Unsupported type %s in write()" % type(token))
TypeError: Unsupported type <type 'tuple'> in write()
Traceback (most recent call last):
File "D:\Program Files (x86)\ArcGIS\Desktop10.8\ArcToolbox\Toolboxes\2fff.py", line 24, in <module>
worksheet.write(i, ii, rr)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 88, in cell_wrapper
return method(self, *args, **kwargs)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 447, in write
return self._write(row, col, *args)
File "D:\Python27\ArcGIS10.8\lib\site-packages\xlsxwriter\worksheet.py", line 527, in _write
raise TypeError("Unsupported type %s in write()" % type(token))
TypeError: Unsupported type <type 'tuple'> in write()
跟楼上报同样的错 24,88,447,527
if ii==len(list(fields))-1:
worksheet.write(i, ii, rr.__str__())
else:
worksheet.write(i, ii, rr.__str__())
i+=1
xlsxfile.close()
倒数第三行代码跟倒数第五行代码保持一致就不报错了,缺一个,.__str__()
worksheet.write(i, ii, rr.__str__())
else:
worksheet.write(i, ii, rr.__str__())
i+=1
xlsxfile.close()
倒数第三行代码跟倒数第五行代码保持一致就不报错了,缺一个,.__str__()