excel write column
import xlsxwriter
workbook = xlsxwriter.Workbook('write_list.xlsx')
worksheet = workbook.add_worksheet()
my_list = [1, 2, 3, 4, 5]
for row_num, data in enumerate(my_list):
worksheet.write(row_num, 0, data)
workbook.close()