Example of xlsxwriter

gistfile1.py

# coding: UTF-8

from xlsxwriter.workbook import Workbook

data = [[1, 2, 3], [4, 5, 6], ["hoge", "fuga", "piyo"]]

workbook = Workbook("./test.xlsx")
worksheet = workbook.add_worksheet("sheet1")

format_ = workbook.add_format({"align": "center", "valign": "vcenter"})

colcnt = len(data[0])
rowcnt = len(data)
for i in range(rowcnt):
    for j in range(colcnt):
        worksheet.write(i, j, data[i][j], format_)

workbook.close()