# -*- coding: utf-8 -*-
import codecs
import sys
reload(sys)
sys.setdefaultencoding('utf8') # 设置默认编码格式为'utf-8'
import json
import urllib2;
import xlrd
import re
import numpy as np
import io
import unicodecsv as ucsv
import requests
filename = "D:/a/lonlat02.csv"
def readExcel():
workbook = xlrd.open_workbook("D:/lonlat/industry_site_info.xlsx")
sheet = workbook.sheet_by_name("industry_site_info")
print(sheet.nrows)
Scrap_hotel_lists(sheet)
def Scrap_hotel_lists(sheet):
ids = []
Latitudes = []
longitudes = []
dzmcs = []
jdmcs = []
for i in range(1, sheet.nrows):
try:
print (i)
values = sheet.row_values(i)
dzmc = value