$objPHPExcel->getActiveSheet()->getStyle($cellIdentifire[$i] . $cell . ':' . $cellIdentifire[$i] . $cell)->applyFromArray($styleThinBlackBorderOutline);
//Table body Line color $objPHPExcel -> getActiveSheet() -> getStyle('A' . $j . ':A' . $j) -> applyFromArray($styleThinBlackBorderOutline);
} else {
//when have check box
if ($checkBoxIndex && in_array($i - 1, $checkBoxIndex)) {
$objDrawing = new PHPExcel_Worksheet_Drawing();
if ($row[$tableFieldList[0][$i - 1]] == 0) {
$objDrawing->setPath('image/unchecked.png');
} else {
$objDrawing->setPath('image/checked.png');
}
$objDrawing->setCoordinates($cellIdentifire[$i] . $cell);
//$objDrawing -> setCoordinates('D' . $j);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
} else {
$objPHPExcel->getActiveSheet()->SetCellValue($cellIdentifire[$i] . $cell, getValueFormat($row[$tableFieldList[0][$i - 1]], $dataType[$i - 1]));
}
$objPHPExcel->getActiveSheet()->getStyle($cellIdentifire[$i] . $cell . ':' . $cellIdentifire[$i] . $cell)->applyFromArray($styleThinBlackBorderOutline);
//Table body Line color $objPHPExcel -> getActiveSheet() -> getStyle('A' . $j . ':A' . $j) -> applyFromArray($styleThinBlackBorderOutline);
}
if ($tableFieldList[0][$i - 1] == 'sl') {
$objPHPExcel->getActiveSheet()->getStyle('A' . $cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
} else {
if ($dataType[$i - 1] == 'numeric') {
$objPHPExcel->getActiveSheet()->getStyle($cellIdentifire[$i] . $cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
} else {
if ($dataType[$i - 1] == 'string' || $dataType[$i - 1] == '0' || $dataType[$i - 1] == 'html') {
$objPHPExcel->getActiveSheet()->getStyle($cellIdentifire[$i] . $cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
} else {
$objPHPExcel->getActiveSheet()->getStyle($cellIdentifire[$i] . $cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
}
<td class="txtLeft"; colspan="'.$tableFieldCount.'">'.$row[$tableFieldList[0][$groupBySqlIndex]].'</td>
</tr>';
$tempGroupId=$row[$tableFieldList[0][$groupBySqlIndex]];
}
*/
echo '<tr>';
for ($i = 0; $i < $tableFieldCount; $i++) {
//if($i != $groupBySqlIndex){ //For Avoid Group
if ($dataType[$i] == 'html') {
//For Color Field
echo '<td style="height:5px;width:' . $tableHeaderWidth[$i] . '%;background-color:' . $row[$i] . '"></td>';
} else {
//if($i==0)
// echo '<td style="width:'.$tableHeaderWidth[$i].'%; text-align: '.$alignment["0"].';">'.$sl.'</td>';
//else
echo '<td style="width:' . $tableHeaderWidth[$i] . '%; text-align: ' . $alignment[$dataType[$i]] . ';">' . getValueFormat($row[$i], $dataType[$i]) . '</td>';
}
//}
}
echo '</tr>';
$sl++;
}
echo '</tbody>
</table>';
} else {
echo 'No record found.';
}
function getValueFormat($value, $dataType)
{
//$parameterList['alignment'] = array("numeric"=>"right","string"=>"left",""=>"center");
$retVal = 0;
