PHPExcel sets column width

Question

I set the column width for a CSV file using

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

But I do not see changes in the width of column A, what am I doing wrong?

+5

Amna ahmed Aug 20 '12 at 16:57

2 answers

Mark baker · Answer 1 · 2012-08-20T17:01:19+0000

Assuming you are using CSV Writer.

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

Rolling · Answer 2 · 2015-10-16T12:47:54+0000

Disable autoizeize first:

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

Now you can install:

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