今天接触Python导出数据，发现确实比VB要厉害很多。


#数据导出列表
import xlwt
import os
workbook = xlwt.Workbook(encoding="utf-8")
booksheet = workbook.add_sheet("SS")
DATA = (("学号","姓名","年龄","性别","成绩"),
    ("1001","A","11","男","12"),
        ("1002","B","12","男","22"),
        ("1003","C","13","男","32"),
        ("1004","D","14","男","42"))
for i,row in enumerate(DATA):
    for j,col in enumerate(row):
        booksheet.write(i,j,col)
workbook.save(r"C:\Users\Administrator\Desktop\AAA.xls")
print(os.getcwd()) #返回当前工作表目录


导出结果：

 

 

功能：

enumerate()是python的内置函数，用于将一个可遍历的数据对象(如列表、元组或字符串等)组合为一个索引序列，同时列出数据和数据下标，多用于for循环

语法：

enumerate(a,start)

a是可迭代对象，start是计数起始数字

示例一：