Python批量生成excel文件内容

此代码用于生成xls文件，完成后可导入SQL数据库（参考https://jingyan.baidu.com/article/ce09321b9a0e252bff858ff9.html）

#coding=utf-8

import xlwt #写入Excel表的库 若没有此包，需要 py2: pip install xlwt 或 py3: pip3 install xlwt
import random

if __name__=="__main__":

    wbk = xlwt.Workbook(encoding = 'ascii')
    sheet = wbk.add_sheet("wordCount")#Excel单元格名字
    db_num = 10000 # the number of databased row
    sno_list = []
    cno_list = []
    grade_list = []

    for i in range(db_num):
        sno_list.append(90000 + random.randint(1, 9999)) # sno between 90001 and 99999
        cno_list.append(random.randint(1, 6)) # cno between 1 and 6
        grade_list.append(random.randint(0, 100)) # grade

    sheet.write(0, 0, label = 'sno')
    sheet.write(0, 1, label = 'cno')
    sheet.write(0, 2, label = 'grade')

    for i in range(db_num):
        row = i + 1
        sheet.write(row, 0, label = sno_list[i])
        sheet.write(row, 1, label = cno_list[i])
        sheet.write(row, 2, label = grade_list[i])
    wbk.save('datebase.xls')   #保存为xls文件