Set spreadsheet cell width using PHPExcel

Question

I am trying to set the cell width in an Excel document generated by PHPExcel using:

$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10'); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(false); 

but it does not work.

What is the method I need to call here?

Answer 1

This is a subtle difference, but it works fine for me:

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

Note that the difference between getColumnDimensionByColumn and getColumnDimension

Also, I don't even install AutoSize, and it works great.

Answer 2

The setAutoSize method should appear before setWidth:

 $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(false); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10'); 

Answer 3

Hi, I have the same problem. add 0.71 to the excel cell width value and set this value to

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

for example: Column width = 3.71 (excel value)

specify column width = 4.42

will provide an output file with the same cell width.

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

hope this help

Answer 4

Tha is because getColumnDimensionByColumn gets the index of the column (an integer starting at 0), not the row.

The same goes for setCellValueByColumnAndRow

Answer 5

autoSize for the column width set below. It works for me.

 $spreadsheet->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); 

Answer 6

The correct way to set the column width is to use a string published by Jahmic, however it is important to note that you need to apply the style after adding the data, and not earlier, otherwise the column width is not applied on some configurations

Answer 7

This worked for me:

 $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(false); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(10); 

be sure to add setAuzoSize(false) , before setWidth(); that Rolland mentioned