PHPExcel Make first row bold

Question

I am trying to make cells in first row are bold.

This is the method I have created for that purpose.

function ExportToExcel($tittles,$excel_name)  {   $objPHPExcel = new PHPExcel();   $objRichText = new PHPExcel_RichText();   // Set properties   $objPHPExcel->getProperties()->setCreator("SAMPLE1");   $objPHPExcel->getProperties()->setLastModifiedBy("SAMPLE1");   $objPHPExcel->getProperties()->setTitle("SAMPLE1");   $objPHPExcel->getProperties()->setSubject("SAMPLE1");   $objPHPExcel->getProperties()->setDescription("SAMPLE1");     // Add some data   $objPHPExcel->setActiveSheetIndex(0);    $letters = range('A','Z');   $count =0;   $cell_name="";   foreach($tittles as $tittle)   {    $cell_name = $letters[$count]."1";    $count++;    $value = $tittle;    $objPHPExcel->getActiveSheet()->SetCellValue($cell_name, $value);    // Make bold cells    $objPHPExcel->getActiveSheet()->getStyle($cell_name)->getFont()->setBold(true);   }   // Save Excel 2007 file   $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);   //$objWriter->save(str_replace('.php', '.xlsx', __FILE__));   $objWriter->save($excel_name.".xlsx");  } 

The problem is in output excel file the cells are not bold.

Answer 1

Try this for range of cells:

$from = "A1"; // or any value $to = "B5"; // or any value $objPHPExcel->getActiveSheet()->getStyle("$from:$to")->getFont()->setBold( true ); 

or single cell

$cell_name = "A1"; $objPHPExcel->getActiveSheet()->getStyle( $cell_name )->getFont()->setBold( true ); 

hope that helps

Answer 2

Try this

$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);