Insert list into Excel column

2019-08-12 04:50发布

问题:

Is it possible to insert list to Excel column using xlsxwriter library?

This is my current script:

list = ['a','b','c','d']
for letter in list                          
        list.append(letter)
worksheet.write('A1', list)

Can anybody could give me a simple insert of list so that I can have my reference?

回答1:

Use:

worksheet.write_column('A1', list)

docs: https://xlsxwriter.readthedocs.org/worksheet.html#write_column