def getHouseList(self):
"""
从文件中获取房屋信息列表
"""
data = xlrd.open_workbook('houseInfo_address.xls')
table = data.sheet_by_name(u'houseinfo')
for index in range(1,table.nrows):
houseId = table.cell(index,0).value
address = table.cell(index,1).value
area = table.cell(index,2).value
price = table.cell(index,3).value
longitude = table.cell(index,4).value
latitude = table.cell(index,5).value
house = House()
house.houseId = houseId
house.address = address
house.price = price
house.area = area
house.longitude = longitude
house.latitude = latitude
self.houses.append(house)
if (index % PageNumber == 0):
self.processHouses()
self.saveToFile()
self.excelIndex += len(self.houses)
self.houses = []
if (len(self.houses) != 0):
self.processHouses()
self.saveToFile()
self.houses = []
