sheetProvider.putFormat(Col.WEDNESDAYHOURS, "0.00");
sheetProvider.putFormat(Col.THURSDAYHOURS, "0.00");
sheetProvider.putFormat(Col.FRIDAYHOURS, "0.00");
sheetProvider.putFormat(Col.WEEKENDHOURS, "0.00");
final PropertyMapping mapping = new PropertyMapping();
for (final HRPlanningDO planningSheet : list) {
// final ProjektDO projekt = projektDao.getById(planningSheet.getProjektId());
// final PFUserDO user = userGroupCache.getUser(planningSheet.getUserId());
// mapping.add(Col.USER, user.getFullname());
// final String projektName = projekt != null ? projekt.getName() : "";
// mapping.add(Col.PROJEKT, projektName);
// mapping.add(Col.WEEK_OF_YEAR, DateTimeFormatter.instance().getFormattedWeekOfYear(planningSheet.getStartTime()));
// mapping.add(Col.PRIORITY, planningSheet.getPriority());
// mapping.add(Col.PROBABILITY, planningSheet.getProbability());
// mapping.add(Col.UNASSIGNEDHOURS, planningSheet.getUnassignedHours());
// mapping.add(Col.MONDAYHOURS, planningSheet.getMondayHours());
// mapping.add(Col.TUESDAYHOURS, planningSheet.getTuesdayHours());
// mapping.add(Col.WEDNESDAYHOURS, planningSheet.getWednesdayHours());
// mapping.add(Col.THURSDAYHOURS, planningSheet.getThursdayHours());
// mapping.add(Col.FRIDAYHOURS, planningSheet.getFridayHours());
// mapping.add(Col.WEEKENDHOURS, planningSheet.getWeekendHours());
// mapping.add(Col.DESCRIPTION, planningSheet.getDescription());
sheet.addRow(mapping.getMapping(), 0);
}
sheet.setZoom(3, 4); // 75%
return xls;
}