解决：Excel的xls版本“已停止工作”问题的python代码（修复、重装office都不能解决问题） 

 1 #!/usr/local/env python
 2 # -*- coding:utf-8 -*-
 3 
 4 import xlrd
 5 import xlwt
 6 
 7 file_name1 = 'test.xls'
 8 file_name2 = 'new.xls'
 9 readbook = xlrd.open_workbook(file_name1)
10 writebook = xlwt.Workbook()
11 sheet_names = readbook.sheet_names()
12 len_sheets = len(sheet_names)
13 nrows = []
14 ncols = []
15 sheets = []
16 sheet_name_n = []
17 for i in range(len_sheets):
18     sheets.append(readbook.sheet_by_name(sheet_names[i]))
19     nrows.append(sheets[i].nrows)
20     ncols.append(sheets[i].ncols)
21     sheet_name_n.append(writebook.add_sheet(sheet_names[i]))
22     for j in range(nrows[i]):
23         for z in range(ncols[i]):
24             val = sheets[i].cell_value(j, z)
25             sheet_name_n[i].write(j, z, val)
26 writebook.save(file_name2)
posted @ 2020-04-05 07:40  遥~  阅读(379)  评论(0)    收藏  举报