PhpSpreadsheet Reader Example #09
Simple File Reader Using a Read Filter
Loading file example1.xls using IOFactory with a defined reader type of Xls
Loading Sheet "Data Sheet #3" only
Loading Sheet using filter
array(23) {
[1]=>
array(5) {
["A"]=>
string(31) "NATO Phonetic Alphabet (Modern)"
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[2]=>
array(5) {
["A"]=>
string(5) "Alpha"
["B"]=>
string(5) "Bravo"
["C"]=>
string(7) "Charlie"
["D"]=>
string(5) "Delta"
["E"]=>
string(4) "Echo"
}
[3]=>
array(5) {
["A"]=>
string(7) "Foxtrot"
["B"]=>
string(4) "Golf"
["C"]=>
string(5) "Hotel"
["D"]=>
string(5) "India"
["E"]=>
string(6) "Juliet"
}
[4]=>
array(5) {
["A"]=>
string(4) "Kilo"
["B"]=>
string(4) "Lima"
["C"]=>
string(4) "Mike"
["D"]=>
string(8) "November"
["E"]=>
string(5) "Oscar"
}
[5]=>
array(5) {
["A"]=>
string(4) "Papa"
["B"]=>
string(6) "Quebec"
["C"]=>
string(5) "Romeo"
["D"]=>
string(6) "Sierra"
["E"]=>
string(5) "Tango"
}
[6]=>
array(5) {
["A"]=>
string(7) "Uniform"
["B"]=>
string(6) "Victor"
["C"]=>
string(7) "Whiskey"
["D"]=>
string(5) "X-Ray"
["E"]=>
string(6) "Yankee"
}
[7]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
string(4) "Zulu"
["D"]=>
NULL
["E"]=>
NULL
}
[8]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[9]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[10]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[11]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[12]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[13]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[14]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[15]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[16]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[17]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[18]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[19]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[20]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[21]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[22]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
[23]=>
array(5) {
["A"]=>
NULL
["B"]=>
NULL
["C"]=>
NULL
["D"]=>
NULL
["E"]=>
NULL
}
}