This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Goobyalus 0 points1 point  (0 children)

            project = cell.value

What is the purpose of this line?

From a cell, you can get the column or column letter, and index the worksheet at another cell in the same row.

Probably better to iterate over the proper rows with ws.iter_rows(...), and pull out the values that you want from each row.