Search and fetch record from xlsx file in php

Question

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.

score 0 · Answer 1 · edited May 23 '17 at 12:33

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

edited May 23 '17 at 12:33

Community

1
1

answered Feb 14 '17 at 18:26

Chad Fisher

325
3
16

Search and fetch record from xlsx file in php

1 Answers1