for sheet_root, sheet_dirs, sheet_files in os.walk(sheet_directory):
        for sheet_file in sheet_files:
            if sheet_file.endswith('.xlsx'):
                #print(sheet_file)
                sheet_xl_file = os.path.join(sheet_root, sheet_file)
                wb = load_workbook(sheet_xl_file, data_only=True)
                ws = wb.get_sheet_by_name('Unannotated')
                pos_col_no = 'E'
                alt_col_no = 'G'
                ref_col_no = 'F'
                score_col_no = 'V'
                row_no = 4
                NG = ws[score_col_no + str(row_no)]
                #print row_no
                cell_pos = ws[pos_col_no + str(row_no)]
                cell_ref = ws[ref_col_no + str(row_no)]
                cell_alt = ws[alt_col_no + str(row_no)]
                cpos = Scores(POS=cell_pos.value, ALT=cell_alt.value, REF=cell_ref.value)
                print cpos  ##prints only row E4:G4:F4
                #while cpos:
                while row_no <=10:
                    if (dict_pos.has_key(cpos)):
                        NG = dict_pos[cpos]
                        print dict_pos[cpos]
                    else:
                        NG = 'Unknown_' + datetime.now().strftime("%B") + datetime.now().strftime("%Y")
                    row_no += 1
                    #print row_no
                    cell_pos = ws[pos_col_no + str(row_no)]
                    cell_ref = ws[ref_col_no + str(row_no)]
                    cell_alt = ws[alt_col_no + str(row_no)]
                    cpos = Scores(POS=cell_pos.value, ALT=cell_alt.value, REF=cell_ref.value)
                    print cpos
                    if (dict_pos.has_key(cpos)):
                        NG = dict_pos[cpos]
                    else:
                        NG = 'Unknown_' + datetime.now().strftime("%B") + datetime.now().strftime("%Y")
                        print NG
                wb.save(sheet_xl_file)
process_xl_sheets()

/usr/bin/python2.7 annotate_new_dict.py
Scores(POS=u'73', ALT=u'G', REF=u'A')
11
Scores(POS=u'114', ALT=u'T', REF=u'C')
1
Scores(POS=u'263', ALT=u'G', REF=u'A')
Unknown_July2017
Scores(POS=u'309', ALT=u'T', REF=u'C')
Unknown_July2017
Scores(POS=u'497', ALT=u'T', REF=u'C')
Unknown_July2017
Scores(POS=u'513', ALT=u'G', REF=u'GCA')
Unknown_July2017
Scores(POS=u'750', ALT=u'G', REF=u'A')
1
Scores(POS=u'1189', ALT=u'C', REF=u'T')

Process finished with exit code 0