一种使用python,pyxl自动填写excel表格的方法

没有标题

希望表格里面字体不一样，用下拉自动填充做不到，openpyxl可以

1.导入模块选择表格和sheet

from openpyxl import Workbook, load_workbook
from openpyxl.styles import Font
from random import choice, randint
book = ('sdf.xlsx')
wb = load_workbook(book)

sheet1 = wb.worksheets[