Python code to edit excel sheet using openpyxl library

import openpyxl

# F:\Neelkanth Python Research
# The openpyxl.load_workbook() function takes in the flename and returns
# a value of the workbook data type. This Workbook object represents the Excel
# file, a bit like how a File object represents an opened text file.
wb = openpyxl.load_workbook('F:/Neelkanth_Python_Research/sockets vs mq latency.xlsx')
print(type(wb))

# print sheets from workbook
print(wb.get_sheet_names())

sheet1 = wb['MQ non-blocking']
print('######### sheet1.title ###########')
print(sheet1.title)
print('##################################')


for i in range(5, 15,1):
    print(i, sheet1.cell(column= 6,row = i).value,
          sheet1.cell(column= 7,row = i).value)
    a = sheet1.cell(column= 7,row = i).value -  sheet1.cell(column= 6,row = i).value
    a = round(a * 1000000, 0)
    sheet1.cell(column = 8, row = i).value = a

wb.save('F:/Neelkanth_Python_Research/new_1.xlsx')