/PHP/CodeIgniter/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 vote229 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
1 vote200 views1 answer
Codeigniter distinct
PHP CodeIgniter
-1 vote231 views3 answers
Codeigniter pagination example
PHP CodeIgniter
0 vote216 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
0 vote200 views1 answer
Codeigniter check view file exists
PHP CodeIgniter
3 votes206 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
0 vote221 views1 answer
Codeigniter form open
PHP CodeIgniter
0 vote199 views1 answer
Codeigniter get parameter from url
PHP CodeIgniter
0 vote221 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
0 vote209 views1 answer
Php artisan spark not working in codeigniter
PHP CodeIgniter