PhpSpreadsheet Reader Example #05

Simple File Reader using the "Read Data Only" Option

Loading file example1.xls using IOFactory with a defined reader type of Xls
Turning Formatting off for Load

Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3288
array(8) { [1]=> array(6) { ["A"]=> string(15) "Integer Numbers" ["B"]=> float(123) ["C"]=> float(234) ["D"]=> float(-345) ["E"]=> float(456) ["F"]=> NULL } [2]=> array(6) { ["A"]=> string(22) "Floating Point Numbers" ["B"]=> float(1.23) ["C"]=> float(23.45) ["D"]=> float(3.45E-6) ["E"]=> float(-45.678) ["F"]=> float(56.78) } [3]=> array(6) { ["A"]=> string(7) "Strings" ["B"]=> string(5) "Hello" ["C"]=> string(5) "World" ["D"]=> NULL ["E"]=> string(8) "PHPExcel" ["F"]=> NULL } [4]=> array(6) { ["A"]=> string(8) "Booleans" ["B"]=> bool(true) ["C"]=> bool(false) ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [5]=> array(6) { ["A"]=> string(5) "Dates" ["B"]=> float(22269) ["C"]=> float(40461) ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [6]=> array(6) { ["A"]=> string(5) "Times" ["B"]=> float(0.3958333333333333) ["C"]=> float(0.9993055555555556) ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [7]=> array(6) { ["A"]=> string(8) "Formulae" ["B"]=> float(468) ["C"]=> float(-20.997996549999996) ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [8]=> array(6) { ["A"]=> string(6) "Errors" ["B"]=> string(4) "#N/A" ["C"]=> string(7) "#DIV/0!" ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } }