php - Modifying whole column Type Code PHPExcel -

i have been doing program format xls, opening, modifying , saving it.

it taking time showing me timeout error change functions execute change of typecode on cells on whole column , not on every cell.

my current sentence is:

$sheet->getstyle($currenticell)->getnumberformat()->setformatcode('0000');

and inside loop while until last row reached.

i wonder if there function setformatcode on column , not cell.

thank in advance.

don't set style every individual cell, that's enormous processing , memory overhead; set style range of cells in single call:

$sheet->getstyle('a1:a255')     ->getnumberformat()     ->setformatcode('0000');

My