def get_data(self,students,get_all=True, year=-1):
"""Returns list of students with student data information"""
print 'From year:', (str(year)+'-'+str(year+1))
print 'From title:',self.s.title
# Check if year is requested year
if year != -1 and (str(year)+'-'+str(year+1)) != self.s.title:
return
for row in range(self.header_row+1,self.s.get_highest_row()+1):
rowID = 0
val1 = self.s.cell(row=row,column=self.id_column).value
if self.s.cell(row=row,column=self.id_column).data_type == 's':
# remove hyphens
val1 = val1.replace('-','')
rowID = atoi(val1)
else:
rowID = int(val1)
student = find_by_id(students,rowID)
if student is None:
if get_all:
student = Student()
students.append(student)
else:
continue
# Get ID and year
student.stuID = rowID
student.gradYear = int(self.s.cell(row=row,column=self.gradYear_column).value)
# Get Name
student.last = str(self.s.cell(row=row,column=self.last_column).value)
student.first = str(self.s.cell(row=row,column=self.first_column).value)
# Get Address
student.street = str(self.s.cell(row=row,column=self.street_column).value)
student.city = str(self.s.cell(row=row,column=self.city_column).value)
student.state = str(self.s.cell(row=row,column=self.state_column).value)
student.zipcode = str(self.s.cell(row=row,column=self.zipcode_column).value)
# DOB
if str(self.s.cell(row=row,column=self.dob_column).value) == "None":
student.dob = ""
else:
time_tuple = time.strptime(str(self.s.cell(row=row,column=self.dob_column).value),"%Y-%m-%d %H:%M:%S")
student.dob = str(time_tuple.tm_mon)+"/"+str(time_tuple.tm_mday)+"/"+str(time_tuple.tm_year)
# Get IEP/504/ELL
student.HasIEP = (str(self.s.cell(row=row,column=self.iep_column).value) == 'IEP')
student.Has504 = (str(self.s.cell(row=row,column=self.p504_column).value) == '504 Plan')
student.IsELL = (str(self.s.cell(row=row,column=self.ell_column).value) == 'ELL')
