用xlsxwriter

import xlsxwriter as xw

workbook = xw.Workbook(r"D:mycodefiles报表1.xlsx")
sheet0 = workbook.add_worksheet("sheet0")
for i in range(0, 300):
sheet0.write(0, i, i)
workbook.close()
原文地址:https://www.cnblogs.com/zhang-da/p/14220393.html