/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 vote206 views1 answer
Laravel check if model relation exists
PHP Laravel
14 votes254 views6 answers
Get featured image url in wordpress
PHP Wordpress
5 votes187 views5 answers
Install laravel 8 with composer
PHP Laravel
0 vote153 views1 answer
Php convert file_get_content to string
PHP
2 votes177 views1 answer
Php array order by date
PHP
0 vote181 views1 answer
Php class extends exception
PHP
6 votes215 views3 answers
Laravel ecommerce
PHP Laravel
0 vote204 views2 answers
Laravel bootstrap nav active
PHP Laravel
2 votes179 views3 answers
How to change the colum type in migration laravel
PHP
4 votes145 views1 answer
Phpunit repeat
PHP