PhpSpreadsheet Reader Example #04

Simple File Reader using the \PhpOffice\PhpSpreadsheet\IOFactory to Identify a Reader to Use

File example1.xls has been identified as an Xls file
Loading file example1.xls using IOFactory with the identified reader type


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"]=> string(3) "123" ["C"]=> string(3) "234" ["D"]=> string(4) "-345" ["E"]=> string(3) "456" ["F"]=> NULL } [2]=> array(6) { ["A"]=> string(22) "Floating Point Numbers" ["B"]=> string(4) "1.23" ["C"]=> string(5) "23.45" ["D"]=> string(7) "3.45E-6" ["E"]=> string(6) "-45.68" ["F"]=> string(7) "£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"]=> string(16) "19 December 1960" ["C"]=> string(15) "10 October 2010" ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [6]=> array(6) { ["A"]=> string(5) "Times" ["B"]=> string(4) "9:30" ["C"]=> string(5) "23:59" ["D"]=> NULL ["E"]=> NULL ["F"]=> NULL } [7]=> array(6) { ["A"]=> string(8) "Formulae" ["B"]=> string(3) "468" ["C"]=> string(7) "-20.998" ["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 } }