python之openyxl 创建excel

创建默认excel文件，然后根据sheet.cell() 对位置定位后进行内容输入。

涉及 enumerate() 函数，shett.cell() 函数

代码：

# 练习openpyxl 创建excel.xlxs文件
import openpyxl
import random

# 创建excel表
wb = openpyxl.Workbook()
sheet = wb.active
sheet.title = "热血年华比赛成绩"

names = ["名字1","名字2","名字3","名字4","名字5","名字6","名字7"]
titles = ["姓名","项目1","项目2","项目3","项目4","项目5","项目6","项目7","项目8"]
print(len(titles))
for col_index,title in enumerate(titles):
    sheet.cell(1 , col_index +1 ,title)
for row_index,name in enumerate(names):
    sheet.cell(row_index +2 ,1 ,name )
    for col_index in range(2,len(titles) +1): 
        sheet.cell(row_index +2 ,col_index , random.randrange(50,1000))

wb.save("热血比赛成绩汇总.xlsx")
print("excel文件已经创建")

结果：