PHPExcel Reader Example #14
Reading a Large CSV file in "Chunks" to split across multiple Worksheets
Loading file example2.csv using IOFactory with a defined reader type of CSV
Loading WorkSheet #1 using configurable filter for headings row 1 and for rows 2 to 101
Loading WorkSheet #2 using configurable filter for headings row 1 and for rows 102 to 201
Loading WorkSheet #3 using configurable filter for headings row 1 and for rows 202 to 301
3 worksheets loaded
Worksheet #0 -> Country Data #1
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader14.php:99:
array (size=101)
1 =>
array (size=4)
'A' => string 'City' (length=4)
'B' => string 'Country' (length=7)
'C' => string 'Latitude' (length=8)
'D' => string 'Longitude' (length=9)
2 =>
array (size=4)
'A' => string 'Kabul' (length=5)
'B' => string 'Afghanistan' (length=11)
'C' => float 34.528455
'D' => float 69.171703
3 =>
array (size=4)
'A' => string 'Tirane' (length=6)
'B' => string 'Albania' (length=7)
'C' => float 41.33
'D' => float 19.82
4 =>
array (size=4)
'A' => string 'Algiers' (length=7)
'B' => string 'Algeria' (length=7)
'C' => float 36.752887
'D' => float 3.042048
5 =>
array (size=4)
'A' => string 'Pago Pago' (length=9)
'B' => string 'American Samoa' (length=14)
'C' => float -14.27933
'D' => float -170.700897
6 =>
array (size=4)
'A' => string 'Andorra la Vella' (length=16)
'B' => string 'Andorra' (length=7)
'C' => float 42.507531
'D' => float 1.521816
7 =>
array (size=4)
'A' => string 'Luanda' (length=6)
'B' => string 'Angola' (length=6)
'C' => float -8.838333
'D' => float 13.234444
8 =>
array (size=4)
'A' => string 'Buenos Aires' (length=12)
'B' => string 'Argentina' (length=9)
'C' => float -34.608417
'D' => float -58.373161
9 =>
array (size=4)
'A' => string 'Yerevan' (length=7)
'B' => string 'Armenia' (length=7)
'C' => float 40.183333
'D' => float 44.516667
10 =>
array (size=4)
'A' => string 'Oranjestad' (length=10)
'B' => string 'Aruba' (length=5)
'C' => float 12.52458
'D' => float -70.026459
11 =>
array (size=4)
'A' => string 'Canberra' (length=8)
'B' => string 'Australia' (length=9)
'C' => float -35.3075
'D' => float 149.124417
12 =>
array (size=4)
'A' => string 'Vienna' (length=6)
'B' => string 'Austria' (length=7)
'C' => float 48.208333
'D' => float 16.373056
13 =>
array (size=4)
'A' => string 'Baku' (length=4)
'B' => string 'Azerbaijan' (length=10)
'C' => float 40.379571
'D' => float 49.891233
14 =>
array (size=4)
'A' => string 'Nassau' (length=6)
'B' => string 'Bahamas' (length=7)
'C' => float 25.06
'D' => float -77.345
15 =>
array (size=4)
'A' => string 'Manama' (length=6)
'B' => string 'Bahrain' (length=7)
'C' => float 26.216667
'D' => float 50.583333
16 =>
array (size=4)
'A' => string 'Dhaka' (length=5)
'B' => string 'Bangladesh' (length=10)
'C' => float 23.709921
'D' => float 90.407143
17 =>
array (size=4)
'A' => string 'Bridgetown' (length=10)
'B' => string 'Barbados' (length=8)
'C' => float 13.096111
'D' => float -59.608333
18 =>
array (size=4)
'A' => string 'Minsk' (length=5)
'B' => string 'Belarus' (length=7)
'C' => float 53.9
'D' => float 27.566667
19 =>
array (size=4)
'A' => string 'Brussels' (length=8)
'B' => string 'Belgium' (length=7)
'C' => float 50.846281
'D' => float 4.354727
20 =>
array (size=4)
'A' => string 'Belmopan' (length=8)
'B' => string 'Belize' (length=6)
'C' => float 17.251389
'D' => float -88.766944
21 =>
array (size=4)
'A' => string 'Thimphu' (length=7)
'B' => string 'Bhutan' (length=6)
'C' => float 27.466667
'D' => float 89.641667
22 =>
array (size=4)
'A' => string 'La Paz' (length=6)
'B' => string 'Bolivia' (length=7)
'C' => float -16.49901
'D' => float -68.146248
23 =>
array (size=4)
'A' => string 'Sarajevo' (length=8)
'B' => string 'Bosnia and Herzegovina' (length=22)
'C' => float 43.8476
'D' => float 18.3564
24 =>
array (size=4)
'A' => string 'Gaborone' (length=8)
'B' => string 'Botswana' (length=8)
'C' => float -24.65411
'D' => float 25.908739
25 =>
array (size=4)
'A' => string 'Brasilia' (length=8)
'B' => string 'Brazil' (length=6)
'C' => float -15.780148
'D' => float -47.92917
26 =>
array (size=4)
'A' => string 'Road Town' (length=9)
'B' => string 'British Virgin Islands' (length=22)
'C' => float 18.433333
'D' => float -64.616667
27 =>
array (size=4)
'A' => string 'Bandar Seri Begawan' (length=19)
'B' => string 'Brunei Darussalam' (length=17)
'C' => float 4.9431
'D' => float 114.9425
28 =>
array (size=4)
'A' => string 'Sofia' (length=5)
'B' => string 'Bulgaria' (length=8)
'C' => float 42.697626
'D' => float 23.322284
29 =>
array (size=4)
'A' => string 'Ouagadougou' (length=11)
'B' => string 'Burkina Faso' (length=12)
'C' => float 12.364637
'D' => float -1.533864
30 =>
array (size=4)
'A' => string 'Bujumbura' (length=9)
'B' => string 'Burundi' (length=7)
'C' => float -3.361378
'D' => float 29.359878
31 =>
array (size=4)
'A' => string 'Phnom Penh' (length=10)
'B' => string 'Cambodia' (length=8)
'C' => float 11.55
'D' => float 104.916667
32 =>
array (size=4)
'A' => string 'Yaounde' (length=7)
'B' => string 'Cameroon' (length=8)
'C' => float 3.866667
'D' => float 11.516667
33 =>
array (size=4)
'A' => string 'Ottawa' (length=6)
'B' => string 'Canada' (length=6)
'C' => float 45.423494
'D' => float -75.697933
34 =>
array (size=4)
'A' => string 'Praia' (length=5)
'B' => string 'Cape Verde' (length=10)
'C' => float 14.920833
'D' => float -23.508333
35 =>
array (size=4)
'A' => string 'George Town' (length=11)
'B' => string 'Cayman Islands' (length=14)
'C' => float 19.286932
'D' => float -81.367439
36 =>
array (size=4)
'A' => string 'Bangui' (length=6)
'B' => string 'Central African Republic' (length=24)
'C' => float 4.361698
'D' => float 18.555975
37 =>
array (size=4)
'A' => string 'N'Djamena' (length=9)
'B' => string 'Chad' (length=4)
'C' => float 12.104797
'D' => float 15.044506
38 =>
array (size=4)
'A' => string 'Santiago' (length=8)
'B' => string 'Chile' (length=5)
'C' => float -33.42536
'D' => float -70.566466
39 =>
array (size=4)
'A' => string 'Beijing' (length=7)
'B' => string 'China' (length=5)
'C' => float 39.904667
'D' => float 116.408198
40 =>
array (size=4)
'A' => string 'Bogota' (length=6)
'B' => string 'Colombia' (length=8)
'C' => float 4.647302
'D' => float -74.096268
41 =>
array (size=4)
'A' => string 'Moroni' (length=6)
'B' => string 'Comoros' (length=7)
'C' => float -11.717216
'D' => float 43.247315
42 =>
array (size=4)
'A' => string 'Brazzaville' (length=11)
'B' => string 'Congo' (length=5)
'C' => float -4.266667
'D' => float 15.283333
43 =>
array (size=4)
'A' => string 'San Jose' (length=8)
'B' => string 'Costa Rica' (length=10)
'C' => float 9.933333
'D' => float -84.083333
44 =>
array (size=4)
'A' => string 'Yamoussoukro' (length=12)
'B' => string 'Cote d'Ivoire' (length=13)
'C' => float 6.816667
'D' => float -5.283333
45 =>
array (size=4)
'A' => string 'Zagreb' (length=6)
'B' => string 'Croatia' (length=7)
'C' => float 45.814912
'D' => float 15.978515
46 =>
array (size=4)
'A' => string 'Havana' (length=6)
'B' => string 'Cuba' (length=4)
'C' => float 23.133333
'D' => float -82.366667
47 =>
array (size=4)
'A' => string 'Nicosia' (length=7)
'B' => string 'Cyprus' (length=6)
'C' => float 35.166667
'D' => float 33.366667
48 =>
array (size=4)
'A' => string 'Prague' (length=6)
'B' => string 'Czech Republic' (length=14)
'C' => float 50.087811
'D' => float 14.42046
49 =>
array (size=4)
'A' => string 'Kinshasa' (length=8)
'B' => string 'Congo' (length=5)
'C' => float -4.325
'D' => float 15.322222
50 =>
array (size=4)
'A' => string 'Copenhagen' (length=10)
'B' => string 'Denmark' (length=7)
'C' => float 55.676294
'D' => float 12.568116
51 =>
array (size=4)
'A' => string 'Djibouti' (length=8)
'B' => string 'Djibouti' (length=8)
'C' => float 11.588
'D' => float 43.145
52 =>
array (size=4)
'A' => string 'Roseau' (length=6)
'B' => string 'Dominica' (length=8)
'C' => float 15.301389
'D' => float -61.388333
53 =>
array (size=4)
'A' => string 'Santo Domingo' (length=13)
'B' => string 'Dominican Republic' (length=18)
'C' => float 18.5
'D' => float -69.983333
54 =>
array (size=4)
'A' => string 'Dili' (length=4)
'B' => string 'East Timor' (length=10)
'C' => float -8.566667
'D' => float 125.566667
55 =>
array (size=4)
'A' => string 'Quito' (length=5)
'B' => string 'Ecuador' (length=7)
'C' => float -0.229498
'D' => float -78.524277
56 =>
array (size=4)
'A' => string 'Cairo' (length=5)
'B' => string 'Egypt' (length=5)
'C' => float 30.064742
'D' => float 31.249509
57 =>
array (size=4)
'A' => string 'San Salvador' (length=12)
'B' => string 'El Salvador' (length=11)
'C' => float 13.69
'D' => float -89.190003
58 =>
array (size=4)
'A' => string 'Malabo' (length=6)
'B' => string 'Equatorial Guinea' (length=17)
'C' => float 3.75
'D' => float 8.783333
59 =>
array (size=4)
'A' => string 'Asmara' (length=6)
'B' => string 'Eritrea' (length=7)
'C' => float 15.33236
'D' => float 38.92617
60 =>
array (size=4)
'A' => string 'Tallinn' (length=7)
'B' => string 'Estonia' (length=7)
'C' => float 59.438862
'D' => float 24.754472
61 =>
array (size=4)
'A' => string 'Addis Ababa' (length=11)
'B' => string 'Ethiopia' (length=8)
'C' => float 9.022736
'D' => float 38.746799
62 =>
array (size=4)
'A' => string 'Stanley' (length=7)
'B' => string 'Falkland Islands' (length=16)
'C' => float -51.700981
'D' => float -57.84919
63 =>
array (size=4)
'A' => string 'Torshavn' (length=8)
'B' => string 'Faroe Islands' (length=13)
'C' => float 62.017707
'D' => float -6.771879
64 =>
array (size=4)
'A' => string 'Suva' (length=4)
'B' => string 'Fiji' (length=4)
'C' => float -18.1416
'D' => float 178.4419
65 =>
array (size=4)
'A' => string 'Helsinki' (length=8)
'B' => string 'Finland' (length=7)
'C' => float 60.169813
'D' => float 24.93824
66 =>
array (size=4)
'A' => string 'Paris' (length=5)
'B' => string 'France' (length=6)
'C' => float 48.856667
'D' => float 2.350987
67 =>
array (size=4)
'A' => string 'Cayenne' (length=7)
'B' => string 'French Guiana' (length=13)
'C' => float 4.9227
'D' => float -52.3269
68 =>
array (size=4)
'A' => string 'Papeete' (length=7)
'B' => string 'French Polynesia' (length=16)
'C' => float -17.535021
'D' => float -149.569595
69 =>
array (size=4)
'A' => string 'Libreville' (length=10)
'B' => string 'Gabon' (length=5)
'C' => float 0.390841
'D' => float 9.453644
70 =>
array (size=4)
'A' => string 'Banjul' (length=6)
'B' => string 'Gambia' (length=6)
'C' => float 13.453056
'D' => float -16.5775
71 =>
array (size=4)
'A' => string 'T'bilisi' (length=8)
'B' => string 'Georgia' (length=7)
'C' => float 41.716667
'D' => float 44.783333
72 =>
array (size=4)
'A' => string 'Berlin' (length=6)
'B' => string 'Germany' (length=7)
'C' => float 52.523405
'D' => float 13.4114
73 =>
array (size=4)
'A' => string 'Accra' (length=5)
'B' => string 'Ghana' (length=5)
'C' => float 5.555717
'D' => float -0.196306
74 =>
array (size=4)
'A' => string 'Athens' (length=6)
'B' => string 'Greece' (length=6)
'C' => float 37.97918
'D' => float 23.716647
75 =>
array (size=4)
'A' => string 'Nuuk' (length=4)
'B' => string 'Greenland' (length=9)
'C' => float 64.18362
'D' => float -51.721407
76 =>
array (size=4)
'A' => string 'Basse-Terre' (length=11)
'B' => string 'Guadeloupe' (length=10)
'C' => float 15.998503
'D' => float -61.72202
77 =>
array (size=4)
'A' => string 'Guatemala' (length=9)
'B' => string 'Guatemala' (length=9)
'C' => float 14.641389
'D' => float -90.513056
78 =>
array (size=4)
'A' => string 'St. Peter Port' (length=14)
'B' => string 'Guernsey' (length=8)
'C' => float 49.458858
'D' => float -2.534752
79 =>
array (size=4)
'A' => string 'Conakry' (length=7)
'B' => string 'Guinea' (length=6)
'C' => float 9.537029
'D' => float -13.67847
80 =>
array (size=4)
'A' => string 'Bissau' (length=6)
'B' => string 'Guinea-Bissau' (length=13)
'C' => float 11.866667
'D' => float -15.6
81 =>
array (size=4)
'A' => string 'Georgetown' (length=10)
'B' => string 'Guyana' (length=6)
'C' => float 6.804611
'D' => float -58.154831
82 =>
array (size=4)
'A' => string 'Port-au-Prince' (length=14)
'B' => string 'Haiti' (length=5)
'C' => float 18.539269
'D' => float -72.336408
83 =>
array (size=4)
'A' => string 'Tegucigalpa' (length=11)
'B' => string 'Honduras' (length=8)
'C' => float 14.082054
'D' => float -87.206285
84 =>
array (size=4)
'A' => string 'Budapest' (length=8)
'B' => string 'Hungary' (length=7)
'C' => float 47.498406
'D' => float 19.040758
85 =>
array (size=4)
'A' => string 'Reykjavik' (length=9)
'B' => string 'Iceland' (length=7)
'C' => float 64.135338
'D' => float -21.89521
86 =>
array (size=4)
'A' => string 'New Delhi' (length=9)
'B' => string 'India' (length=5)
'C' => float 28.635308
'D' => float 77.22496
87 =>
array (size=4)
'A' => string 'Jakarta' (length=7)
'B' => string 'Indonesia' (length=9)
'C' => float -6.211544
'D' => float 106.845172
88 =>
array (size=4)
'A' => string 'Tehran' (length=6)
'B' => string 'Iran' (length=4)
'C' => float 35.696216
'D' => float 51.422945
89 =>
array (size=4)
'A' => string 'Baghdad' (length=7)
'B' => string 'Iraq' (length=4)
'C' => float 33.3157
'D' => float 44.3922
90 =>
array (size=4)
'A' => string 'Dublin' (length=6)
'B' => string 'Ireland' (length=7)
'C' => float 53.344104
'D' => float -6.267494
91 =>
array (size=4)
'A' => string 'Jerusalem' (length=9)
'B' => string 'Israel' (length=6)
'C' => float 31.7857
'D' => float 35.2007
92 =>
array (size=4)
'A' => string 'Rome' (length=4)
'B' => string 'Italy' (length=5)
'C' => float 41.895466
'D' => float 12.482324
93 =>
array (size=4)
'A' => string 'Kingston' (length=8)
'B' => string 'Jamaica' (length=7)
'C' => float 17.992731
'D' => float -76.792009
94 =>
array (size=4)
'A' => string 'St. Helier' (length=10)
'B' => string 'Jersey' (length=6)
'C' => float 49.190278
'D' => float -2.108611
95 =>
array (size=4)
'A' => string 'Amman' (length=5)
'B' => string 'Jordan' (length=6)
'C' => float 31.956578
'D' => float 35.945695
96 =>
array (size=4)
'A' => string 'Astana' (length=6)
'B' => string 'Kazakhstan' (length=10)
'C' => float 51.1
'D' => float 71.3
97 =>
array (size=4)
'A' => string 'Nairobi' (length=7)
'B' => string 'Kenya' (length=5)
'C' => string '-01.17' (length=6)
'D' => float 36.48
98 =>
array (size=4)
'A' => string 'Tarawa' (length=6)
'B' => string 'Kiribati' (length=8)
'C' => string '01.30' (length=5)
'D' => float 173
99 =>
array (size=4)
'A' => string 'Seoul' (length=5)
'B' => string 'South Korea' (length=11)
'C' => float 37.31
'D' => float 126.58
100 =>
array (size=4)
'A' => string 'Kuwait City' (length=11)
'B' => string 'Kuwait' (length=6)
'C' => float 29.3
'D' => float 48
101 =>
array (size=4)
'A' => string 'Bishkek' (length=7)
'B' => string 'Kyrgyzstan' (length=10)
'C' => float 42.54
'D' => float 74.46
Worksheet #1 -> Country Data #2
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader14.php:99:
array (size=1)
1 =>
array (size=1)
'A' => null
Worksheet #2 -> Country Data #3
/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader14.php:99:
array (size=1)
1 =>
array (size=1)
'A' => null