#!/usr/bin/python
'''Drops a row from the pending sheet'''
from openpyxl import load_workbook
import argparse

argparser = argparse.ArgumentParser(prog='droprow.py')
argparser.add_argument('--row_num', required=True,
                       help='One-indexed row number to move')
argparser.add_argument('--infile', default='membership.xlsx',
                       help='Input file name')
argparser.add_argument('--outfile', default='membership.xlsx',
                       help='Output file name')
args = argparser.parse_args()

wb = load_workbook(filename=args.infile)
pending_sheet = wb.worksheets[2]

for col in 'ABCDEFGHI':
    # clear out old row
    pending_sheet["%s%s" % (col, args.row_num)].value = None

wb.save(filename=args.outfile)