Is there a method anyone knows of where I can find a cell or row in a document if I have a value other than iterating through the whole document to search for it? Case is, I have to very large spread sheets that I need to compare and I am doing that by using a single UUID that exists in each record in each sheet.
So, basically:
ws1 = rows1
ws2 = rows2
for row1 in rows1:
uuid = row1[0].value
comp = row1[1].value
for row2 in rows2:
if row2[0] = uuid
if row2[0] = comp
do-stuff()
This seems more nested than it needs to be. Is there a way to find the value in rows2 easier than this?
No, there is no other way of searching by content than going cell by cell.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With