jasonrogena / jasonrogena/php-excel-reader

While reading xls column leading zeros stipped off

Open
#174 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.