Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. start = time.time()
  2. sap = self.wb_sap.worksheets[0] #Sets The First Sheet in the Excel Workbook as the variable sap IN THE FUTURE THIS WILL BE MODIFIED TO BE THE SAME NUMBERED SHEET AS BEFORE
  3. wt = self.wb_wt.worksheets[1]#Sets the Trimmed Sheet in the Second Report as the var wt
  4. #This Set of Nested Loops goes through Tests for X's to T's Based on the Report - Report Comparison
  5. print(datetime.datetime.today())
  6. for saprow in sap.iter_rows():
  7. for wtrow in wt.iter_rows():
  8. if (saprow[3].value == wtrow[3].value and (saprow[2].value == wtrow[2].value)):#Material&OpCode Match
  9. if wtrow[4].value in ("T","P"): #New Report Entry is Marked as T/P
  10. self.deadrows.append(wtrow)
  11. if saprow[4].value is "X": #Old Report Entry is Marked as X
  12. self.XT += 1#Increment X->Ts Counts
  13. else:
  14. self.TT += 1#Increment T->T Count
  15. elif wtrow[4].value in ("T","P"):
  16. self.deadrows.append(wtrow)
  17. elif wtrow not in self.deadrows:
  18. self.goodrows.append(wtrow)
  19.  
  20. print("Timing: ", endtime-start)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement