How to set cell padding in PHPExcel?

Question

Does anyone know how it's possible to set cell padding in PHPExcel ? Searched for 30mins and still can't find a proper solution. There is no useful documentation on this.

Answer 1

Just to add, please note that this will only work if the horizontal alignment is set to left or right.

Should precede with this (if it has not already been done)

$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);

Cheers

Answer 2

Maybe

$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setIndent(1);