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)