15 Simple file reader for tab separated value file using the Advanced Value Binder

01:26:50 Loading file example1.tsv into WorkSheet #1 using IOFactory with a defined reader type of Csv

Deprecated: auto_detect_line_endings is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Csv.php on line 346

Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 55

Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 73

Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 65

Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 83

Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 45
01:26:50 1 worksheet loaded
01:26:50 Worksheet #0 -> example1.tsv (Formatted)

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 479

Deprecated: Use of "self" in callables is deprecated in /home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 505
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.833333333332) ["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.010416666668) ["H"]=> bool(false) ["I"]=> string(7) "100.00%" } } 01:26:50 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.8333333333333334) ["G"]=> float(18591.833333333332) ["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.010416666666666666) ["G"]=> float(30292.010416666668) ["H"]=> bool(false) ["I"]=> float(1) } } 01:26:50 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.8333333333333334) ["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.010416666666666666) ["G"]=> string(6) "=E4+F4" ["H"]=> bool(false) ["I"]=> float(1) } }