如何使用openpyxl在excel中将诸如“apple”、“carrots”、“mango”之类的列表导出到一个列中?在Python中

from openpyxl import Workbook

book = Workbook()
sheet = book.active
sheet[A1], sheet[A2], sheet[A3] = ["Apple", "carrots", "mango"]
book.save("my_file.xlsx")

将列表中的每个条目作为列表项写入工作表:

import openpyxl

l = ['apple', 'carrots', 'mango']

wb = openpyxl.Workbook()
ws = wb.active

col = 'C' # Set the desired column

for n, i in enumerate(l, 1):
    ws[col+str(n)] = i

wb.save("sample.xlsx")

应按所需列生成预期输出: