search

HemantSuman / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Worksheets not retrieved #107

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Read attached XLS file (which was saved as MS Excel 97/2000/XP (.xls) by 
OpenOffice 3.3.0) with this php-excel-reader
2.Use something like this:
$data = new 
Spreadsheet_Excel_Reader('backup_categories_products-autovisu-20110125-3.xls',fa
lse,"UTF-8");
var_dump( $data );
3.

What is the expected output? What do you see instead?
It should have found 5 worksheets and store them in $data->sheets as an array. 
Instead, $data->sheets contains an empty array.

Please provide any additional information below.
The spreadsheet file can be read just fine both MS Office 2010 and OpenOffice 
3.3.0. So I assume this is a valid XLS file, and there is a bug in 
php-excel-reader.

Original issue reported on code.google.com by juergenn...@gmail.com on 25 Jan 2011 at 6:55

Attachments:

GoogleCodeExporter commented 9 years ago 
Observed the same issue on a 2003 workbook. Saving the workbook out to Excel95 
format allowed it to be read in correctly, but obviously a lot of formatting 
code gets stripped out.
Perhaps some hidden formatting codes are not being trapped correctly?

Original comment by denye...@gmail.com on 18 Feb 2011 at 5:26