怎么把随机数写入Excel表格里呢
想把生成的八个随机数写到B2:I2里
import xlwt
book = xlwt.Workbook(encoding='utf-8', style_compression=0)
sheet = book.add_sheet('成绩表',cell_overwrite_ok=True)
for i, v in enumerate(nums_list):
sheet.write(1, i+1, v)
savepath = './result.xls'
book.save(savepath)
import pandas as pd
import random
data = [ random.randint(10,100) for i in range(8) ]
df = pd.DataFrame({},columns=data)
df.to_excel('aa.xls',index=False,startrow=0,startcol=1)