Open and Edit an Excel template using Python's openpyxl library

excel_generator.py

from openpyxl import load_workbook

wb = load_workbook('template.xlsx')

# grab the active worksheet
ws = wb.active

# Data can be assigned directly to cells
ws['A2'] = 'Tom'
ws['B2'] = 30

ws['A3'] = 'Marry'
ws['B3'] = 29

# Save the file
wb.save("sample.xlsx")

Thanks!

This is very useful. It's almost the easiest way on the Internet.

Extremely Thanks

how can we insert the data using row and column number ?

how can we insert the data using row and column number ?
sheet.cell(row=row, column=col).value = 'value'

Thanks a million!