Witam
Walczę już cały dzień aby w wygenerowanym pliku otrzymać liczby w formacie 5.00 a nie 5,00 (zamiast przecinka mieć kropkę).

[PHP] pobierz, plaintext 
<?php
require_once '../../../../class/PHPExcel.php';
 
$objPHPExcel = new PHPExcel;
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objSheet = $objPHPExcel->getActiveSheet();
$objSheet->setTitle('Raport');
$objSheet->getStyle('A1:F1')->getFont()->setSize(12)->getColor()->setRGB('FFFFFF');
 
$objSheet->getCell('A1')->setValue('Lp');
$objSheet->getCell('B1')->setValue('Numer');
$objSheet->getCell('C1')->setValue('Data');
$objSheet->getCell('D1')->setValue('Kwota');
$objSheet->getCell('E1')->setValue('Stan');
$objSheet->getCell('F1')->setValue('Email');
$objSheet->getStyle('A1:F1')->applyFromArray(array('fill' => array(
                'type' => PHPExcel_Style_Fill::FILL_SOLID,
                'color' => array('rgb' => 'ff0000'))));
 
 
$connection = @mysql_connect('******', '*******', *******') or die('Brak połączenia z serwerem MySQL.<br />Błąd: '.mysql_error());
mysql_query("SET NAMES 'cp1250'");
$db = @mysql_select_db('******', $connection) or die('Nie mogę połączyć się z bazą danych<br />Błąd: '.mysql_error());
$db = mysql_query("SELECT * FROM `portal_collect_list` WHERE 
                  `collect_list_date` >= '".$_GET['dateFor']."' AND
              	  `collect_list_date` <= '".$_GET['dateFrom']."' 
				   ORDER BY `collect_list_date` DESC;");
 
$ID = 2;
$ID_row = 1;
while($row = mysql_fetch_array($db)){
	 $objSheet->getStyle('E'.$ID)->getFont()->setSize(12)->getColor()->setRGB('319a69');
	 $objSheet->getStyle('D'.$ID)->getNumberFormat()->setFormatCode('0.00');
	 $objSheet->getCell('A'.$ID)->setValue($ID_row);
     $objSheet->getCell('B'.$ID)->setValue('73871-'.$row['collect_list_bank_code'].$row['collect_list_bank_num']);
     $objSheet->getCell('C'.$ID)->setValue($row['collect_list_date']);
     $objSheet->getCell('D'.$ID)->setValue($row['collect_list_price']);
     $objSheet->getCell('E'.$ID)->setValue('wykonana');
     $objSheet->getCell('F'.$ID)->setValue($row['collect_list_email']);
     $ID++;
     $ID_row++;
}
 
 
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;');
header('Content-Disposition: attachment;filename=plik.xls');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
 
mysql_close($connection); 
?>
[PHP] pobierz, plaintext 

$objSheet->getCell('D1')->getStyle("A1")->getNumberFormat()->setFormatCode('0.00');

Dzieki, ale dalej mam przecinek zamiast kropki.