PHPExcel Reader Example #13
Simple File Reader for Multiple CSV Files
Loading file example1.csv into WorkSheet #1 using IOFactory with a defined reader type of CSV
Loading file example2.csv into WorkSheet #2 using IOFactory with a defined reader type of CSV
2 worksheets loaded
Worksheet #0 -> example1.csv
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(11) "19-Dec-1960"
["F"]=>
string(5) "01:30"
["G"]=>
string(7) "#VALUE!"
["H"]=>
string(4) "TRUE"
["I"]=>
string(3) "32%"
}
[3]=>
array(9) {
["A"]=>
string(4) "Toni"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
string(11) "24-Nov-1950"
["F"]=>
string(5) "20:00"
["G"]=>
string(7) "#VALUE!"
["H"]=>
string(5) "FALSE"
["I"]=>
string(3) "95%"
}
[4]=>
array(9) {
["A"]=>
string(6) "Rachel"
["B"]=>
string(5) "Baker"
["C"]=>
string(7) "British"
["D"]=>
string(1) "F"
["E"]=>
string(10) "7-Dec-1982"
["F"]=>
string(5) "00:15"
["G"]=>
string(7) "#VALUE!"
["H"]=>
string(5) "FALSE"
["I"]=>
string(4) "100%"
}
}
Worksheet #1 -> example2.csv
array(223) {
[1]=>
array(4) {
["A"]=>
string(4) "City"
["B"]=>
string(7) "Country"
["C"]=>
string(8) "Latitude"
["D"]=>
string(9) "Longitude"
}
[2]=>
array(4) {
["A"]=>
string(5) "Kabul"
["B"]=>
string(11) "Afghanistan"
["C"]=>
float(34.528455)
["D"]=>
float(69.171703)
}
[3]=>
array(4) {
["A"]=>
string(6) "Tirane"
["B"]=>
string(7) "Albania"
["C"]=>
float(41.33)
["D"]=>
float(19.82)
}
[4]=>
array(4) {
["A"]=>
string(7) "Algiers"
["B"]=>
string(7) "Algeria"
["C"]=>
float(36.752887)
["D"]=>
float(3.042048)
}
[5]=>
array(4) {
["A"]=>
string(9) "Pago Pago"
["B"]=>
string(14) "American Samoa"
["C"]=>
float(-14.27933)
["D"]=>
float(-170.700897)
}
[6]=>
array(4) {
["A"]=>
string(16) "Andorra la Vella"
["B"]=>
string(7) "Andorra"
["C"]=>
float(42.507531)
["D"]=>
float(1.521816)
}
[7]=>
array(4) {
["A"]=>
string(6) "Luanda"
["B"]=>
string(6) "Angola"
["C"]=>
float(-8.838333)
["D"]=>
float(13.234444)
}
[8]=>
array(4) {
["A"]=>
string(12) "Buenos Aires"
["B"]=>
string(9) "Argentina"
["C"]=>
float(-34.608417)
["D"]=>
float(-58.373161)
}
[9]=>
array(4) {
["A"]=>
string(7) "Yerevan"
["B"]=>
string(7) "Armenia"
["C"]=>
float(40.183333)
["D"]=>
float(44.516667)
}
[10]=>
array(4) {
["A"]=>
string(10) "Oranjestad"
["B"]=>
string(5) "Aruba"
["C"]=>
float(12.52458)
["D"]=>
float(-70.026459)
}
[11]=>
array(4) {
["A"]=>
string(8) "Canberra"
["B"]=>
string(9) "Australia"
["C"]=>
float(-35.3075)
["D"]=>
float(149.124417)
}
[12]=>
array(4) {
["A"]=>
string(6) "Vienna"
["B"]=>
string(7) "Austria"
["C"]=>
float(48.208333)
["D"]=>
float(16.373056)
}
[13]=>
array(4) {
["A"]=>
string(4) "Baku"
["B"]=>
string(10) "Azerbaijan"
["C"]=>
float(40.379571)
["D"]=>
float(49.891233)
}
[14]=>
array(4) {
["A"]=>
string(6) "Nassau"
["B"]=>
string(7) "Bahamas"
["C"]=>
float(25.06)
["D"]=>
float(-77.345)
}
[15]=>
array(4) {
["A"]=>
string(6) "Manama"
["B"]=>
string(7) "Bahrain"
["C"]=>
float(26.216667)
["D"]=>
float(50.583333)
}
[16]=>
array(4) {
["A"]=>
string(5) "Dhaka"
["B"]=>
string(10) "Bangladesh"
["C"]=>
float(23.709921)
["D"]=>
float(90.407143)
}
[17]=>
array(4) {
["A"]=>
string(10) "Bridgetown"
["B"]=>
string(8) "Barbados"
["C"]=>
float(13.096111)
["D"]=>
float(-59.608333)
}
[18]=>
array(4) {
["A"]=>
string(5) "Minsk"
["B"]=>
string(7) "Belarus"
["C"]=>
float(53.9)
["D"]=>
float(27.566667)
}
[19]=>
array(4) {
["A"]=>
string(8) "Brussels"
["B"]=>
string(7) "Belgium"
["C"]=>
float(50.846281)
["D"]=>
float(4.354727)
}
[20]=>
array(4) {
["A"]=>
string(8) "Belmopan"
["B"]=>
string(6) "Belize"
["C"]=>
float(17.251389)
["D"]=>
float(-88.766944)
}
[21]=>
array(4) {
["A"]=>
string(7) "Thimphu"
["B"]=>
string(6) "Bhutan"
["C"]=>
float(27.466667)
["D"]=>
float(89.641667)
}
[22]=>
array(4) {
["A"]=>
string(6) "La Paz"
["B"]=>
string(7) "Bolivia"
["C"]=>
float(-16.49901)
["D"]=>
float(-68.146248)
}
[23]=>
array(4) {
["A"]=>
string(8) "Sarajevo"
["B"]=>
string(22) "Bosnia and Herzegovina"
["C"]=>
float(43.8476)
["D"]=>
float(18.3564)
}
[24]=>
array(4) {
["A"]=>
string(8) "Gaborone"
["B"]=>
string(8) "Botswana"
["C"]=>
float(-24.65411)
["D"]=>
float(25.908739)
}
[25]=>
array(4) {
["A"]=>
string(8) "Brasilia"
["B"]=>
string(6) "Brazil"
["C"]=>
float(-15.780148)
["D"]=>
float(-47.92917)
}
[26]=>
array(4) {
["A"]=>
string(9) "Road Town"
["B"]=>
string(22) "British Virgin Islands"
["C"]=>
float(18.433333)
["D"]=>
float(-64.616667)
}
[27]=>
array(4) {
["A"]=>
string(19) "Bandar Seri Begawan"
["B"]=>
string(17) "Brunei Darussalam"
["C"]=>
float(4.9431)
["D"]=>
float(114.9425)
}
[28]=>
array(4) {
["A"]=>
string(5) "Sofia"
["B"]=>
string(8) "Bulgaria"
["C"]=>
float(42.697626)
["D"]=>
float(23.322284)
}
[29]=>
array(4) {
["A"]=>
string(11) "Ouagadougou"
["B"]=>
string(12) "Burkina Faso"
["C"]=>
float(12.364637)
["D"]=>
float(-1.533864)
}
[30]=>
array(4) {
["A"]=>
string(9) "Bujumbura"
["B"]=>
string(7) "Burundi"
["C"]=>
float(-3.361378)
["D"]=>
float(29.359878)
}
[31]=>
array(4) {
["A"]=>
string(10) "Phnom Penh"
["B"]=>
string(8) "Cambodia"
["C"]=>
float(11.55)
["D"]=>
float(104.916667)
}
[32]=>
array(4) {
["A"]=>
string(7) "Yaounde"
["B"]=>
string(8) "Cameroon"
["C"]=>
float(3.866667)
["D"]=>
float(11.516667)
}
[33]=>
array(4) {
["A"]=>
string(6) "Ottawa"
["B"]=>
string(6) "Canada"
["C"]=>
float(45.423494)
["D"]=>
float(-75.697933)
}
[34]=>
array(4) {
["A"]=>
string(5) "Praia"
["B"]=>
string(10) "Cape Verde"
["C"]=>
float(14.920833)
["D"]=>
float(-23.508333)
}
[35]=>
array(4) {
["A"]=>
string(11) "George Town"
["B"]=>
string(14) "Cayman Islands"
["C"]=>
float(19.286932)
["D"]=>
float(-81.367439)
}
[36]=>
array(4) {
["A"]=>
string(6) "Bangui"
["B"]=>
string(24) "Central African Republic"
["C"]=>
float(4.361698)
["D"]=>
float(18.555975)
}
[37]=>
array(4) {
["A"]=>
string(9) "N'Djamena"
["B"]=>
string(4) "Chad"
["C"]=>
float(12.104797)
["D"]=>
float(15.044506)
}
[38]=>
array(4) {
["A"]=>
string(8) "Santiago"
["B"]=>
string(5) "Chile"
["C"]=>
float(-33.42536)
["D"]=>
float(-70.566466)
}
[39]=>
array(4) {
["A"]=>
string(7) "Beijing"
["B"]=>
string(5) "China"
["C"]=>
float(39.904667)
["D"]=>
float(116.408198)
}
[40]=>
array(4) {
["A"]=>
string(6) "Bogota"
["B"]=>
string(8) "Colombia"
["C"]=>
float(4.647302)
["D"]=>
float(-74.096268)
}
[41]=>
array(4) {
["A"]=>
string(6) "Moroni"
["B"]=>
string(7) "Comoros"
["C"]=>
float(-11.717216)
["D"]=>
float(43.247315)
}
[42]=>
array(4) {
["A"]=>
string(11) "Brazzaville"
["B"]=>
string(5) "Congo"
["C"]=>
float(-4.266667)
["D"]=>
float(15.283333)
}
[43]=>
array(4) {
["A"]=>
string(8) "San Jose"
["B"]=>
string(10) "Costa Rica"
["C"]=>
float(9.933333)
["D"]=>
float(-84.083333)
}
[44]=>
array(4) {
["A"]=>
string(12) "Yamoussoukro"
["B"]=>
string(13) "Cote d'Ivoire"
["C"]=>
float(6.816667)
["D"]=>
float(-5.283333)
}
[45]=>
array(4) {
["A"]=>
string(6) "Zagreb"
["B"]=>
string(7) "Croatia"
["C"]=>
float(45.814912)
["D"]=>
float(15.978515)
}
[46]=>
array(4) {
["A"]=>
string(6) "Havana"
["B"]=>
string(4) "Cuba"
["C"]=>
float(23.133333)
["D"]=>
float(-82.366667)
}
[47]=>
array(4) {
["A"]=>
string(7) "Nicosia"
["B"]=>
string(6) "Cyprus"
["C"]=>
float(35.166667)
["D"]=>
float(33.366667)
}
[48]=>
array(4) {
["A"]=>
string(6) "Prague"
["B"]=>
string(14) "Czech Republic"
["C"]=>
float(50.087811)
["D"]=>
float(14.42046)
}
[49]=>
array(4) {
["A"]=>
string(8) "Kinshasa"
["B"]=>
string(5) "Congo"
["C"]=>
float(-4.325)
["D"]=>
float(15.322222)
}
[50]=>
array(4) {
["A"]=>
string(10) "Copenhagen"
["B"]=>
string(7) "Denmark"
["C"]=>
float(55.676294)
["D"]=>
float(12.568116)
}
[51]=>
array(4) {
["A"]=>
string(8) "Djibouti"
["B"]=>
string(8) "Djibouti"
["C"]=>
float(11.588)
["D"]=>
float(43.145)
}
[52]=>
array(4) {
["A"]=>
string(6) "Roseau"
["B"]=>
string(8) "Dominica"
["C"]=>
float(15.301389)
["D"]=>
float(-61.388333)
}
[53]=>
array(4) {
["A"]=>
string(13) "Santo Domingo"
["B"]=>
string(18) "Dominican Republic"
["C"]=>
float(18.5)
["D"]=>
float(-69.983333)
}
[54]=>
array(4) {
["A"]=>
string(4) "Dili"
["B"]=>
string(10) "East Timor"
["C"]=>
float(-8.566667)
["D"]=>
float(125.566667)
}
[55]=>
array(4) {
["A"]=>
string(5) "Quito"
["B"]=>
string(7) "Ecuador"
["C"]=>
float(-0.229498)
["D"]=>
float(-78.524277)
}
[56]=>
array(4) {
["A"]=>
string(5) "Cairo"
["B"]=>
string(5) "Egypt"
["C"]=>
float(30.064742)
["D"]=>
float(31.249509)
}
[57]=>
array(4) {
["A"]=>
string(12) "San Salvador"
["B"]=>
string(11) "El Salvador"
["C"]=>
float(13.69)
["D"]=>
float(-89.190003)
}
[58]=>
array(4) {
["A"]=>
string(6) "Malabo"
["B"]=>
string(17) "Equatorial Guinea"
["C"]=>
float(3.75)
["D"]=>
float(8.783333)
}
[59]=>
array(4) {
["A"]=>
string(6) "Asmara"
["B"]=>
string(7) "Eritrea"
["C"]=>
float(15.33236)
["D"]=>
float(38.92617)
}
[60]=>
array(4) {
["A"]=>
string(7) "Tallinn"
["B"]=>
string(7) "Estonia"
["C"]=>
float(59.438862)
["D"]=>
float(24.754472)
}
[61]=>
array(4) {
["A"]=>
string(11) "Addis Ababa"
["B"]=>
string(8) "Ethiopia"
["C"]=>
float(9.022736)
["D"]=>
float(38.746799)
}
[62]=>
array(4) {
["A"]=>
string(7) "Stanley"
["B"]=>
string(16) "Falkland Islands"
["C"]=>
float(-51.700981)
["D"]=>
float(-57.84919)
}
[63]=>
array(4) {
["A"]=>
string(8) "Torshavn"
["B"]=>
string(13) "Faroe Islands"
["C"]=>
float(62.017707)
["D"]=>
float(-6.771879)
}
[64]=>
array(4) {
["A"]=>
string(4) "Suva"
["B"]=>
string(4) "Fiji"
["C"]=>
float(-18.1416)
["D"]=>
float(178.4419)
}
[65]=>
array(4) {
["A"]=>
string(8) "Helsinki"
["B"]=>
string(7) "Finland"
["C"]=>
float(60.169813)
["D"]=>
float(24.93824)
}
[66]=>
array(4) {
["A"]=>
string(5) "Paris"
["B"]=>
string(6) "France"
["C"]=>
float(48.856667)
["D"]=>
float(2.350987)
}
[67]=>
array(4) {
["A"]=>
string(7) "Cayenne"
["B"]=>
string(13) "French Guiana"
["C"]=>
float(4.9227)
["D"]=>
float(-52.3269)
}
[68]=>
array(4) {
["A"]=>
string(7) "Papeete"
["B"]=>
string(16) "French Polynesia"
["C"]=>
float(-17.535021)
["D"]=>
float(-149.569595)
}
[69]=>
array(4) {
["A"]=>
string(10) "Libreville"
["B"]=>
string(5) "Gabon"
["C"]=>
float(0.390841)
["D"]=>
float(9.453644)
}
[70]=>
array(4) {
["A"]=>
string(6) "Banjul"
["B"]=>
string(6) "Gambia"
["C"]=>
float(13.453056)
["D"]=>
float(-16.5775)
}
[71]=>
array(4) {
["A"]=>
string(8) "T'bilisi"
["B"]=>
string(7) "Georgia"
["C"]=>
float(41.716667)
["D"]=>
float(44.783333)
}
[72]=>
array(4) {
["A"]=>
string(6) "Berlin"
["B"]=>
string(7) "Germany"
["C"]=>
float(52.523405)
["D"]=>
float(13.4114)
}
[73]=>
array(4) {
["A"]=>
string(5) "Accra"
["B"]=>
string(5) "Ghana"
["C"]=>
float(5.555717)
["D"]=>
float(-0.196306)
}
[74]=>
array(4) {
["A"]=>
string(6) "Athens"
["B"]=>
string(6) "Greece"
["C"]=>
float(37.97918)
["D"]=>
float(23.716647)
}
[75]=>
array(4) {
["A"]=>
string(4) "Nuuk"
["B"]=>
string(9) "Greenland"
["C"]=>
float(64.18362)
["D"]=>
float(-51.721407)
}
[76]=>
array(4) {
["A"]=>
string(11) "Basse-Terre"
["B"]=>
string(10) "Guadeloupe"
["C"]=>
float(15.998503)
["D"]=>
float(-61.72202)
}
[77]=>
array(4) {
["A"]=>
string(9) "Guatemala"
["B"]=>
string(9) "Guatemala"
["C"]=>
float(14.641389)
["D"]=>
float(-90.513056)
}
[78]=>
array(4) {
["A"]=>
string(14) "St. Peter Port"
["B"]=>
string(8) "Guernsey"
["C"]=>
float(49.458858)
["D"]=>
float(-2.534752)
}
[79]=>
array(4) {
["A"]=>
string(7) "Conakry"
["B"]=>
string(6) "Guinea"
["C"]=>
float(9.537029)
["D"]=>
float(-13.67847)
}
[80]=>
array(4) {
["A"]=>
string(6) "Bissau"
["B"]=>
string(13) "Guinea-Bissau"
["C"]=>
float(11.866667)
["D"]=>
float(-15.6)
}
[81]=>
array(4) {
["A"]=>
string(10) "Georgetown"
["B"]=>
string(6) "Guyana"
["C"]=>
float(6.804611)
["D"]=>
float(-58.154831)
}
[82]=>
array(4) {
["A"]=>
string(14) "Port-au-Prince"
["B"]=>
string(5) "Haiti"
["C"]=>
float(18.539269)
["D"]=>
float(-72.336408)
}
[83]=>
array(4) {
["A"]=>
string(11) "Tegucigalpa"
["B"]=>
string(8) "Honduras"
["C"]=>
float(14.082054)
["D"]=>
float(-87.206285)
}
[84]=>
array(4) {
["A"]=>
string(8) "Budapest"
["B"]=>
string(7) "Hungary"
["C"]=>
float(47.498406)
["D"]=>
float(19.040758)
}
[85]=>
array(4) {
["A"]=>
string(9) "Reykjavik"
["B"]=>
string(7) "Iceland"
["C"]=>
float(64.135338)
["D"]=>
float(-21.89521)
}
[86]=>
array(4) {
["A"]=>
string(9) "New Delhi"
["B"]=>
string(5) "India"
["C"]=>
float(28.635308)
["D"]=>
float(77.22496)
}
[87]=>
array(4) {
["A"]=>
string(7) "Jakarta"
["B"]=>
string(9) "Indonesia"
["C"]=>
float(-6.211544)
["D"]=>
float(106.845172)
}
[88]=>
array(4) {
["A"]=>
string(6) "Tehran"
["B"]=>
string(4) "Iran"
["C"]=>
float(35.696216)
["D"]=>
float(51.422945)
}
[89]=>
array(4) {
["A"]=>
string(7) "Baghdad"
["B"]=>
string(4) "Iraq"
["C"]=>
float(33.3157)
["D"]=>
float(44.3922)
}
[90]=>
array(4) {
["A"]=>
string(6) "Dublin"
["B"]=>
string(7) "Ireland"
["C"]=>
float(53.344104)
["D"]=>
float(-6.267494)
}
[91]=>
array(4) {
["A"]=>
string(9) "Jerusalem"
["B"]=>
string(6) "Israel"
["C"]=>
float(31.7857)
["D"]=>
float(35.2007)
}
[92]=>
array(4) {
["A"]=>
string(4) "Rome"
["B"]=>
string(5) "Italy"
["C"]=>
float(41.895466)
["D"]=>
float(12.482324)
}
[93]=>
array(4) {
["A"]=>
string(8) "Kingston"
["B"]=>
string(7) "Jamaica"
["C"]=>
float(17.992731)
["D"]=>
float(-76.792009)
}
[94]=>
array(4) {
["A"]=>
string(10) "St. Helier"
["B"]=>
string(6) "Jersey"
["C"]=>
float(49.190278)
["D"]=>
float(-2.108611)
}
[95]=>
array(4) {
["A"]=>
string(5) "Amman"
["B"]=>
string(6) "Jordan"
["C"]=>
float(31.956578)
["D"]=>
float(35.945695)
}
[96]=>
array(4) {
["A"]=>
string(6) "Astana"
["B"]=>
string(10) "Kazakhstan"
["C"]=>
float(51.1)
["D"]=>
float(71.3)
}
[97]=>
array(4) {
["A"]=>
string(7) "Nairobi"
["B"]=>
string(5) "Kenya"
["C"]=>
float(-1.17)
["D"]=>
float(36.48)
}
[98]=>
array(4) {
["A"]=>
string(6) "Tarawa"
["B"]=>
string(8) "Kiribati"
["C"]=>
float(1.3)
["D"]=>
float(173)
}
[99]=>
array(4) {
["A"]=>
string(5) "Seoul"
["B"]=>
string(11) "South Korea"
["C"]=>
float(37.31)
["D"]=>
float(126.58)
}
[100]=>
array(4) {
["A"]=>
string(11) "Kuwait City"
["B"]=>
string(6) "Kuwait"
["C"]=>
float(29.3)
["D"]=>
float(48)
}
[101]=>
array(4) {
["A"]=>
string(7) "Bishkek"
["B"]=>
string(10) "Kyrgyzstan"
["C"]=>
float(42.54)
["D"]=>
float(74.46)
}
[102]=>
array(4) {
["A"]=>
string(4) "Riga"
["B"]=>
string(6) "Latvia"
["C"]=>
float(56.53)
["D"]=>
float(24.08)
}
[103]=>
array(4) {
["A"]=>
string(6) "Beirut"
["B"]=>
string(7) "Lebanon"
["C"]=>
float(33.53)
["D"]=>
float(35.31)
}
[104]=>
array(4) {
["A"]=>
string(6) "Maseru"
["B"]=>
string(7) "Lesotho"
["C"]=>
float(-29.18)
["D"]=>
float(27.3)
}
[105]=>
array(4) {
["A"]=>
string(8) "Monrovia"
["B"]=>
string(7) "Liberia"
["C"]=>
float(6.18)
["D"]=>
float(-10.47)
}
[106]=>
array(4) {
["A"]=>
string(5) "Vaduz"
["B"]=>
string(13) "Liechtenstein"
["C"]=>
float(47.08)
["D"]=>
float(9.31)
}
[107]=>
array(4) {
["A"]=>
string(7) "Vilnius"
["B"]=>
string(9) "Lithuania"
["C"]=>
float(54.38)
["D"]=>
float(25.19)
}
[108]=>
array(4) {
["A"]=>
string(10) "Luxembourg"
["B"]=>
string(10) "Luxembourg"
["C"]=>
float(49.37)
["D"]=>
float(6.09)
}
[109]=>
array(4) {
["A"]=>
string(12) "Antananarivo"
["B"]=>
string(10) "Madagascar"
["C"]=>
float(-18.55)
["D"]=>
float(47.31)
}
[110]=>
array(4) {
["A"]=>
string(8) "Lilongwe"
["B"]=>
string(6) "Malawi"
["C"]=>
float(-14)
["D"]=>
float(33.48)
}
[111]=>
array(4) {
["A"]=>
string(12) "Kuala Lumpur"
["B"]=>
string(8) "Malaysia"
["C"]=>
float(3.09)
["D"]=>
float(101.41)
}
[112]=>
array(4) {
["A"]=>
string(4) "Male"
["B"]=>
string(8) "Maldives"
["C"]=>
float(4)
["D"]=>
float(73.28)
}
[113]=>
array(4) {
["A"]=>
string(6) "Bamako"
["B"]=>
string(4) "Mali"
["C"]=>
float(12.34)
["D"]=>
float(-7.55)
}
[114]=>
array(4) {
["A"]=>
string(8) "Valletta"
["B"]=>
string(5) "Malta"
["C"]=>
float(35.54)
["D"]=>
float(14.31)
}
[115]=>
array(4) {
["A"]=>
string(14) "Fort-de-France"
["B"]=>
string(10) "Martinique"
["C"]=>
float(14.36)
["D"]=>
float(-61.02)
}
[116]=>
array(4) {
["A"]=>
string(10) "Nouakchott"
["B"]=>
string(10) "Mauritania"
["C"]=>
float(-20.1)
["D"]=>
float(57.3)
}
[117]=>
array(4) {
["A"]=>
string(9) "Mamoudzou"
["B"]=>
string(7) "Mayotte"
["C"]=>
float(-12.48)
["D"]=>
float(45.14)
}
[118]=>
array(4) {
["A"]=>
string(11) "Mexico City"
["B"]=>
string(6) "Mexico"
["C"]=>
float(19.2)
["D"]=>
float(-99.1)
}
[119]=>
array(4) {
["A"]=>
string(7) "Palikir"
["B"]=>
string(10) "Micronesia"
["C"]=>
float(6.55)
["D"]=>
float(158.09)
}
[120]=>
array(4) {
["A"]=>
string(8) "Chisinau"
["B"]=>
string(7) "Moldova"
["C"]=>
float(47.02)
["D"]=>
float(28.5)
}
[121]=>
array(4) {
["A"]=>
string(6) "Maputo"
["B"]=>
string(10) "Mozambique"
["C"]=>
float(-25.58)
["D"]=>
float(32.32)
}
[122]=>
array(4) {
["A"]=>
string(6) "Yangon"
["B"]=>
string(7) "Myanmar"
["C"]=>
float(16.45)
["D"]=>
float(96.2)
}
[123]=>
array(4) {
["A"]=>
string(8) "Windhoek"
["B"]=>
string(7) "Namibia"
["C"]=>
float(-22.35)
["D"]=>
float(17.04)
}
[124]=>
array(4) {
["A"]=>
string(9) "Kathmandu"
["B"]=>
string(5) "Nepal"
["C"]=>
float(27.45)
["D"]=>
float(85.2)
}
[125]=>
array(4) {
["A"]=>
string(9) "Amsterdam"
["B"]=>
string(11) "Netherlands"
["C"]=>
float(52.23)
["D"]=>
float(4.54)
}
[126]=>
array(4) {
["A"]=>
string(10) "Willemstad"
["B"]=>
string(20) "Netherlands Antilles"
["C"]=>
float(12.05)
["D"]=>
float(-69)
}
[127]=>
array(4) {
["A"]=>
string(6) "Noumea"
["B"]=>
string(13) "New Caledonia"
["C"]=>
float(-22.17)
["D"]=>
float(166.3)
}
[128]=>
array(4) {
["A"]=>
string(10) "Wellington"
["B"]=>
string(11) "New Zealand"
["C"]=>
float(-41.19)
["D"]=>
float(174.46)
}
[129]=>
array(4) {
["A"]=>
string(7) "Managua"
["B"]=>
string(9) "Nicaragua"
["C"]=>
float(12.06)
["D"]=>
float(-86.2)
}
[130]=>
array(4) {
["A"]=>
string(6) "Niamey"
["B"]=>
string(5) "Niger"
["C"]=>
float(13.27)
["D"]=>
float(2.06)
}
[131]=>
array(4) {
["A"]=>
string(5) "Abuja"
["B"]=>
string(7) "Nigeria"
["C"]=>
float(9.05)
["D"]=>
float(7.32)
}
[132]=>
array(4) {
["A"]=>
string(8) "Kingston"
["B"]=>
string(14) "Norfolk Island"
["C"]=>
float(-45.2)
["D"]=>
float(168.43)
}
[133]=>
array(4) {
["A"]=>
string(6) "Saipan"
["B"]=>
string(24) "Northern Mariana Islands"
["C"]=>
float(15.12)
["D"]=>
float(145.45)
}
[134]=>
array(4) {
["A"]=>
string(4) "Oslo"
["B"]=>
string(6) "Norway"
["C"]=>
float(59.55)
["D"]=>
float(10.45)
}
[135]=>
array(4) {
["A"]=>
string(6) "Masqat"
["B"]=>
string(4) "Oman"
["C"]=>
float(23.37)
["D"]=>
float(58.36)
}
[136]=>
array(4) {
["A"]=>
string(9) "Islamabad"
["B"]=>
string(8) "Pakistan"
["C"]=>
float(33.4)
["D"]=>
float(73.1)
}
[137]=>
array(4) {
["A"]=>
string(5) "Koror"
["B"]=>
string(5) "Palau"
["C"]=>
float(7.2)
["D"]=>
float(134.28)
}
[138]=>
array(4) {
["A"]=>
string(11) "Panama City"
["B"]=>
string(6) "Panama"
["C"]=>
float(9)
["D"]=>
float(-79.25)
}
[139]=>
array(4) {
["A"]=>
string(12) "Port Moresby"
["B"]=>
string(16) "Papua New Guinea"
["C"]=>
float(-9.24)
["D"]=>
float(147.08)
}
[140]=>
array(4) {
["A"]=>
string(8) "Asuncion"
["B"]=>
string(8) "Paraguay"
["C"]=>
float(-25.1)
["D"]=>
float(-57.3)
}
[141]=>
array(4) {
["A"]=>
string(4) "Lima"
["B"]=>
string(4) "Peru"
["C"]=>
float(-12)
["D"]=>
float(-77)
}
[142]=>
array(4) {
["A"]=>
string(6) "Manila"
["B"]=>
string(11) "Philippines"
["C"]=>
float(14.4)
["D"]=>
float(121.03)
}
[143]=>
array(4) {
["A"]=>
string(6) "Warsaw"
["B"]=>
string(6) "Poland"
["C"]=>
float(52.13)
["D"]=>
float(21)
}
[144]=>
array(4) {
["A"]=>
string(6) "Lisbon"
["B"]=>
string(8) "Portugal"
["C"]=>
float(38.42)
["D"]=>
float(-9.1)
}
[145]=>
array(4) {
["A"]=>
string(8) "San Juan"
["B"]=>
string(11) "Puerto Rico"
["C"]=>
float(18.28)
["D"]=>
float(-66.07)
}
[146]=>
array(4) {
["A"]=>
string(4) "Doha"
["B"]=>
string(5) "Qatar"
["C"]=>
float(25.15)
["D"]=>
float(51.35)
}
[147]=>
array(4) {
["A"]=>
string(9) "Bucuresti"
["B"]=>
string(7) "Romania"
["C"]=>
float(44.27)
["D"]=>
float(26.1)
}
[148]=>
array(4) {
["A"]=>
string(6) "Moskva"
["B"]=>
string(18) "Russian Federation"
["C"]=>
float(55.45)
["D"]=>
float(37.35)
}
[149]=>
array(4) {
["A"]=>
string(6) "Kigali"
["B"]=>
string(7) "Rawanda"
["C"]=>
float(-1.59)
["D"]=>
float(30.04)
}
[150]=>
array(4) {
["A"]=>
string(10) "Basseterre"
["B"]=>
string(21) "Saint Kitts and Nevis"
["C"]=>
float(17.17)
["D"]=>
float(-62.43)
}
[151]=>
array(4) {
["A"]=>
string(8) "Castries"
["B"]=>
string(11) "Saint Lucia"
["C"]=>
float(14.02)
["D"]=>
float(-60.58)
}
[152]=>
array(4) {
["A"]=>
string(12) "Saint-Pierre"
["B"]=>
string(25) "Saint Pierre and Miquelon"
["C"]=>
float(46.46)
["D"]=>
float(-56.12)
}
[153]=>
array(4) {
["A"]=>
string(4) "Apia"
["B"]=>
string(5) "Samoa"
["C"]=>
float(-13.5)
["D"]=>
float(-171.5)
}
[154]=>
array(4) {
["A"]=>
string(10) "San Marino"
["B"]=>
string(10) "San Marino"
["C"]=>
float(43.55)
["D"]=>
float(12.3)
}
[155]=>
array(4) {
["A"]=>
string(8) "Sao Tome"
["B"]=>
string(21) "Sao Tome and Principe"
["C"]=>
float(0.1)
["D"]=>
float(6.39)
}
[156]=>
array(4) {
["A"]=>
string(6) "Riyadh"
["B"]=>
string(12) "Saudi Arabia"
["C"]=>
float(24.41)
["D"]=>
float(46.42)
}
[157]=>
array(4) {
["A"]=>
string(5) "Dakar"
["B"]=>
string(7) "Senegal"
["C"]=>
float(14.34)
["D"]=>
float(-17.29)
}
[158]=>
array(4) {
["A"]=>
string(8) "Freetown"
["B"]=>
string(12) "Sierra Leone"
["C"]=>
float(8.3)
["D"]=>
float(-13.17)
}
[159]=>
array(4) {
["A"]=>
string(10) "Bratislava"
["B"]=>
string(8) "Slovakia"
["C"]=>
float(48.1)
["D"]=>
float(17.07)
}
[160]=>
array(4) {
["A"]=>
string(9) "Ljubljana"
["B"]=>
string(8) "Slovenia"
["C"]=>
float(46.04)
["D"]=>
float(14.33)
}
[161]=>
array(4) {
["A"]=>
string(7) "Honiara"
["B"]=>
string(15) "Solomon Islands"
["C"]=>
float(-9.27)
["D"]=>
float(159.57)
}
[162]=>
array(4) {
["A"]=>
string(9) "Mogadishu"
["B"]=>
string(7) "Somalia"
["C"]=>
float(2.02)
["D"]=>
float(45.25)
}
[163]=>
array(4) {
["A"]=>
string(8) "Pretoria"
["B"]=>
string(12) "South Africa"
["C"]=>
float(-25.44)
["D"]=>
float(28.12)
}
[164]=>
array(4) {
["A"]=>
string(6) "Madrid"
["B"]=>
string(5) "Spain"
["C"]=>
float(40.25)
["D"]=>
float(-3.45)
}
[165]=>
array(4) {
["A"]=>
string(8) "Khartoum"
["B"]=>
string(5) "Sudan"
["C"]=>
float(15.31)
["D"]=>
float(32.35)
}
[166]=>
array(4) {
["A"]=>
string(10) "Paramaribo"
["B"]=>
string(8) "Suriname"
["C"]=>
float(5.5)
["D"]=>
float(-55.1)
}
[167]=>
array(4) {
["A"]=>
string(7) "Mbabane"
["B"]=>
string(9) "Swaziland"
["C"]=>
float(-26.18)
["D"]=>
float(31.06)
}
[168]=>
array(4) {
["A"]=>
string(9) "Stockholm"
["B"]=>
string(6) "Sweden"
["C"]=>
float(59.2)
["D"]=>
float(18.03)
}
[169]=>
array(4) {
["A"]=>
string(4) "Bern"
["B"]=>
string(11) "Switzerland"
["C"]=>
float(46.57)
["D"]=>
float(7.28)
}
[170]=>
array(4) {
["A"]=>
string(8) "Damascus"
["B"]=>
string(20) "Syrian Arab Republic"
["C"]=>
float(33.3)
["D"]=>
float(36.18)
}
[171]=>
array(4) {
["A"]=>
string(8) "Dushanbe"
["B"]=>
string(10) "Tajikistan"
["C"]=>
float(38.33)
["D"]=>
float(68.48)
}
[172]=>
array(4) {
["A"]=>
string(7) "Bangkok"
["B"]=>
string(8) "Thailand"
["C"]=>
float(13.45)
["D"]=>
float(100.35)
}
[173]=>
array(4) {
["A"]=>
string(4) "Lome"
["B"]=>
string(4) "Togo"
["C"]=>
float(6.09)
["D"]=>
float(1.2)
}
[174]=>
array(4) {
["A"]=>
string(10) "Nuku'alofa"
["B"]=>
string(5) "Tonga"
["C"]=>
float(-21.1)
["D"]=>
float(-174)
}
[175]=>
array(4) {
["A"]=>
string(5) "Tunis"
["B"]=>
string(7) "Tunisia"
["C"]=>
float(36.5)
["D"]=>
float(10.11)
}
[176]=>
array(4) {
["A"]=>
string(6) "Ankara"
["B"]=>
string(6) "Turkey"
["C"]=>
float(39.57)
["D"]=>
float(32.54)
}
[177]=>
array(4) {
["A"]=>
string(8) "Ashgabat"
["B"]=>
string(12) "Turkmenistan"
["C"]=>
float(38)
["D"]=>
float(57.5)
}
[178]=>
array(4) {
["A"]=>
string(8) "Funafuti"
["B"]=>
string(6) "Tuvalu"
["C"]=>
float(-8.31)
["D"]=>
float(179.13)
}
[179]=>
array(4) {
["A"]=>
string(7) "Kampala"
["B"]=>
string(6) "Uganda"
["C"]=>
float(0.2)
["D"]=>
float(32.3)
}
[180]=>
array(4) {
["A"]=>
string(4) "Kiev"
["B"]=>
string(7) "Ukraine"
["C"]=>
float(50.3)
["D"]=>
float(30.28)
}
[181]=>
array(4) {
["A"]=>
string(9) "Abu Dhabi"
["B"]=>
string(20) "United Arab Emirates"
["C"]=>
float(24.28)
["D"]=>
float(54.22)
}
[182]=>
array(4) {
["A"]=>
string(6) "London"
["B"]=>
string(14) "United Kingdom"
["C"]=>
float(51.36)
["D"]=>
float(-0.05)
}
[183]=>
array(4) {
["A"]=>
string(6) "Dodoma"
["B"]=>
string(8) "Tanzania"
["C"]=>
float(-6.08)
["D"]=>
float(35.45)
}
[184]=>
array(4) {
["A"]=>
string(13) "Washington DC"
["B"]=>
string(24) "United States of America"
["C"]=>
float(39.91)
["D"]=>
float(-77.02)
}
[185]=>
array(4) {
["A"]=>
string(10) "Montevideo"
["B"]=>
string(7) "Uruguay"
["C"]=>
float(-34.5)
["D"]=>
float(-56.11)
}
[186]=>
array(4) {
["A"]=>
string(8) "Tashkent"
["B"]=>
string(10) "Uzbekistan"
["C"]=>
float(41.2)
["D"]=>
float(69.1)
}
[187]=>
array(4) {
["A"]=>
string(9) "Port-Vila"
["B"]=>
string(7) "Vanuatu"
["C"]=>
float(-17.45)
["D"]=>
float(168.18)
}
[188]=>
array(4) {
["A"]=>
string(7) "Caracas"
["B"]=>
string(9) "Venezuela"
["C"]=>
float(10.3)
["D"]=>
float(-66.55)
}
[189]=>
array(4) {
["A"]=>
string(5) "Hanoi"
["B"]=>
string(8) "Viet Nam"
["C"]=>
float(21.05)
["D"]=>
float(105.55)
}
[190]=>
array(4) {
["A"]=>
string(8) "Belgrade"
["B"]=>
string(10) "Yugoslavia"
["C"]=>
float(44.5)
["D"]=>
float(20.37)
}
[191]=>
array(4) {
["A"]=>
string(6) "Lusaka"
["B"]=>
string(6) "Zambia"
["C"]=>
float(-15.28)
["D"]=>
float(28.16)
}
[192]=>
array(4) {
["A"]=>
string(6) "Harare"
["B"]=>
string(8) "Zimbabwe"
["C"]=>
float(-17.43)
["D"]=>
float(31.02)
}
[193]=>
array(4) {
["A"]=>
string(10) "St. John's"
["B"]=>
string(19) "Antigua and Barbuda"
["C"]=>
float(17.08)
["D"]=>
float(-61.5)
}
[194]=>
array(4) {
["A"]=>
string(10) "Porto Novo"
["B"]=>
string(5) "Benin"
["C"]=>
float(6.3)
["D"]=>
float(2.47)
}
[195]=>
array(4) {
["A"]=>
string(8) "Hamilton"
["B"]=>
string(14) "Bermuda",32.18"
["C"]=>
float(-64.48)
["D"]=>
NULL
}
[196]=>
array(4) {
["A"]=>
string(6) "Avarua"
["B"]=>
string(12) "Cook Islands"
["C"]=>
float(-21.12)
["D"]=>
float(-159.46)
}
[197]=>
array(4) {
["A"]=>
string(12) "St. George's"
["B"]=>
string(7) "Grenada"
["C"]=>
float(12.04)
["D"]=>
float(-61.44)
}
[198]=>
array(4) {
["A"]=>
string(3) "Aga"
["B"]=>
string(4) "Guam"
["C"]=>
float(13.28)
["D"]=>
float(144.45)
}
[199]=>
array(4) {
["A"]=>
string(8) "Victoria"
["B"]=>
string(9) "Hong Kong"
["C"]=>
float(22.16)
["D"]=>
float(114.13)
}
[200]=>
array(4) {
["A"]=>
string(5) "Tokyo"
["B"]=>
string(5) "Japan"
["C"]=>
float(35.4)
["D"]=>
float(139.45)
}
[201]=>
array(4) {
["A"]=>
string(9) "Pyongyang"
["B"]=>
string(11) "North Korea"
["C"]=>
float(39)
["D"]=>
float(125.47)
}
[202]=>
array(4) {
["A"]=>
string(9) "Vientiane"
["B"]=>
string(4) "Laos"
["C"]=>
float(17.59)
["D"]=>
float(102.38)
}
[203]=>
array(4) {
["A"]=>
string(7) "Tripoli"
["B"]=>
string(5) "Libya"
["C"]=>
float(32.54)
["D"]=>
float(13.11)
}
[204]=>
array(4) {
["A"]=>
string(6) "Skopje"
["B"]=>
string(9) "Macedonia"
["C"]=>
float(42)
["D"]=>
float(21.28)
}
[205]=>
array(4) {
["A"]=>
string(6) "Majuro"
["B"]=>
string(16) "Marshall Islands"
["C"]=>
float(7.05)
["D"]=>
float(171.08)
}
[206]=>
array(4) {
["A"]=>
string(10) "Port Louis"
["B"]=>
string(9) "Mauritius"
["C"]=>
float(-20.1)
["D"]=>
float(57.3)
}
[207]=>
array(4) {
["A"]=>
string(6) "Monaco"
["B"]=>
string(6) "Monaco"
["C"]=>
float(43.44)
["D"]=>
float(7.25)
}
[208]=>
array(4) {
["A"]=>
string(10) "Ulan Bator"
["B"]=>
string(8) "Mongolia"
["C"]=>
float(47.54)
["D"]=>
float(106.52)
}
[209]=>
array(4) {
["A"]=>
string(8) "Plymouth"
["B"]=>
string(10) "Montserrat"
["C"]=>
float(16.44)
["D"]=>
float(-62.14)
}
[210]=>
array(4) {
["A"]=>
string(5) "Rabat"
["B"]=>
string(7) "Morocco"
["C"]=>
float(34.02)
["D"]=>
float(-6.51)
}
[211]=>
array(4) {
["A"]=>
string(5) "Alofi"
["B"]=>
string(4) "Niue"
["C"]=>
float(-14.27)
["D"]=>
float(-178.05)
}
[212]=>
array(4) {
["A"]=>
string(11) "Saint-Denis"
["B"]=>
string(1) "R"
["C"]=>
float(-20.52)
["D"]=>
float(55.27)
}
[213]=>
array(4) {
["A"]=>
string(8) "Victoria"
["B"]=>
string(10) "Seychelles"
["C"]=>
float(-4.38)
["D"]=>
float(55.28)
}
[214]=>
array(4) {
["A"]=>
string(9) "Singapore"
["B"]=>
string(9) "Singapore"
["C"]=>
float(1.18)
["D"]=>
float(103.5)
}
[215]=>
array(4) {
["A"]=>
string(7) "Colombo"
["B"]=>
string(9) "Sri Lanka"
["C"]=>
float(6.55)
["D"]=>
float(79.52)
}
[216]=>
array(4) {
["A"]=>
string(9) "Kingstown"
["B"]=>
string(29) "St Vincent and the Grenadines"
["C"]=>
float(13.12)
["D"]=>
float(-61.14)
}
[217]=>
array(4) {
["A"]=>
string(6) "Taipei"
["B"]=>
string(6) "Taiwan"
["C"]=>
float(25.5)
["D"]=>
float(121.32)
}
[218]=>
array(4) {
["A"]=>
string(13) "Port-of-Spain"
["B"]=>
string(19) "Trinidad and Tobago"
["C"]=>
float(10.38)
["D"]=>
float(-61.31)
}
[219]=>
array(4) {
["A"]=>
string(16) "Cockburn Harbour"
["B"]=>
string(24) "Turks and Caicos Islands"
["C"]=>
float(21.3)
["D"]=>
float(-71.3)
}
[220]=>
array(4) {
["A"]=>
string(16) "Charlotte Amalie"
["B"]=>
string(17) "US Virgin Islands"
["C"]=>
float(18.22)
["D"]=>
float(-64.56)
}
[221]=>
array(4) {
["A"]=>
string(12) "Vatican City"
["B"]=>
string(13) "Vatican State"
["C"]=>
float(41.54)
["D"]=>
float(12.27)
}
[222]=>
array(4) {
["A"]=>
string(2) "La"
["B"]=>
string(14) "Western Sahara"
["C"]=>
float(27.1)
["D"]=>
float(-13.11)
}
[223]=>
array(4) {
["A"]=>
string(5) "San'a"
["B"]=>
string(5) "Yemen"
["C"]=>
float(15.24)
["D"]=>
float(44.14)
}
}