PHPExcel Reader Example #03
Simple File Reader using the PHPExcel_IOFactory to Return a Reader
Loading file example1.xls using IOFactory with a defined reader type of Excel5
/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader03.php:46:
array (size=8)
1 =>
array (size=6)
'A' => string 'Integer Numbers' (length=15)
'B' => string '123' (length=3)
'C' => string '234' (length=3)
'D' => string '-345' (length=4)
'E' => string '456' (length=3)
'F' => null
2 =>
array (size=6)
'A' => string 'Floating Point Numbers' (length=22)
'B' => string '1.23' (length=4)
'C' => string '23.45' (length=5)
'D' => string '3.45E-6' (length=7)
'E' => string '-45.68' (length=6)
'F' => string '£56.78' (length=7)
3 =>
array (size=6)
'A' => string 'Strings' (length=7)
'B' => string 'Hello' (length=5)
'C' => string 'World' (length=5)
'D' => null
'E' => string 'PHPExcel' (length=8)
'F' => null
4 =>
array (size=6)
'A' => string 'Booleans' (length=8)
'B' => boolean true
'C' => boolean false
'D' => null
'E' => null
'F' => null
5 =>
array (size=6)
'A' => string 'Dates' (length=5)
'B' => string '19 December 1960' (length=16)
'C' => string '10 October 2010' (length=15)
'D' => null
'E' => null
'F' => null
6 =>
array (size=6)
'A' => string 'Times' (length=5)
'B' => string '9:30' (length=4)
'C' => string '23:59' (length=5)
'D' => null
'E' => null
'F' => null
7 =>
array (size=6)
'A' => string 'Formulae' (length=8)
'B' => string '468' (length=3)
'C' => string '-20.998' (length=7)
'D' => null
'E' => null
'F' => null
8 =>
array (size=6)
'A' => string 'Errors' (length=6)
'B' => string '#N/A' (length=4)
'C' => string '#DIV/0!' (length=7)
'D' => null
'E' => null
'F' => null