/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

2 votes180 views1 answer
Merubah judul menjadi slug codeigniter
PHP CodeIgniter
1 vote191 views1 answer
Example code codeigniter seeders
PHP CodeIgniter
8 votes226 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote196 views3 answers
Is_unique in codeigniter form validation
PHP CodeIgniter
3 votes193 views1 answer
Codeigniter check insert
PHP CodeIgniter
8 votes228 views4 answers
Codeigniter redirect
PHP CodeIgniter
0 vote133 views1 answer
How to write orderby in join query with where clause in codeigniter
PHP CodeIgniter
4 votes211 views2 answers
Codeigniter 3 limit
PHP CodeIgniter
0 vote184 views2 answers
How to insert last id from crud grocery codeigniter
PHP CodeIgniter
-1 vote180 views1 answer
Codeigniter get num_rows
PHP CodeIgniter