Facebook
From Little Wigeon, 3 Years ago, written in PHP.
Embed
Download Paste or View Raw
Hits: 65
  1. //$sheet->setCellValue($currentLetter . $row, $temporary_start->format('G:i:00'));
  2. //$sheet->setCellValue($currentLetter . $row, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($temporary_start->getTimestamp()));
  3.  
  4. $sheet->getStyle($currentLetter . $row)
  5.       ->getNumberFormat()
  6.       ->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4);
  7.     //->setFormatCode('gg:mm');