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 = []