1from xlrd import open_workbook
2from xlutils.copy import copy
3
4xl_file = r'D:\path\excel.xls'
5rb = open_workbook(xl_file, formatting_info=True)
6wb = copy(rb)
7sheet = wb.get_sheet(0)
8sheet.write(0,2,'New_Data_For_Cell')
9wb.save(xl_file)
1from xlrd import open_workbook
2from xlutils.copy import copy
3
4xl_file = r'D:\path\excel.xls'
5rb = open_workbook(xl_file)
6wb = copy(rb)
7sheet = wb.get_sheet(0)
8sheet.write(0,2,'New_Data_For_Cell')
9wb.save(xl_file)