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.17170299999999) } [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.61666700000001) } [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.69793300000001) } [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.56646600000001) } [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.09626799999999) } [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.933332999999999) ["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.36666700000001) } [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.566667000000001) ["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.783333000000001) } [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.453644000000001) } [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.51305600000001) } [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.33640800000001) } [83]=> array(4) { ["A"]=> string(11) "Tegucigalpa" ["B"]=> string(8) "Honduras" ["C"]=> float(14.082054) ["D"]=> float(-87.20628499999999) } [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.79200899999999) } [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.45999999999999) } [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.09999999999999) } [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.050000000000001) ["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.09999999999999) } [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.06999999999999) } [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.300000000000001) ["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.09999999999999) } [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) } }