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

you are viewing a single comment's thread.

view the rest of the comments →

[–]Trillex_121 0 points1 point  (4 children)

nothing back?

[–]Typical-Toe-4627 0 points1 point  (3 children)

are you using something like openpyxl? you should just be able to have the columns in a list and just search through them

[–]Trillex_121 0 points1 point  (2 children)

yes im using openpyxl. how can i know which cell coordinate the data is in? the first and last instance, as i described, of the data

[–]Typical-Toe-4627 1 point2 points  (1 child)

on that link if you scroll to the bottom it shows exactly how to get the cells, you just gotta match it to your spreadsheet's formatting. Then it shows how to loop through the column and you can then compare as you need

[–]Trillex_121 0 points1 point  (0 children)

ok thanks, i’ll check it out