Skip to content
This repository has been archived by the owner on Jan 2, 2019. It is now read-only.

read csv with long number data get scientific notation #1432

Open
dpbuzz opened this issue Dec 17, 2018 · 0 comments
Open

read csv with long number data get scientific notation #1432

dpbuzz opened this issue Dec 17, 2018 · 0 comments

Comments

@dpbuzz
Copy link

dpbuzz commented 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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant