Python Error: row index not an int in range(65536)

Question

I am getting this message when writing to an excel file using xlwt:

row index (u'RN') not an int in range(65536)

The line throwing the error come from here:

sheet.write(x,fieldKey, row.OBJECTID)

Where x is a counter I set to set the row value and fieldKey is another counter to set the column value.

I don't know why I am getting this message because the value (u'RN') is a string value, but it's telling me that it is not an int in range(65536). I believe the range(65536) is the limit of the excel table. Again, I was only writing 18 records, so I don't see why this error came up. Can anyone help?

Thanks, Mike

As you say the value is a string rn which is not an int - nevermind the range part... — Jon Clements
– Jon Clements, Commented Jul 12, 2013 at 22:28
Why are you passing u'RN' as a column index/coordinate? What do you expect that to do? — abarnert
– abarnert, Commented Jul 12, 2013 at 22:37
Ahhhh...I've been working on this for hours. I just found that I set x as a variable buried deep in my script in another instance. I actually tried looking for that earlier, but it just hit me now. Jon, your post made me look again. thanks for that. — Mike
– Mike, Commented Jul 12, 2013 at 22:39

user3878423 · Accepted Answer · 2014-07-25 20:38:36Z

4

This is because you can not write to excel for more than 65536 lines. (You can now in the xlsx format). I had the same issue, try .to_csv()

answered Jul 25, 2014 at 20:38

user3878423

412 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Racso · Accepted Answer · 2013-07-12 22:38:04Z

1

The error you are getting is because x (the row index) isn't a number, but a string. Check the values you are passing to the sheet.write method; the first two must be numbers (try printing them before making the call).

answered Jul 12, 2013 at 22:38

Racso

2,4691 gold badge20 silver badges24 bronze badges

3 Comments

abarnert Over a year ago

Well, maybe not clearly, but it seems likely that if you have a counter named x and a key named fieldKey, it's the latter that would hold a string u'RN'. But you're right, I'm making an assumption that could be wrong.

Racso Over a year ago

Indeed: stackoverflow.com/questions/17624942/…

Mike Over a year ago

Thanks everyone. I had through I was passing x as a number until it was overwritten with another x variable I had set. Thanks for all your help!

Community · Accepted Answer · 2017-05-23 10:27:23Z

1

According to this SO post the args to sheet.write should be ycoord,xcoord,value

so it should be something like sheet.write(0,0,answer1)

edited based on responses.

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Jul 12, 2013 at 22:30

NolanPower

4094 silver badges12 bronze badges

1 Comment

abarnert Over a year ago

It's easier to remember if you call them row and col instead of y and x. Then the order seems natural, instead of backward.

kleopatra · Accepted Answer · 2013-09-09 10:32:27Z

0

you can change in row.py inside the def init(self, rowx, parent_sheet) the limit, let's make it x2 for example:

if not (isinstance(rowx, int) and 0 <= rowx <= 131071):

changed from

if not (isinstance(rowx, int) and 0 <= rowx <= 65536):

edited Sep 9, 2013 at 10:32

kleopatra

51.6k28 gold badges103 silver badges220 bronze badges

answered Sep 9, 2013 at 10:26

Yoni Tzafrir

535 bronze badges

Collectives™ on Stack Overflow

Python Error: row index not an int in range(65536)

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related