set value excel python code example

Example 1: change value in excel using python

from xlrd import open_workbook
from xlutils.copy import copy

xl_file = r'D:\path\excel.xls'
rb = open_workbook(xl_file, formatting_info=True)
wb = copy(rb)
sheet = wb.get_sheet(0)
sheet.write(0,2,'New_Data_For_Cell')
wb.save(xl_file)

Example 2: change value in excel in python

from xlrd import open_workbook
from xlutils.copy import copy

xl_file = r'D:\path\excel.xls'
rb = open_workbook(xl_file)
wb = copy(rb)
sheet = wb.get_sheet(0)
sheet.write(0,2,'New_Data_For_Cell')
wb.save(xl_file)