python xlrd+xlwt+xlutils处理excel

​

import xlwt
import os
from xlrd import open_workbook
from xlutils.copy import copy

if os.path.exists(‘test.xls’):
# 先复制，然后写入
print(‘已存在’)
wb = open_workbook(‘test.xls’)
nrows = wb.sheets()[0].nrows
excel = copy(wb)
sh1 = excel.get_sheet(0)
else:
print(‘不存在’)
excel = xlwt.Workbook()
sh1 = excel.add_sheet(‘shearlet_to_vit’)
sh1.write(0, 0, ‘姓名’)
sh1.write(0, 1, ‘专业’)
sh1.write(0, 2, ‘科目’)
sh1.write(0, 3, ‘成绩’)
nrows = 1

sh1.write(nrows, 0, ‘王五’)
sh1.write(nrows, 1, ‘软件工程’)
sh1.write(nrows, 2, ‘Java开发’)
sh1.write(nrows, 3, 100)

excel.save(‘test.xls’)