I got an enhancement task from client that they want to specific the width of each cell of the Excel file (Ms. Excel) in cm (e.g. column "Name" = 5cm).
I've tried to search for the solutions and got some suggestions like :
$excel->getActiveSheet()->getColumnDimension('A')->setAutoSize(false);
$excel->exa_setColumnWidth('A', [some_value]);
But sadly, [some_value] here is not in cm. And until now, I still have no idea what is that measure.
I also found this link Setting Column Width with PHPExcel Not Working but it is told that it is impossible to do that. But somehow I want to try to ask, in case recently someone has any idea about how to achieve that.