1

I have an Excel file with .xlsx extension containing record of about 150000 (17 MB).

Excel file is having (name, place, pincode) columns. I want to search file with pincode and retrieve a that specific row which matches my pincode.

I have tried different PHPExcel reader but as I have search 150000 records the entire script hangs with no results.

It works with small files. Is there any solution to make the search and retrieval of records faster.

Peyman Mohamadpour
  • 17,954
  • 24
  • 89
  • 100
vivek321
  • 169
  • 3
  • 18

1 Answers1

0

Did you take a look at:

Reading large worksheets with PHPExcel...

They also link to a potentially faster reader (I have not tested this):

Faster XLSX Reader

Community
  • 1
  • 1
Chad Fisher
  • 353
  • 4
  • 16