Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PHP

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #datetime #excel #cell #codeigniter
ADD COMMENT
Topic
Name
6+2 =