PHPExcel set column width

Question

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?

Answer 1

First, disable autosize:

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

Now, you can set:

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

Answer 2

Assuming you're using the CSV Writer.

CSV files do not support any formatting, just data, so column width (which is formatting) cannot be applied when you write a CSV file