$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1); $letter++; $activeSheet->setCellValue("{$letter}{$count}", "=F{$count}*G{$count}"); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", $row['reference']); $letter++; $activeSheet->setCellValue("{$letter}{$count}", $row['o_date']); $letter++; $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['order'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['o_rate'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['rec'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", "=K{$count}-M{$count}"); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", "=N{$count}*K{$count}"); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $count++; $letter = 'A'; } $activeSheet->mergeCells("A{$count}:G{$count}"); $activeSheet->setCellValue("A{$count}", ""); $activeSheet->setCellValue("H{$count}", "=sum(H" . $startCount . ":H" . ($count - 1) . ")"); $activeSheet->getStyle("H{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++; $costLetter = $letter; $profitMargin = $row['profit_margin']; $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['cost'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1); $letter++; $s = "=({$profitMargin}/100*{$costLetter}{$count}) + {$costLetter}{$count}"; $activeSheet->setCellValue("{$letter}{$count}", "=({$profitMargin}/100*{$costLetter}{$count}) + {$costLetter}{$count}"); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1); $letter++; } if ($_GET['mm'] == 'complete' || $_GET['mm'] == 'rate') { $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['fix_rate'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['circular_rate'])); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; } $activeSheet->setCellValue("{$letter}{$count}", $row['days']); $activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4); $letter++; $count++; $letter = 'A'; } $activeSheet->getStyle("A" . ($startCount - 1) . ":{$lastLetter}" . ($count - 1))->applyFromArray($tableBorderArray); $activeSheet->setBreak("A{$count}", PHPExcel_Worksheet::BREAK_ROW); $count++; } $objPHPExcel->setActiveSheetIndex(0); $fileName = "mm_{$_GET['mm']}.xlsx";