openpyxl demo

xl.py

#!/usr/bin/env python 

from openpyxl import load_workbook
from openpyxl.utils import coordinate_from_string, column_index_from_string


class ExcelReading:

    def __init__(self,file_name):
        self.file_name = file_name;
        self.work_book = load_workbook(self.file_name);
        return 

    def print_data(self):
        sheets= self.work_book.get_sheet_names();
        sheet_name = sheets[0];
        ws = self.work_book.get_sheet_by_name(sheet_name);
        for row in ws.rows:
            for cell in row:
                if cell.value  == "Arijit9":
                    row_index = cell.row; 
                    col_index = cell.col_idx; 
                    new_col_index = col_index+2; 
                    ws.cell(row = row_index, column = new_col_index).value  = "Rajni"
        self.work_book.save("newbook.xlsx");
        return 

def main() :
    e = ExcelReading("test_input.xlsx");
    e.print_data();
    return 


if __name__ == "__main__" :
    main();