jasonrogena / jasonrogena/php-excel-reader
Error in retrieve the rows number on a sheet
- 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