python列表逐行写入excel,如何使用python将列表列表写入Excel？

How to write a list of list into excel using python 3?

new_list = [["first", "second"], ["third", "fourth"]]

with open("file_name.csv", 'w') as f:

fc = csv.writer(f, lineterminator='\n')

fc.writerows(new_list)

I can write this list into csv file but How canI want to write in excel file?

解决方案

Here is one way to do it using XlsxWriter:

import xlsxwriter

new_list = [['first', 'second'], ['third', 'four'], [1, 2, 3, 4, 5, 6]]

with xlsxwriter.Workbook('test.xlsx') as workbook:

worksheet = workbook.add_worksheet()

for row_num, data in enumerate(new_list):

worksheet.write_row(row_num, 0, data)

Output: