jwr

import osimport win32com.clientNUM_ROWS = 2231EXCEL_FILE = "U:\\Verification\\doors_reqs.xls"REQS_FILE = "Numbers.txt"xl = win32com.client.Dispatch("Excel.Application")xl.Visible = 1INFILE = file(REQS_FILE, "r")reqList = INFILE.read()INFILE.close()book = xl.Workbooks.Open(EXCEL_FILE)sheet = book.Worksheets(1)for i in range(NUM_ROWS):	reqNumber = sheet.Range("A" + str(NUM_ROWS - i)).Value	if reqList.find(reqNumber) == -1:		sheet.Range("A" + str(NUM_ROWS - i)).EntireRow.Delete()book.SaveAs(Filename = "doors_reqs_left.xls")