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)
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)