拷贝
def fun3_3_2():
workbook = xlrd.open_workbook('3_3 xlutils 修改操作练习.xlsx')
new_workbook = copy(workbook)
new_workbook.save("new_test.xls")
xlutils 读取,修改excel
import xlrd
import xlwt
from xlutils.copy import copy
def fun3_3_3():
workbook = xlrd.open_workbook("test.xls")
new_workbook = copy(workbook)
sheet = workbook.sheet_by_index(0)
col2 = sheet.col_values(1)
cel_value = sheet.cell_value(1, 1)
print(col2)
print(cel_value)
write_save = new_workbook.get_sheet(0)
write_save.write(0, 0, "xlutils写入!")
new_workbook.save("new_test.xls")