phpexcel set width
snippet in php

phpexcel set width

user3351

$this->PhpExcel->createSheet($page);
$this->PhpExcel->setActiveSheetIndex($page);
$sheet = $this->PhpExcel->getActiveSheet();

$sheet->getColumnDimension('A')->setWidth(40);
$sheet->getColumnDimension('B')->setWidth(28);
$sheet->getColumnDimension('C')->setWidth(25);
$sheet->getStyle("A8:C8")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);