Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. $excelDateValue = PhpOfficePhpSpreadsheetSharedDate::PHPToExcel('0'.$data[$i][0][2].':00' );
  2.  
  3. $sheet->getStyle('H'.strval($j+2))
  4. ->getNumberFormat()
  5. ->setFormatCode(PhpOfficePhpSpreadsheetStyleNumberFormat::FORMAT_DATE_DATETIME);
  6.  
  7. $sheet->setCellValue('H'.strval($j+2), $excelDateValue);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement