function myExcel_WriteValuesToActiveRow(&$objPHPExcel, $arrValues) { for ($x = 0; $x < count($arrValues); $x++) { $columnLetter = chr(ord('A') + $x); $objPHPExcel->getActiveSheet()->SetCellValue($columnLetter . myExcel_getActiveRow(), $arrValues[$x]); } }
function myExcel_WriteValuesToActiveRow(&$objPHPExcel, $arrValues, $rowBold = false) { $x = 0; $activeSheet = $objPHPExcel->getActiveSheet(); foreach ($arrValues as $value) { // Get cell location i.e. A1 or C3 $columnLetter = PHPExcel_Cell::stringFromColumnIndex($x); $cellLocation = $columnLetter . myExcel_getActiveRow(); // Debug if (strpos(request_uri(), '-DEBUG-NOEXCELWRITE-REPORTWRITE-') !== false) { print "write to {$cellLocation} with {$value} <br/>\n"; } else { // Set this cell value $activeSheet->SetCellValue($cellLocation, strip_tags($value)); // Set this cell style if ($rowBold === true) { $activeSheet->getStyle($cellLocation)->applyFromArray(array('font' => array('bold' => true))); } } $x++; } }