http://www.perlmonks.org?node_id=628890


in reply to Setting Excel cell formats

Hi merrymonk, you can customize the cell as below:

$sheet->Cells($st, 1)->{NumberFormat} = "mm:ss"; $sheet->Cells($st, 1)->{Value} = "15:59:12";

Regards,
Velusamy R.


eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';