1.ctrl+alt+L 自动整理。
2.excel的读写数据。
import xlrd
import xlwt
xls = xlrd.open_workbook(‘E:/11/人员匹配查找.xls’)
table = xls.sheet_by_index(0)
for i in range(0,10):
print(table.cell_value(i,1))
print(table.cell(i,1).value)
new_workbook = xlwt.Workbook()
worksheet = new_workbook.add_sheet(‘new_test’)
worksheet.write(0,0,‘zhou’)
new_workbook.save(‘e:/11/33.xls’)