PHPExcel – How to make part of the text bold-open source projects PHPOffice/PHPExcel

9 years ago

admin

1 minute

pacific

$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B1', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D1', 'world!');

for single cell use:

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

for multiple cells use:

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