import xlrd import xlwt rd = xlrd.open_workbook("data.xls") #获取excel表 rdsheet1Index = rd.sheet_by_index(0) # 获取sheet1的索引 rdsheet1name = rdsheet1Index.name # 获取sheet1的名称 rdsheet1rowname = rdsheet1Index.nrows # 获取行数 number = 0 num = [] while number < rdsheet1rowname: num.append(rdsheet1Index.row_values(number)) number = number + 1 wb = xlwt.Workbook() #创建excel表 ws = wb.add_sheet(rdsheet1name) #填写sheet1的名称 #将sheet1的数据全部填入到sheet1中 for i, item in enumerate(num): for j, val in enumerate(item): ws.write(i, j, val) wb.save("cesi.xls")