def load_from_sheet(a_sheet):
AssetColl = []
for rowidx in range(a_sheet.nrows):
if a_sheet.cell(rowidx, 1).value == 'Class & Category' or \
a_sheet.cell(rowidx, 1).value == 'Class Code' or \
a_sheet.cell(rowidx, 1).value == 'nvarchar' or \
a_sheet.cell(rowidx, 1).value == '' or \
a_sheet.cell(rowidx, 1).value == 20.0:
continue
iterAsset = Category()
iterAsset.class_code = a_sheet.cell(rowidx, 1).value
iterAsset.description = a_sheet.cell(rowidx, 2).value
iterAsset.category_code = a_sheet.cell(rowidx, 3).value
iterAsset.category_description = a_sheet.cell(rowidx, 4).value
AssetColl.append(iterAsset)
return AssetColl
