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