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’)