Insert date

Function Prototype

insertDate(int $row, int $column, int $timestamp[, string $dateFormat = 'yyyy-mm-dd hh:mm:ss', resource $formatHandler])

int $row

cell row

int $column

cell column

int $timestamp

Timestamp to write

string $dataFormat

time formatting characters

Default: yyyy-mm-dd hh:mm:ss

resource $formatHandler

cell style

example

$excel = new \Vtiful\Kernel\Excel($config);
$dateFile = $excel->fileName("free.xlsx")
->header(['date']);
$dateFile->insertDate(1, 0, time(), 'mmm d yyyy hh:mm AM/PM');
$textFile->output();

Time Format Character Example

For more styles, please refer to the Excel Microsoft documentation.

"mm/dd/yy"
"mmm d yyyy"
"d mmmm yyyy"
"dd/mm/yyyy hh:mm AM/PM"