PHPExcel Reader Example #15
Simple File Reader for Tab-Separated Value File using the Advanced Value Binder
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
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/Cell/DefaultValueBinder.php on line 82
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90
Loading file example1.tsv into WorkSheet #1 using IOFactory with a defined reader type of CSV
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
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
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/ReferenceHelper.php on line 884
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/ReferenceHelper.php on line 884
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/ReferenceHelper.php on line 885
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/ReferenceHelper.php on line 885
1 worksheet loaded
Worksheet #0 -> example1.tsv (Formatted)
array(4) {
[1]=>
array(9) {
["A"]=>
string(10) "First Name"
["B"]=>
string(9) "Last Name"
["C"]=>
string(11) "Nationality"
["D"]=>
string(6) "Gender"
["E"]=>
string(13) "Date of Birth"
["F"]=>
string(13) "Time of Birth"
["G"]=>
string(9) "Date/Time"
["H"]=>
string(9) "PHP Coder"
["I"]=>
string(11) "Sanity %Age"
}
[2]=>
array(9) {
["A"]=>
string(4) "Mark"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "M"
["E"]=>
string(10) "1960-12-19"
["F"]=>
string(4) "1:30"
["G"]=>
float(22269.0625)
["H"]=>
bool(true)
["I"]=>
string(6) "32.00%"
}
[3]=>
array(9) {
["A"]=>
string(4) "Toni"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
string(10) "1950-11-24"
["F"]=>
string(5) "20:00"
["G"]=>
float(18591.833333333)
["H"]=>
bool(false)
["I"]=>
string(6) "95.00%"
}
[4]=>
array(9) {
["A"]=>
string(6) "Rachel"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
string(10) "1982-12-07"
["F"]=>
string(4) "0:15"
["G"]=>
float(30292.010416667)
["H"]=>
bool(false)
["I"]=>
string(7) "100.00%"
}
}
Worksheet #0 -> example1.tsv (Unformatted)
array(4) {
[1]=>
array(9) {
["A"]=>
string(10) "First Name"
["B"]=>
string(9) "Last Name"
["C"]=>
string(11) "Nationality"
["D"]=>
string(6) "Gender"
["E"]=>
string(13) "Date of Birth"
["F"]=>
string(13) "Time of Birth"
["G"]=>
string(9) "Date/Time"
["H"]=>
string(9) "PHP Coder"
["I"]=>
string(11) "Sanity %Age"
}
[2]=>
array(9) {
["A"]=>
string(4) "Mark"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "M"
["E"]=>
float(22269)
["F"]=>
float(0.0625)
["G"]=>
float(22269.0625)
["H"]=>
bool(true)
["I"]=>
float(0.32)
}
[3]=>
array(9) {
["A"]=>
string(4) "Toni"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
float(18591)
["F"]=>
float(0.83333333333333)
["G"]=>
float(18591.833333333)
["H"]=>
bool(false)
["I"]=>
float(0.95)
}
[4]=>
array(9) {
["A"]=>
string(6) "Rachel"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
float(30292)
["F"]=>
float(0.010416666666667)
["G"]=>
float(30292.010416667)
["H"]=>
bool(false)
["I"]=>
float(1)
}
}
Worksheet #0 -> example1.tsv (Raw)
array(4) {
[1]=>
array(9) {
["A"]=>
string(10) "First Name"
["B"]=>
string(9) "Last Name"
["C"]=>
string(11) "Nationality"
["D"]=>
string(6) "Gender"
["E"]=>
string(13) "Date of Birth"
["F"]=>
string(13) "Time of Birth"
["G"]=>
string(9) "Date/Time"
["H"]=>
string(9) "PHP Coder"
["I"]=>
string(11) "Sanity %Age"
}
[2]=>
array(9) {
["A"]=>
string(4) "Mark"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "M"
["E"]=>
float(22269)
["F"]=>
float(0.0625)
["G"]=>
string(6) "=E2+F2"
["H"]=>
bool(true)
["I"]=>
float(0.32)
}
[3]=>
array(9) {
["A"]=>
string(4) "Toni"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
float(18591)
["F"]=>
float(0.83333333333333)
["G"]=>
string(6) "=E3+F3"
["H"]=>
bool(false)
["I"]=>
float(0.95)
}
[4]=>
array(9) {
["A"]=>
string(6) "Rachel"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
float(30292)
["F"]=>
float(0.010416666666667)
["G"]=>
string(6) "=E4+F4"
["H"]=>
bool(false)
["I"]=>
float(1)
}
}