PHPExcel style problem

3
votes
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Name');

1.How I set this to bold?

2.How I set the width(I will have some dinamic text in the cells!)?

I have read the documentation, but I haven't found any solutions!

2
phpphpexcel

2 Answers

7
votes

Bold:

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

Width:

$objPHPExcel->getActiveSheet()->getCell('A1')->setWidth(15);

Not tested though.

0
votes

$col zero 0 based

$worksheet->getColumnDimensionByColumn($col)->setWidth($width);

Hi 2009