Php – Get Width of Auto Size column in PHPExcel

PHPphpexcel

$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true);

$Acolumnsize = $objPHPExcel->getActiveSheet()->getColumnDimension("A")->getWidth();

echo "<h1>" . $Acolumnsize . "</h1>";

I want to set a column to auto size itself. In this case it's column A.

Once it has been auto sized I want to be able to use the value when determining the width of a different column so I need to know how much space column A takes up.

Any time I used the above code the width of column A is -1 meaning the column width hasn't been set. So it seems the auto sizing isn't setting the width of the column for some reason.

I'm wondering how do I get the width of the auto sized column?

Best Answer

The Worksheet classes have a calculateColumnWidths method. This can be use to force the calculation of auto-sized columns, which is usually to delayed until it is necessary. So try:

$objPHPExcel->getActiveSheet()->calculateColumnWidths();

before reading the column widths.

Related Solutions

Php – How to get PHP errors to display

This always works for me:

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

However, this doesn't make PHP to show parse errors - the only way to show those errors is to modify your php.ini with this line:

display_errors = on

(if you don't have access to php.ini, then putting this line in .htaccess might work too):

php_flag display_errors 1

Php – Get the first element of an array

Original answer, but costly (O(n)):

array_shift(array_values($array));

In O(1):

array_pop(array_reverse($array));

Other use cases, etc...

If modifying (in the sense of resetting array pointers) of $array is not a problem, you might use:

reset($array);

This should be theoretically more efficient, if a array "copy" is needed:

array_shift(array_slice($array, 0, 1));

With PHP 5.4+ (but might cause an index error if empty):

array_values($array)[0];

Best Answer

Related Solutions

Php – How to get PHP errors to display

Php – Get the first element of an array

Related Topic