/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 vote152 views1 answer
Get min value from array php
PHP
1 vote186 views1 answer
Get user with role laravel
PHP Laravel
5 votes157 views1 answer
Redirect 301 wordpress
PHP
3 votes151 views2 answers
Custom 404 page in laravel
PHP
1 vote177 views1 answer
Deactivate woocommerce breadcrumbs
PHP
0 vote191 views1 answer
Custom timestamp column laravel
PHP Laravel
15 votes189 views3 answers
Laravel timezone
PHP Laravel
11 votes158 views4 answers
Php str starts with
PHP
2 votes196 views1 answer
Laravel crud generator
PHP Laravel
-1 vote127 views2 answers
Laravel pagination keep query string
PHP