import os
import win32com.client
NUM_ROWS = 2231
EXCEL_FILE = "U:\\Verification\\doors_reqs.xls"
REQS_FILE = "Numbers.txt"

xl = win32com.client.Dispatch("Excel.Application")
xl.Visible = 1
INFILE = 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")