PHPExcel Reader Example #05
Simple File Reader using the "Read Data Only" Option
Loading file example1.xls using IOFactory with a defined reader type of Excel5
Turning Formatting off for Load
/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader05.php:46:
array (size=8)
1 =>
array (size=6)
'A' => string 'Integer Numbers' (length=15)
'B' => float 123
'C' => float 234
'D' => float -345
'E' => float 456
'F' => null
2 =>
array (size=6)
'A' => string 'Floating Point Numbers' (length=22)
'B' => float 1.23
'C' => float 23.45
'D' => float 3.45E-6
'E' => float -45.678
'F' => float 56.78
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' => float 22269
'C' => float 40461
'D' => null
'E' => null
'F' => null
6 =>
array (size=6)
'A' => string 'Times' (length=5)
'B' => float 0.39583333333333
'C' => float 0.99930555555556
'D' => null
'E' => null
'F' => null
7 =>
array (size=6)
'A' => string 'Formulae' (length=8)
'B' => float 468
'C' => float -20.99799655
'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