如何将值列表中的多个项目输入电子表格

Question

我试图将列表项存储在一个变量中填充电子表格的单元格，直到列表中的项用完（因此它适用于任何大小的列表）。我尝试了各种 for 循环和切片，但都没有运气。

import openpyxl

wb = openpyxl.Workbook()

sheet=wb.active

addresses=['132 W Raven Dr, Chandler, AZ 85286', '2412 W Binner Dr, Chandler, AZ 85224', '1081 W Lark Dr, Chandler, AZ 85286', '1603 W Maplewood St, Chandler, AZ 85286', '1300 W Estrella Dr, Chandler, AZ 85224', '2120 E Geronimo St, Chandler, AZ 85225', '2100 W Shannon St, Chandler, AZ 85224', '4591 S Felix Pl, Chandler, AZ 85248', '2290 E Cherrywood Pl, Chandler, AZ 85249', '23421 S 130th St, Chandler, AZ 85249', '1601 E Shannon St, Chandler, AZ 85225']

sheet['A1':] = addresses[0:]

Answer 1

您真正想要做的是将列表中的每个元素添加到它自己的单元格中，如 A1、A2、A3 等。像这样尝试，看看它是否能给你你正在寻找的结果。import openpyxlwb = openpyxl.Workbook ()sheet = wb.activeaddresses = [    '132 W Raven Dr, Chandler, AZ 85286',    '2412 W Binner Dr, Chandler, AZ 85224',    '1081 W Lark Dr, Chandler, AZ 85286',    '1603 W Maplewood St, Chandler, AZ 85286',    '1300 W Estrella Dr, Chandler, AZ 85224',    '2120 E Geronimo St, Chandler, AZ 85225',    '2100 W Shannon St, Chandler, AZ 85224',    '4591 S Felix Pl, Chandler, AZ 85248',    '2290 E Cherrywood Pl, Chandler, AZ 85249',    '23421 S 130th St, Chandler, AZ 85249',    '1601 E Shannon St, Chandler, AZ 85225']for index in range (len (addresses)) :    cell = 'A' + str (index + 1)    sheet [cell] = addresses [index]wb.save ('tester.xlsx')