/PHP/Get datetime of excel cell in codeigniter

Get datetime of excel cell in codeigniter

$field1= $objWorksheet->getCellByColumnAndRow(0,$i)->getFormattedValue(); //Excel Column 3
$date = PHPExcel_Shared_Date::ExcelToPHP($field1); //unix
echo $field1= gmdate("Y-m-d", $date); //date

Source: stackoverflow.com

Similar codes

0 vote245 views2 answers
Where are WordPress Pages and Posts Stored
PHP Wordpress
0 vote259 views1 answer
Non-static method Barryvdh\DomPDF\PDF::loadView() should not be called statically
PHP
0 vote240 views1 answer
Laravel collection shuffle
PHP Laravel
0 vote213 views1 answer
Diferencias empty() e isset()
PHP
0 vote205 views1 answer
Array unpacking support for string-keyed arrays - PHP 8.1
PHP
4 votes208 views2 answers
Laravel eloquent sum column
PHP Laravel
0 vote242 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote222 views7 answers
Laravel eloquent tricks
PHP
22 votes208 views6 answers
Php foreach
PHP
4 votes226 views6 answers
Laravel 8 authentication
PHP Laravel