PHPExcel: How to Bold a Cell’s Value CodeUnit 14 JUL 2010

PHPExcel is a phenomenal Excel generating library for PHP which I have mentioned on this site numerous times before, and which is currently my defacto way for quickly knocking out all those annoying Excel downloads that clients always seem to MUST have!

Today’s quick code tip is on how to embolden a cell’s value – in other words how to replace that big B bold button with some code! ;)

Now the recommended method for applying styles to cells or cell ranges is by making use of style arrays to set a number of styles all at once, mostly because setting styles one by one can turn out to be a little resource intensive.

So in keeping with this then, here is how you would make a cell’s contents bold:

$workbook = new PHPExcel;
$sheet = $workbook->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World');
$styleArray = array(
'font' => array(
'bold' => true
$writer = new PHPExcel_Writer_Excel5($workbook);
header('Content-type: application/');

And there you go, as simple as that!

Related Link:

Related Posts:

About Craig Lotter

South African software architect and developer at Touchwork. Husband to a cupcake baker and father to two little girls. I don't have time for myself any more.

  • Test

    Thanks a lot

  • Vickey 0077

    before post the code go and practice urself before that dont waste other’s  golden time.

  • satiri

    Hi,  thanks for the clue. Btw, have you ever found a way to make part of cell value become bold ?

  • Jason

    Thanks for the tip!