python 生成excel文件

使用python 输出excel文件

import xlwt
import random
lonlat=[]
wb = xlwt.Workbook()
ws = wb.add_sheet('point')

for i in range(1000):
    lon = random.uniform(116.313903, 116.471488)
    lat = random.uniform(39.869917, 39.991809)
    lonlat.append({'lon': lon, 'lat': lat})
    ws.write(i, 0, i)
    # ws.write(i, 1, lon)
    # ws.write(i, 2, lat)
    ws.write(i,1,str(lon)+","+str(lat))

wb.save('./prints02.xls')