Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PhpSpreadsheet foreach loop through multiple sheets

I'm new to PhpSpreadsheet, I have a file with multiple sheets (all the same), I checked all the examples in the Reader section of the documentation, but each example ends with a code like

$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

so seems that I can get my data only from the active sheet. I would like to loop through each sheet to get data from each one, something like:

foreach ($sheetData as $sheet) { 
    echo "...my data ...";
}

Any idea? Am I missing something? Thanks

like image 694
uomopalese Avatar asked Aug 24 '18 14:08

uomopalese


1 Answers

You'd want to use the getSheetCount() method to determine how many sheets there are, and then use a standard for loop with getSheet():

$sheetCount = $spreadsheet->getSheetCount();
for ($i = 0; $i < $sheetCount; $i++) {
    $sheet = $spreadsheet->getSheet($i);
    $sheetData = $sheet->toArray(null, true, true, true);
}

See the Worksheet documentation.

like image 55
miken32 Avatar answered Nov 19 '22 06:11

miken32