PHPExcel Reader Example #15
Simple File Reader for Tab-Separated Value File using the Advanced Value Binder
Loading file example1.tsv into WorkSheet #1 using IOFactory with a defined reader type of CSV
Deprecated: Optional parameter $pCoordinate declared before required parameter $pValue is implicitly treated as a required parameter in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php on line 1477
Deprecated: auto_detect_line_endings is deprecated in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/CSV.php on line 249
Deprecated: Return type of PHPExcel_WorksheetIterator::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 76
Deprecated: Return type of PHPExcel_WorksheetIterator::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 94
Deprecated: Return type of PHPExcel_WorksheetIterator::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 86
Deprecated: Return type of PHPExcel_WorksheetIterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 104
Deprecated: Return type of PHPExcel_WorksheetIterator::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 66
1 worksheet loaded
Worksheet #0 -> example1.tsv (Formatted)
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
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.83333333333212067373096942901611328125)
["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.01041666666787932626903057098388671875)
["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.320000000000000006661338147750939242541790008544921875)
}
[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.83333333333333337034076748750521801412105560302734375)
["G"]=>
float(18591.83333333333212067373096942901611328125)
["H"]=>
bool(false)
["I"]=>
float(0.9499999999999999555910790149937383830547332763671875)
}
[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.01041666666666666608842550800773096852935850620269775390625)
["G"]=>
float(30292.01041666666787932626903057098388671875)
["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.320000000000000006661338147750939242541790008544921875)
}
[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.83333333333333337034076748750521801412105560302734375)
["G"]=>
string(6) "=E3+F3"
["H"]=>
bool(false)
["I"]=>
float(0.9499999999999999555910790149937383830547332763671875)
}
[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.01041666666666666608842550800773096852935850620269775390625)
["G"]=>
string(6) "=E4+F4"
["H"]=>
bool(false)
["I"]=>
float(1)
}
}