#!/usr/bin/env python
# _*_ coding:utf-8 _*_

from xlwt import *

# 指定以utf-8格式打开
file = Workbook(encoding='utf-8')
# 指定打开的文件名
table = file.add_sheet('data')

# 字典数据
data = {
    "1": ["张三", 150, 120, 100],
    "2": ["李四", 90, 99, 95],
    "3": ["王五", 60, 66, 68]
}

list_data = []

# for 循环
num = [a for a in data]
# 字典数据取出后，先排序
# print(num)
num.sort()
# print(num)

for x in num:
    # 讲字符串转为整数
    t = [int(x)]
    for a in data[x]:
        t.append(a)
    list_data.append(t)
# print(t)
# print(list_data)

for i, p in enumerate(list_data):
    # 讲数据写入进文件中
    # print(i, p)
    for j, q in enumerate(p):
        print(i, j, p)
        table.write(i, j, q)

file.save('data.xlsx')

import os
import xlwt, xlrd
from xlutils.copy import copy

def write_to_excel(sheet_name):
    file_name = 'test_1.xls'
    if not os.path.exists(file_name):
        workbook = xlwt.Workbook(encoding='ascii')
        worksheet = workbook.add_sheet(sheet_name,cell_overwrite_ok=True)
        workbook.save(file_name)

    rb = xlrd.open_workbook(file_name)
    wb = copy(rb)
    ws = wb.get_sheet(0)
    # 新的sheet页面
    worksheet = wb.add_sheet(sheet_name,cell_overwrite_ok=True)
    worksheet.write(0,0,'test')
    wb.save(file_name)

if __name__ == '__main__':
    for x in range(3):
        write_to_excel(x)