[GIS] Error when trying to save an Excel file from attribute table using QGIS

csvexportqgis

I keep getting this error (see below) when trying to save the attribute table to an Excel file using XY Tools. Can anyone help? I have deleted and re-installed xytools but this hasn't helped.

An error has occured while executing Python code:

Traceback (most recent call last):
File "C:/Users/Doug/.qgis2/python/plugins\xytools\xytools.py", line 301, in excelSave
xlw.writeAttributeRow(rowNr, values)
File "C:/Users/Doug/.qgis2/python/plugins\xytools\providers\excel.py", line

57, in writeAttributeRow
self.ws.write(rowNr, colNr, cell)
File "build\bdist.win-amd64\egg\xlwt\Worksheet.py", line 1030, in write
self.row(r).write(c, label, style)
File "build\bdist.win-amd64\egg\xlwt\Worksheet.py", line 1078, in row
self.rows[indx] = self.Row(indx, self)
File "build\bdist.win-amd64\egg\xlwt\Row.py", line 42, in __init
raise ValueError("row index (%r) not an int in range(65536)" % rowx)
ValueError: row index (65536) not an int in range(65536)

Python version:
2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)]

QGIS version:
2.6.1-Brighton Brighton, e2a51df

Best Answer

As my comment suggests, you need to save to a newer version of excel (v2007 or >) to save a GIS table that has more than 65536 records.

Related Question