How to set the currency format in phpexcel?07.12.13

function currencyFormat($currency) { if($currency == 'THB'): $currencyFormat = "#,#0.## \฿;[Red]-#,#0.## \฿"; else: $currencyFormat = "#,#0.## \$;[Red]-#,#0.## \$"; endif; return $currencyFormat; } $currencyFormat = $this->pdfhelper->currencyFormat($currency); $sheet->setCellValueByColumnAndRow(8, $r,$price1); $sheet->getStyleByColumnAndRow(8,$r)->getNumberFormat()->setFormatCode($currencyFormat); 07.12.13

http://www.blrf.net/blog/46/code/php/writing-excel-files-with-phpexcel/

#\ ##0.00 € 07.12.13

http://phpexcel.codeplex.com/workitem/16505

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024