jasonrogena / jasonrogena/php-excel-reader
Dump xls returns nothing (php-excel-reader 2.22)
Open
Nobody has claimed this yet.
auto-migrated
Priority-Medium
Type-Defect
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Hi everyone,
I am using excel_reader2.php (v2.22) to read an xls which has many sheets and
contains Chinese characters
Here are the steps to produce this issue
1. source code:
$data = new Spreadsheet_Excel_Reader("01.02_ori.xls");
$data->setOutputEncoding('CP1251');
echo $data->dump(true,true, 0);
2. The dump on the browser only return like one cell table and the count amount
is 0.
Attached is the xls file and the screenshot. It seems either the sheets issue
as I can handle the Chinese character inside the file, but I think it may be
the cause that the dump process is failed now. Does the original excel file has
a different file encoding?
I hope anyone can help me and perhaps the solution can help others who are
experiencing the same issue.
cheers, thanks.
Original issue reported on code.google.com by mail.isu...@gmail.com on 8 Feb 2014 at 10:43
Attachments:
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the reported call in excel_reader2.php with the attached 01.02_ori.xls file, including setOutputEncoding('CP1251') and dump(true,true,0). Trace the dump path and sheet or encoding handling to identify why the result has zero cells. Done means the attached workbook produces a populated dump rather than an empty or one-cell table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100