PHPExcel Reader Example #03
Simple File Reader using the PHPExcel_IOFactory to Return a Reader
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 526
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 527
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 538
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 539
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 541
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 542
Loading file example1.xls using IOFactory with a defined reader type of Excel5
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 1928
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 1991
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2128
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2153
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2163
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2181
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2194
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2198
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2278
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2402
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2402
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2402
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2417
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2417
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2417
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2432
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2432
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2432
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2447
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2447
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2447
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2462
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2462
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2462
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2477
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2477
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2477
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2492
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2492
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2492
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2507
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2507
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2507
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2549
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2614
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2630
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2808
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2891
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2958
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 2980
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3886
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3909
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3909
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3909
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3921
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3922
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3923
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3926
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3927
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3928
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3929
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3932
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3933
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3934
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3935
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 3999
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 4065
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 4068
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 4450
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 4601
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 4603
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 6889
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 6892
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 7297
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 7300
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Reader/Excel5.php on line 7303
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2551
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2551
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2672
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2672
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2676
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2764
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2768
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2780
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3034
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3166
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3168
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3169
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3457
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3457
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3460
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3461
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3891
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3891
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3936
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3942
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3998
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 4001
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/OLE.php on line 288
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/OLE.php on line 446
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 812
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 813
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 816
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 817
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 817
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 819
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 824
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 321
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 324
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 562
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 612
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3370
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
}
}