$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getAlignment()->setHorizontal('center');
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle($CONF_NEXTIME['report_columns'][$colnum] . $rowCounter)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$colnum += 1;
break;
}
}
//end foreach
$objPHPExcel->getActiveSheet()->getStyle('R' . $rowCounter)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('R' . $rowCounter)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
//and now for the by-project hours breakdown area
$output = $ts->selectByProjectHoursByUser($A['uid'], $startStamp, $endStamp);
//m29 is the project number, n29 is the total hours and so on
$prjrow = $finalRowCount + 2;
$objPHPExcel->getActiveSheet()->mergeCells("A{$prjrow}:D{$prjrow}");
$objPHPExcel->getActiveSheet()->setCellValue('A' . $prjrow, 'TOTAL PER PROJECT');
$objPHPExcel->getActiveSheet()->getStyle('A' . $prjrow)->getFont()->setUnderline(UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle('A' . $prjrow)->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A' . $prjrow)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A' . $prjrow)->getAlignment()->setHorizontal('center');
$prjrow++;
$prowStart = $prjrow;
$flag = false;
foreach ($output as $key => $value) {
$objPHPExcel->getActiveSheet()->mergeCells("A{$prjrow}:C{$prjrow}");
$objPHPExcel->getActiveSheet()->setCellValue('A' . $prjrow, $key);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $prjrow, $value);