php表格如何设置时间格式,php - PHPExcel设置日期格式，而无需写入每个值 - 堆栈内存溢出...

我把$objPHPExcel->getActiveSheet()->fromArray放在列中设置日期时间，如下所示：

while ($row = mysql_fetch_assoc($result)) {

$objPHPExcel->getActiveSheet()->fromArray($row, null, "A".$red);

// Again set row values

$dateValuerr = PHPExcel_Shared_Date::PHPToExcel(strtotime($row[NasDatumPrijemaPredmeti]));

$objPHPExcel->getActiveSheet()->setCellValue("D".$red."", $dateValuerr);

$dateValuerr = PHPExcel_Shared_Date::PHPToExcel(strtotime($row[NjihovDatumPrijemaPredmeti]));

$objPHPExcel->getActiveSheet()->setCellValue("E".$red."", $dateValuerr);

$objPHPExcel->getActiveSheet()->getStyle("A".$red.":AF".$red)->applyFromArray($table_style);

$objPHPExcel->getActiveSheet()->getStyle("A".$red.":AF".$red)->getFont()->setBold(true);

$red++;

};

然后设置列

$objPHPExcel->getActiveSheet()->getStyle('D2:E1000')->getNumberFormat()->setFormatCode(exportdatum);

My date is : define('exportdatum', 'dd.mm.yyyy'); // Date

这是我的MySQL数据库中的日期

MySql Date : 2015-05-01

But I convert in query to

DATE_FORMAT(predmeti.NasDatumPrijemaPredmeti, '%d.%m.%Y') AS NasDatumPrijemaPredmeti