python操作excel----xlwt(写)

1.  导入第三方包

import xlwt#只能写，不能读

2.  新建一个excel

book = xlwt.Workbook()

3.  新建一个sheet

sheet = book.add_sheet('case1_sheet')

4.  往excel中写入数据

stus = [
    ['姓名', '年龄', '性别', '分数'],
    ['mary', 20, '女', 89.9],
    ['mary', 21, '女', 89.9],
    ['mary', 22, '女', 89.9],
    ['mary', 23, '女', 89.9]
]

row = 0

for stu in stus:

    col = 0

    for s in stu:

        sheet.write(row, col, s)

        col += 1

    row += 1

5.  保存excel

book.save('test.xls')#保存excel到当前目录下