jasonrogena / jasonrogena/php-excel-reader
While reading xls column leading zeros stipped off
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
Hi,
In my excel file i have a column leading '0', while reading from
php-excel-reader zeros will stripped off.
Is anyone earlier overcome this issue?
My Code is
--------------------------------------------------
require_once 'excel_reader2.php';
$data = new Spreadsheet_Excel_Reader("stock.xls",false);
$data = $data->sheets[0][cells];
print_r($data);
--------------------------------------------------
output is
---------------------------------------------------
Array
(
[1] => Array
(
[1] => Style #
[2] => Weight
[3] => Available Stock
[4] => Inspection
[5] => On Order Quantity
[6] => Estimated Arrival Date
)
[2] => Array
(
[1] => 54025
[2] => 99
[3] => -10
[4] => 0
[5] => 0
[6] => 0
)
[3] => Array
(
[1] => 313070
[2] => 58
[3] => -1
[4] => 0
[5] => 0
[6] => 0
)
--------------------------------------------------------------
```
Original issue reported on code.google.com by `stephenp...@gmail.com` on 6 Jun 2013 at 1:31
Attachments:
- [stock.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-174/comment-0/stock.xls)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with excel_reader2.php and the Spreadsheet_Excel_Reader path used by the reported code, then inspect how cells from stock.xls are converted into sheets[0][cells]. Use the attached stock.xls to reproduce the leading-zero loss and compare the parsed values with the source spreadsheet; done means the expected values are preserved or the limitation is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100