import xlwt #导入模块
import numpy as np
year=np.linspace(1960, 2019,60)#第1列数据
stid=['55673','55666','54828']#第1行数据
def write_excel():#进行写入
f = xlwt.Workbook()#创建一个工作薄
sheet1 = f.add_sheet('test',cell_overwrite_ok=True)#添加工作表test
for j in range(0, len(year)):#写入第1列数据,从第二行起
sheet1.write(j+1,0,year[j])
for jj in range(0,len(stid)):#写入第1行数据,表头
sheet1.write(0,jj+1,stid[jj])
for ii in range(0,len(stid)):#按行写入数据
for i in range(0,len(year)):
sheet1.write(i+1,ii+1,int(year[i])/(i+1))
f.save('test.xls')
if __name__ == '__main__':
write_excel()