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
1 worksheet loaded
Worksheet #0 -> example1.tsv (Formatted)
/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader15.php:45:
array (size=4)
1 =>
array (size=9)
'A' => string 'First Name' (length=10)
'B' => string 'Last Name' (length=9)
'C' => string 'Nationality' (length=11)
'D' => string 'Gender' (length=6)
'E' => string 'Date of Birth' (length=13)
'F' => string 'Time of Birth' (length=13)
'G' => string 'Date/Time' (length=9)
'H' => string 'PHP Coder' (length=9)
'I' => string 'Sanity %Age' (length=11)
2 =>
array (size=9)
'A' => string 'Mark' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'M' (length=1)
'E' => string '1960-12-19' (length=10)
'F' => string '1:30' (length=4)
'G' => float 22269.0625
'H' => boolean true
'I' => string '32.00%' (length=6)
3 =>
array (size=9)
'A' => string 'Toni' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => string '1950-11-24' (length=10)
'F' => string '20:00' (length=5)
'G' => float 18591.833333333
'H' => boolean false
'I' => string '95.00%' (length=6)
4 =>
array (size=9)
'A' => string 'Rachel' (length=6)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => string '1982-12-07' (length=10)
'F' => string '0:15' (length=4)
'G' => float 30292.010416667
'H' => boolean false
'I' => string '100.00%' (length=7)
Worksheet #0 -> example1.tsv (Unformatted)
/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader15.php:55:
array (size=4)
1 =>
array (size=9)
'A' => string 'First Name' (length=10)
'B' => string 'Last Name' (length=9)
'C' => string 'Nationality' (length=11)
'D' => string 'Gender' (length=6)
'E' => string 'Date of Birth' (length=13)
'F' => string 'Time of Birth' (length=13)
'G' => string 'Date/Time' (length=9)
'H' => string 'PHP Coder' (length=9)
'I' => string 'Sanity %Age' (length=11)
2 =>
array (size=9)
'A' => string 'Mark' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'M' (length=1)
'E' => float 22269
'F' => float 0.0625
'G' => float 22269.0625
'H' => boolean true
'I' => float 0.32
3 =>
array (size=9)
'A' => string 'Toni' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => float 18591
'F' => float 0.83333333333333
'G' => float 18591.833333333
'H' => boolean false
'I' => float 0.95
4 =>
array (size=9)
'A' => string 'Rachel' (length=6)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => float 30292
'F' => float 0.010416666666667
'G' => float 30292.010416667
'H' => boolean false
'I' => float 1
Worksheet #0 -> example1.tsv (Raw)
/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader15.php:65:
array (size=4)
1 =>
array (size=9)
'A' => string 'First Name' (length=10)
'B' => string 'Last Name' (length=9)
'C' => string 'Nationality' (length=11)
'D' => string 'Gender' (length=6)
'E' => string 'Date of Birth' (length=13)
'F' => string 'Time of Birth' (length=13)
'G' => string 'Date/Time' (length=9)
'H' => string 'PHP Coder' (length=9)
'I' => string 'Sanity %Age' (length=11)
2 =>
array (size=9)
'A' => string 'Mark' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'M' (length=1)
'E' => float 22269
'F' => float 0.0625
'G' => string '=E2+F2' (length=6)
'H' => boolean true
'I' => float 0.32
3 =>
array (size=9)
'A' => string 'Toni' (length=4)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => float 18591
'F' => float 0.83333333333333
'G' => string '=E3+F3' (length=6)
'H' => boolean false
'I' => float 0.95
4 =>
array (size=9)
'A' => string 'Rachel' (length=6)
'B' => string 'Baker' (length=5)
'C' => string 'British' (length=7)
'D' => string 'F' (length=1)
'E' => float 30292
'F' => float 0.010416666666667
'G' => string '=E4+F4' (length=6)
'H' => boolean false
'I' => float 1