search

pateltejasmca / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Incorrect value when retrieve number from downloaded SSRS Excel #175

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
I download xls file from SSRS.
I use this simple code below to read the file :

$data = new Spreadsheet_Excel_Reader($file);
$data->val($row,$col);

the column value is 1,040,809,656.00
output from code above is 
[$-1,040,809,6561,040,809,6561,040,809,6561,040,809,6561,040,809,6561,040,809,65
61,040,809,656]1,040,809,6561,040,809,6561,040,809,6561,040,809,656.1,040,809,65
61,040,809,656

What is the expected output? What do you see instead?
the expected value is 1,040,809,656.00 (same value of excels)

Please provide any additional information below.
is there any possibility of encode setup?
because if i open and resave in Excel97/2000/XP type, the value will be 
retrieved as excel value (ex : 1,040,809,656.00)

Original issue reported on code.google.com by danang.w...@gmail.com on 10 Jun 2013 at 3:54