List to excel python

import xlsxwriter

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

with xlsxwriter.Workbook('test.xlsx') as workbook:  #generate file test.xlsx
    worksheet = workbook.add_worksheet()

    for row_num, data in enumerate(new_list):
        worksheet.write_row(row_num, 0, data)

Python write list to excel file

import xlwt
from tempfile import TemporaryFile
book = xlwt.Workbook()
sheet1 = book.add_sheet('sheet1')

supersecretdata = [34,123,4,1234,12,34,12,41,234,123,3,56]

for i,e in enumerate(supersecretdata):
    sheet1.write(i,1,e)

name = "random.xls"
book.save(name)
book.save(TemporaryFile())

Source: stackoverflow.com

Similar codes

0 vote229 views1 answer
Install magic python 2
Python
1 vote226 views1 answer
Tkinter center frame
Python
2 votes239 views2 answers
How to code a yes or no question in python v3.8
Python
1 vote235 views1 answer
Filter with different operator in django
Python Django
0 vote254 views1 answer
Check if key exists in sesson python flask
Python Flask
1 vote316 views1 answer
Add help text in Django model forms
Python Django
9 votes208 views3 answers
How to make a random variable in python
Python
7 votes209 views3 answers
Python set cwd to file location
Python
68 votes206 views5 answers
Pandas iterate rows
Python
1 vote219 views1 answer
Pandas change dtype to timestamp
Python