python - Changing the column of the current working cell.coordinate? -

i trying change column of cell.coordinate next column , wondering how can such? instance, i'm working in cell a5 or a# change cell b5 or b#.

background:

i working on program globs directory 2 column xlsx file. first column file names , second column particular text want search. program uses file names of first column, prints if finds match, reason haven't been able come way change current working cell next column on a# b# , use string in b# search doc. ( able figure out how search doc if force string trying figure how xlsx document)

thank help!!

as shown in tutorial, need call iter_rows method on instance of worksheet, example:

for row in ws.iter_rows('a:b'):     cell in row:         print cell 

if first column filename , second text, can try:

for row in ws.iter_rows('a:b'):     filename_cell, text_cell = row     filename = filename_cell.value     text = text_cell.value     my_search(filename, text) 

where my_search() function used search text in file…