search

athin / php-excel-reader

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

PHP-Excel-Reader only reading first 16384 rows of my spreadsheet #43

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Upload this .xls file.
2.Use the Dump method to display it.
3.

What is the expected output? What do you see instead?
I expect to see the entire spreadsheet but I only see the first 16384 rows

Please provide any additional information below.
Here is the relevant code from my program
   $data = new Spreadsheet_Excel_Reader($import_file, false, 'CP1251');
   echo $data->dump(true);

Original issue reported on code.google.com by patha...@twc.com on 30 Aug 2009 at 3:32

Attachments:

GoogleCodeExporter commented 9 years ago 
Have you got solution for this? Am also looking for the same

Original comment by vijayara...@gmail.com on 22 Feb 2010 at 11:36

GoogleCodeExporter commented 9 years ago 
I never did find a solution.  I just had to instruct my users to split their
spreadsheets into smaller pieces.
I have recently decided to upgrade to PHPExcel 
(http://www.codeplex.com/PHPExcel)
which will read and write various excel versions.  It is much newer and seems 
to have
wider support.  
In testing this using PHPExcel, I have the same problem if my input file was 
saved as
an Excel 5 file.  If I save the file as Excel 2003 or newer, it reads all of 
the rows.

Original comment by patha...@twc.com on 22 Feb 2010 at 2:51

GoogleCodeExporter commented 9 years ago 
Hi thanks for your reply..If i found solution let you know.

Original comment by vijayara...@gmail.com on 23 Feb 2010 at 2:17

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

im using this php reader to retrieving data from xls sheet and its works well 
the xls sheet having 150 records. its limited to 20 records per page to show on 
result page .there is a search box and button to search some specific data , 
the search parameter giving the result from first page result only. i can't get 
result from full excel sheet.

What is the expected output? What do you see instead?

i need the reader to search whole xls sheet and give me result, but this one 
giving me from first 20 records only.  

Please provide any additional information below.
i dont understan whats wrong here, y can't search full records on xls sheet. im 
expecting some ones help to solve my problem. plz see the attach file below for 
code
thnxx..

Original comment by tamiln...@gmail.com on 1 Aug 2011 at 3:51

Attachments: