PHP skip undefined offset in foreach loop?

Question

I'm trying to scan hundreds of folders each containing an excel file.

Here's the simplified workflow

scan folders in loop
get first folder name and run it trough some regex (to get some info from the name)
open the folder and open the excel file inside
scan excel file for info's (with PHPExcel)
save everything to Database

Ok so all this is working just fine, except when i run into an excel file which is corrupted.

The problem then is that the PHPEXCEL library cant read it and it throughs back a "Notice: Undefined offset:" and this breaks my foreach loop.

So here is what I'm looking for: a way to somehow skip or something the erros and notices and continue with the next folder and file.

Is there a way? Thank's for any help.

Ok so here is the foreach loop:

foreach ($inputFileName as $key => $fileName) {
$objReader = PHPExcel_IOFactory::load($fileName);

$activeSheet = $objReader->getActiveSheet()->toArray(null,false,true,false);

echo "<pre>";
    echo $key;
echo "</pre>";
}

If these are just notices, just lower the error reporting setting. — Barmar
– Barmar, Commented Oct 10, 2013 at 8:25
@cbuckley fallowing your idea i went to the phpexcel library and solved the problem there. So thank you. — Mr. Sam
– Mr. Sam, Commented Oct 10, 2013 at 9:15

Barmar · Accepted Answer · 2013-10-10 08:40:56Z

1

Just a guess:

foreach ($inputFileName as $key => $fileName) {
    $objReader = PHPExcel_IOFactory::load($fileName);

    if ($objReader) {
        $activeSheet = $objReader->getActiveSheet()->toArray(null,false,true,false);

        echo "<pre>";
            echo $key;
        echo "</pre>";
    }
}

It's pretty common for functions to return false when they fail.

answered Oct 10, 2013 at 8:40

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

Mr. Sam Over a year ago

unfortunately that didn't work, but it kind of gave me a direction, i didn't wanted to do this but now i think my only solution is to hack the PHPEXCEL library, to give some result if it cant open an excel

Alexandre Nucera · Accepted Answer · 2013-10-10 08:29:44Z

0

Maybe you can use the function error_reporting at the beginning of your script to skip notices :

error_reporting(E_ERROR | E_WARNING | E_PARSE);

And set it back to your original value once you are done with your treatment :

error_reporting(-1); //Report all errors

You can find more info here : http://php.net/manual/fr/function.error-reporting.php

answered Oct 10, 2013 at 8:29

Alexandre Nucera

2,2232 gold badges22 silver badges34 bronze badges

2 Comments

Mr. Sam Over a year ago

like i told @Barmar i tried that but the loop still stops, without notice

Yang Over a year ago

@Mr.Sam just do error_reporing(0) at the top of the script, then

Collectives™ on Stack Overflow

PHP skip undefined offset in foreach loop?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related