如果设置了本地环境变量，可以直接执行#coding=utf-8#-*-coding:utf-8-*-importxlwtimportrandomnumList=[]#Settablestyledefset_style(name,height,bold=False):style=xlwt.XFStyle()font=xlwt.Font()font.name=namefont.bold=boldfont.color_index=4font.height=heightstyle.font=fontreturnstyledefgeneratorNum():list=['139','188','185','136','155','135','158','151','152','153']str='0123456789'foriinrange(2000):#ChangetherequirednumberhereglobalnumListnumList.append(random.choice(list)+"".join(random.choice(str)foriinrange(8)))#writeExceldefwrite_excel():f=xlwt.Workbook()sheet1=f.add_sheet('number',cell_overwrite_ok=True)row0=["number"]globalnumListprint(numList)colum0=numList#writethefirstrowforiinrange(0,len(row0)):sheet1.write(0,i,row0[i],set_style('TimesNewRoman',220,True))#writethefirstcolumnforiinrange(0,len(colum0)):sheet1.写(i+1,0,colum0[i],set_style('TimesNewRoman',220,True))f.save('test.xls')if__name__=='__main__':generatorNum()write_excel()复制代码
