PHP Excel Reader (excel_reader2.php)

Question

Is it possible to search a certain value inside the spreadsheet using excel_reader2 and get row number so I can get the entire row value using that? Trying to save myself from dumping the data into database, since all I want is to displaying values. And yes I know I can do data->dump, but I need a single row values based on login.

Thanks in advance.

used foreach($data->sheets[0]['cells'] as $row) instead of for($i=0; i<=rowcount($sheet_index=0); i++) to go through all the rows and time improved amazingly! — Karaman
– Karaman, Commented Oct 5, 2015 at 11:05

Michal Kómoch · Accepted Answer · 2015-10-05 10:09:47Z

1

Have you tried this:

$data = new Spreadsheet_Excel_Reader("test.xls",false);
$data->val($row,$col,$sheet_index)                     //$data->val(10,A);

You can go through all rows and cols with foreach loop and find a "column and row" with word using regexp function.

answered Oct 5, 2015 at 10:09

Michal Kómoch

1145 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Karaman Over a year ago

Great. Problem is going with a for loop takes too long. I was wondering if there might be a "find" type of utility. Or a different way that does not take so long.

Karaman Over a year ago

longer than 2 minutes for 800 records!

Michal Kómoch Over a year ago

Try to use flag "false" for large worksheets to not storing the extended information about cells like fonts, colors.

Collectives™ on Stack Overflow

PHP Excel Reader (excel_reader2.php)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related