How to eliminate empty rows in excel upload from PHP using PHPExcel upload?

Question

i am in the middle of the development. i want to eliminate the empty rows while upload a excel from PHP using PHP excel plugin.

while($x<=$excel->sheets[0]['numRows']){
    $y=1;
    while($y<=$excel->sheets[0]['numCols']){
        $cell = isset($excel->sheets[0]['cells'][$x][$y])
            ? $excel->sheets[0]['cells'][$x][$y] 
            : '';
        if($excel->sheets[0]['cells'][$x][$y] == $excel->sheets[0]['cells'][$x][1] ){
            echo $cell;
        } else { 
            echo $cell; 
        }
        $y++;
    } 
    $x++;
}

i used this code to get the values from excel to PHP, but if the excel has empty record the result will be modified something like extra cells. how can i fix this.

Are you really using PHPExcel, or are you using the PEAR Spreadsheet_Excel_Writer (SEW)... it looks more like the latter to me — Mark Baker
– Mark Baker, Commented Apr 9, 2013 at 8:19
Sorry, i used Spreadsheet_Excel_Writer only. how can i eliminate empty rows — Phoenix Bird
– Phoenix Bird, Commented Apr 9, 2013 at 8:38
You need to test if every cell in the row array is empty before your second while loop, and only execute that while loop if there are non-empty cells. I'd suggest using array_filter() to get a count of the non-empty cells — Mark Baker
– Mark Baker, Commented Apr 9, 2013 at 8:46
its says : Parse error: syntax error, unexpected T_FUNCTION in — Phoenix Bird
– Phoenix Bird, Commented Apr 9, 2013 at 10:31
What says that? What version of PHP are you running? My answer requires a minimum of 5.3.0; but you should be running at least that anyway as anything below that is no longer supported — Mark Baker
– Mark Baker, Commented Apr 9, 2013 at 10:34

Mark Baker · Accepted Answer · 2013-04-09 09:04:36Z

1

if (!array_reduce(
    $excel->sheets[0]['cells'][$x],
    function ($state, $value) {
        return $state && !($value > '');
    },
    TRUE
)) {
// execute your while($y<=$excel->sheets[0]['numCols']) loop here
}

answered Apr 9, 2013 at 9:04

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Collectives™ on Stack Overflow

How to eliminate empty rows in excel upload from PHP using PHPExcel upload?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related