用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()