read csv with long number data get scientific notation
Author: dpbuzzCreated Dec 17, 2018Updated Dec 17, 2018
Hi, I have a CSV with one column to read with this data:
SerialNumber 8954310143063931904 8954310143063931938 8954310143063931920 8954310143063931912 8954310143063931896 8954310143063931516 8954310143063931540
I am doing: $inputFileType='Csv'; $objReader=IOFactory::createReader($inputFileType); $objWorksheet = $objPHPExcel->getActiveSheet(); $cell=$objWorksheet->getCellByColumnAndRow($col,$fila);
And $cell gets cientific notation like 8.9543101430639E+18 instead of 8954310143063931904 How can solve this problem and get de values as strings? Thanks
Source: PHPOffice/PHPExcel