python 读写XLS

import xlrd
from xlutils.copy import copy

data = xlrd.open_workbook(r‘E:\work\Text ID.xls‘)
table = data.sheet_by_name(u‘Sheet1‘)

TextID = table.cell(i,0).value

table.put_cell(row,col,1,“string",0)

#简单的写入
row = 0
 
col = 0
 
# 类型 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error
ctype = 1 value = ‘单元格的值‘
 
xf = 0 # 扩展的格式化
 
table.put_cell(row, col, ctype, value, xf)

wb = copy(data)
wb.save(‘e:/work/result.xls‘)