PHPExcel set column width

PHPphpexcel

I am setting column width for a .csv file using

  $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50);

But i cannot see any change in column A's width, what am i doing wrong?

Best Answer

First, disable autosize:

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(false);

Now, you can set:

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth("50");