Python IndexError list

Question

I want to read data from an .ods file (using ezodf), and convert it to JSON.

Here is my code:

try:
    while conf[i, 2].value != None:
        export_data['priorities'][conf[i, 2].value] = str(int(conf[i, 3].value))
        i+=1
except IndexError:
    print("This probably has a better solution.");

conf[x, y] references a cell in the conf sheet. As you can see I want to read the values of column i as long as there isn't empty cell in it.

The problem is that the first empty cell is raising an IndexError exception.

Can I fix this in a simple way, for example, check the length of this column?

Borealid · Accepted Answer · 2013-01-25 17:10:54Z

1

This should be what you're looking for (I'm assuming conf is a spreadsheet table):

for i in range(conf.nrows()):
   export_data['priorities'][conf[i, 2].value] = str(int(conf[i, 3].value))

But you should know that the int(conf[i, 3].value) bit will throw an exception if the spreadsheet contains a non-integral value.

There's nothing terribly wrong with your try/except method of doing this.

answered Jan 25, 2013 at 17:10

Borealid

99.3k9 gold badges111 silver badges123 bronze badges

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

Collectives™ on Stack Overflow

Python IndexError list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related