自动调整Excel列宽

Question

I'm using Laravel Excel plugin and have a problem with column widths. See the picture below, you can see the mistake:

Here is the correct view:

I tried $sheet->setAutoSize('true'); but it is not working.

How can I auto size column to the maximum content width of any cell in that column?

Answer 1

$sheet->getColumnDimension($column)->setAutoSize(true) ;

Duplicate of PHPExcel auto size column width