Python—学习打印出简单excel表格

    技术2022-07-13  78

    import xlwt wb = xlwt.Workbook() ws = wb.add_sheet('成绩') def excel(): a = [[" ","成品","三级品","成品","三级品","成品","三级品","成品","三级品"],["一班","20","2","20","2","20","2","20","2"], ["二班","20","2","20","2","20","2","20","2"],["三班","20","2","20","2","20","2","20","2"],["四班","20","2","20","2","20","2","20","2"]] for i in range(len(a)): for j in range(len(a[0])): ws.write(i, j,a[i][j]) wb.save('peipeiii.xls') excel()

    输出表格结果:

    Processed: 0.011, SQL: 9