SchoolTool error

Asked by Chad on 2015-11-16

Was exporting schooltool spreadsheet this morning and it threw out an error.

System failure.

Ticket nr. 999f0a90-3058-440d-afdf-458872411375.

Please contact your administrator.

row index (65536) not an int in range(65536)

File "/usr/lib/python2.7/dist-packages/schooltool/task/", line 184, in runTransaction
  result = callable(*args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/report/", line 451, in execute
  report_file = self.renderToFile(renderer, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/schooltool/report/", line 500, in renderToFile
  self.renderReport(renderer, stream, *args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 935, in renderReport
  workbook = renderer(*args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 920, in __call__
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 737, in export_sections_enrollment
  ws, year, term, section, row=row)
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 710, in export_section_enrollment
  ], ws, row=row)
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 301, in print_table
  self.print_row(cells, ws, row=(row+y), col=col)
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 306, in print_row
  self.write(ws, row, col+x,, **
File "/usr/lib/python2.7/dist-packages/schooltool/export/", line 155, in write
  ws.write(row, col, data, style)
File "/usr/lib/python2.7/dist-packages/xlwt/", line 1030, in write
  self.row(r).write(c, label, style)
File "/usr/lib/python2.7/dist-packages/xlwt/", line 1078, in row
  self.__rows[indx] = self.Row(indx, self)
File "/usr/lib/python2.7/dist-packages/xlwt/", line 42, in __init__
  raise ValueError("row index (%r) not an int in range(65536)" % rowx)

<ExceptionWithTraceback (ValueError('row index (65536) not an int in range(65536)',))>
File "/usr/lib/python2.7/dist-packages/schooltool/task/", line 211, in __call__
  result = self.runTransaction('execute', True, self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/schooltool/task/", line 201, in runTransaction
  raise failure

Question information

English Edit question
SchoolTool Edit question
No assignee Edit question
Last query:
Last reply:
Tom Hoffman (tom-hoffman) said : #1

It seems you've run into excel's row limit. Do you have a lot of sections for some reason?

Chad (chadelp) said : #2

Yes. 2014 has 1221 sections and 2015 has 1358. We need help urgently as marks are to be entered soon.

Tom Hoffman (tom-hoffman) said : #3

OK, we've made this a high priority, but we've got some work we've got to finish first.

Is there some particular reason you need to do this to enter marks?

Chad (chadelp) said : #4

I am the network administrator, the team needed me to export a master list which I would then use to create passwords for all the new persons. I know the password could be entered directly on the web, but they wanted a sheet on excel with all the details.

Can you help with this problem?

Provide an answer of your own, or ask Chad for more information if necessary.

To post a message you must log in.