PHPExcel Style Problem

Question

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

1.How did I make it bold?

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

I read the documentation, but I did not find any solutions!

Answer 1

Fatty

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

width:

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

Not tested.

Answer 2

$ col 0 based

$ worksheet-> getColumnDimensionByColumn ($ COL) → setWidth ($ width);

Hello 2009