python3学习（十三）--优化写excel

# #写excel # import xlwt # # book = xlwt.Workbook() # sheet = book.add_sheet('xuesheng') # all_data = [ # ['id','name','sex','phone','country'], # ['1','xiaoming','男',13111111111,'china'], # ['2','xiaoming','男',13111111111,'china'], # ['3','xiaoming','男',13111111111,'china'], # ['4','xiaoming','男',13111111111,'china'], # ['5','xiaoming','男',13111111111,'china'], # ['6','xiaoming','男',13111111111,'china'], # ] # # line = 0 #行号 # # for data in all_data: # # sheet.write(line,0,data[0]) # # sheet.write(line, 1, data[1]) # # sheet.write(line, 2, data[2]) # # sheet.write(line, 3, data[3]) # # sheet.write(line, 4, data[4]) # # line+=1 # # book.save('s.xls') # # line = 0 #行号 # for data in all_data: # #['id','name','sex','phone','country'] # #['1','xiaoming','男',13111111111,'china'] # col = 0 # 列号 # for d in data: # # id name sex # sheet.write(line, col, d) # col +=1 # line+=1 # book.save('1.xls') ###################### # import string # case = list(string.ascii_uppercase) # #print('a=>0') # index = 0 # for c in case: # print('%s => %s'%(c,index)) ####### enumerate自动加1，不需要手动加1 # import string # case = list(string.ascii_uppercase) # #print('a=>0') # index = 0 # for index,c in enumerate(case,2):#参数中设置2，则默认从2开始 # print('%s => %s'%(c,index)) ##############优化 import xlwt book = xlwt.Workbook() sheet = book.add_sheet('xuesheng') all_data = [ ['id','name','sex','phone','country'], ['1','xiaoming','男',13111111111,'china'], ['2','xiaoming','男',13111111111,'china'], ['3','xiaoming','男',13111111111,'china'], ['4','xiaoming','男',13111111111,'china'], ['5','xiaoming','男',13111111111,'china'], ['6','xiaoming','男',13111111111,'china'], ] #enumerate() 自动加1 print(type(all_data)) for line,data in enumerate(all_data): for col,d in enumerate(data): sheet.write(line,col,d) book.save('s2.xls')

 

转载于:https://www.cnblogs.com/xm-sunnylin/p/9836919.html