/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

6 votes150 views5 answers
Migration rename column laravel
PHP Laravel
6 votes164 views2 answers
How to set tinyint default 0 laravel migration
PHP Laravel
18 votes106 views3 answers
Laravel blade for loop
PHP
0 vote150 views1 answer
Laravel where and blade
PHP Laravel
-1 vote141 views1 answer
Turn error log WP
PHP Wordpress
0 vote176 views1 answer
Delete_user hook in wordpress
PHP Wordpress
5 votes125 views6 answers
Php remove duplicates from multidimensional array
PHP
0 vote137 views1 answer
Php compare two arrays of objects
PHP
7 votes160 views6 answers
Laravel get url path
PHP Laravel
2 votes126 views1 answer
Php switch case multiple values per line
PHP