jasonrogena / jasonrogena/php-excel-reader

Error in retrieve the rows number on a sheet

Open
#70 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

```
What steps will reproduce the problem?
1.open a xls file with 3 sheets inside
2.force the dump to the third sheet (2)
3.call echo $data->dump(true,true,2);

at the same removing the other 2 sheets and keep only the third the result not
change

What is the expected output? What do you see instead?
the output that i want is the excel sheet but i only give back the 1° row with
the column name by
the software (A|B|C ecc) and the colum numebers is right... but the rows number
is alway zero...

Please provide any additional information below.

i have try to find the issue and i have found that the error is generated in
this php code:

function _parsesheet($spos)

at the case:

case SPREADSHEET_EXCEL_READER_TYPE_DIMENSION:

where this assignment
$this->sheets[$this->sn]['numRows']
at the third sheet is always 0

in attach the file .xls, the screen shot of the result and the script
```

Original issue reported on code.google.com by `matteofa...@gmail.com` on 1 Apr 2010 at 1:56

Attachments:
- [Schermata 2010-04-01 a 15.54.05.png](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-70/comment-0/Schermata 2010-04-01 a 15.54.05.png)
- [w.xls](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-70/comment-0/w.xls)
- [example.php](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-70/comment-0/example.php)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start in the _parsesheet($spos) function at the SPREADSHEET_EXCEL_READER_TYPE_DIMENSION case, where sheets[$sn]['numRows'] is reported as zero for the third sheet. Reproduce the issue with w.xls and example.php, comparing the three-sheet file with the version containing only the third sheet; done means the returned row count and dumped sheet data are correct.

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
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.