Excel scientific data

Topics: Developer Forum, Project Management Forum, User Forum
Jul 22, 2011 at 3:57 AM

These is a field within an excel spreadsheet (.xls and .csv format). This field includes some types of data: text, number, general and some others.

To those long number like 1010011985056, it is showed as scientific data like 1.01001E+12. If I use phpexcel to read such a data, the result is not 1010011985056, but 1.01001E+12.

How can I get the original data like 1010011985056?

Since there a number of excel spreadsheets, and many scientific data mixed in the field, I cannot open every sheet to adjust data format. My purpose is to read this data, and import into database.