PHPExcel Reader Example #09
Simple File Reader Using a Read Filter
Loading file example1.xls using IOFactory with a defined reader type of Excel5
Loading Sheet "Data Sheet #3" only
Loading Sheet using filter
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader09.php:66:
array (size=23)
1 =>
array (size=5)
'A' => string 'NATO Phonetic Alphabet (Modern)' (length=31)
'B' => null
'C' => null
'D' => null
'E' => null
2 =>
array (size=5)
'A' => string 'Alpha' (length=5)
'B' => string 'Bravo' (length=5)
'C' => string 'Charlie' (length=7)
'D' => string 'Delta' (length=5)
'E' => string 'Echo' (length=4)
3 =>
array (size=5)
'A' => string 'Foxtrot' (length=7)
'B' => string 'Golf' (length=4)
'C' => string 'Hotel' (length=5)
'D' => string 'India' (length=5)
'E' => string 'Juliet' (length=6)
4 =>
array (size=5)
'A' => string 'Kilo' (length=4)
'B' => string 'Lima' (length=4)
'C' => string 'Mike' (length=4)
'D' => string 'November' (length=8)
'E' => string 'Oscar' (length=5)
5 =>
array (size=5)
'A' => string 'Papa' (length=4)
'B' => string 'Quebec' (length=6)
'C' => string 'Romeo' (length=5)
'D' => string 'Sierra' (length=6)
'E' => string 'Tango' (length=5)
6 =>
array (size=5)
'A' => string 'Uniform' (length=7)
'B' => string 'Victor' (length=6)
'C' => string 'Whiskey' (length=7)
'D' => string 'X-Ray' (length=5)
'E' => string 'Yankee' (length=6)
7 =>
array (size=5)
'A' => null
'B' => null
'C' => string 'Zulu' (length=4)
'D' => null
'E' => null
8 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
9 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
10 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
11 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
12 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
13 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
14 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
15 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
16 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
17 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
18 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
19 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
20 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
21 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
22 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null
23 =>
array (size=5)
'A' => null
'B' => null
'C' => null
'D' => null
'E' => null