rom openpyxl import load_workbook
from tkinter import Tk
from tkinter.filedialog import askopenfilename
import datetime
import time
#StackOverflow - roganjosh
class ManualReporter:
    def __init__(self):
        Tk().withdraw()
        self.sap_file = None
        self.tracker_file = None
        self.wb_sap = None
        self.wb_wt = None
        self.XT = 0
        self.deadrows = []

    def open_sapfile(self):
        self.sap_file = askopenfilename()
        self.wb_sap = load_workbook(filename=self.sap_file)
        # Code to create a backup File in-case of Error or Fault
        copyfile = "Untimed_Report_SAP_" + str(datetime.date.today())+".xlsx"
        self.wb_sap.save(copyfile)
        print(self.sap_file)
    def open_tracker(self):
        self.tracker_file = askopenfilename()
        self.wb_wt = load_workbook(filename=self.tracker_file)
        print(self.tracker_file)
    def check_rows(self):
        sap = self.wb_sap.worksheets[0]
        wt = self.wb_wt.worksheets[0]
        for saprow in sap.iter_rows():
            for wtrow in wt.iter_rows():
                if (saprow[3].value == wtrow[4].value and int(saprow[2].value) == int(wtrow[5].value)):
                    if wtrow[7].value in ("T","P"): #WT Entry is Marked as T/P
                        if saprow[4].value is "X": #SAP Report Entry is Marked as X
                            self.XT += 1 #Count Changed Status Codes
                            self.deadrows.append(saprow) # Keeps List of The Rows to be Killed Off
                            #saprow.clear() - Insert Here Method to Delete/Clear/Augment Rows -
x = ManualReporter()
x.open_sapfile()
x.open_tracker()
x.check_rows()