PHPExcel -Datumsformat ⇐ Php

[Anonymous]

wie man das Datumsformat in Open Excel < /p>
eingibt

Code: Select all

foreach($detail->result() as $data) {
$sheet->setCellValueExplicitByColumnAndRow($kol+1, $bar, $data->t_spk_id, PHPExcel_Cell_DataType::TYPE_STRING);
$sheet->setCellValueExplicitByColumnAndRow($kol+2, $bar, date('Y/m/d H:i:s',strtotime($data->t_spk_respontime)), PHPExcel_Cell_DataType::TYPE_STRING);

$bar++;
}