import xlrd
from xlutils.copy import copy
openFile = xlrd.open_workbook(‘写入excel地址’)
write = copy(openFile)
write_sheet = write.get_sheet(‘写入的表格下标’)
#写入单元格值
write_sheet.write(‘int行标’, ‘int列标’, ‘值’)
#保存
write.save(‘写入excel地址’)
import xlrd
from xlutils.copy import copy
openFile = xlrd.open_workbook(‘写入excel地址’)
write = copy(openFile)
write_sheet = write.get_sheet(‘写入的表格下标’)
#写入单元格值
write_sheet.write(‘int行标’, ‘int列标’, ‘值’)
#保存
write.save(‘写入excel地址’)