if (area == null) {
area = new Area();
String countyNr = areaCode.substring(0, 2);
county = countyManager.load(countyNr);
if (county == null) {
throw new ProTransException("Fylkesnr " + countyNr
+ " finnes ikke");
}
area.setCounty(county);
area.setAreaCode(areaCode);
}
area.setSnowloadBasicValue(excelUtil.readCellAsBigDecimal(row,
COLUMN_AREA_SNOWLOAD_BASIC_VALUE));
area.setHeightLimit(excelUtil.readCellAsInteger(row,
COLUMN_AREA_HEIGHT_LIMIT));
area.setDeltaSnowload(excelUtil.readCellAsBigDecimal(row,
COLUMN_AREA_DELTA_SNOWLOAD));
area.setSnowloadMax(excelUtil.readCellAsBigDecimal(row,
COLUMN_AREA_SNOWLOAD_MAX));
area.setSnowloadComment(excelUtil.readCell(row,
COLUMN_AREA_SNOWLOAD_COMMENT, null));
} else {
throw new ProTransException("Feil kommunenr " + areaCode);
}
areaManager.saveArea(area);
}