jasonrogena / jasonrogena/php-excel-reader

Dump xls returns nothing (php-excel-reader 2.22)

Open
#184 0 comments 0 reactions 0 assignees View on GitHub

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.