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


Deprecated: Optional parameter $pCoordinate declared before required parameter $pValue is implicitly treated as a required parameter in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php on line 1477
Loading WorkSheet #1 using configurable filter for headings row 1 and for rows 2 to 101

Deprecated: auto_detect_line_endings is deprecated in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/CSV.php on line 249

Deprecated: Return type of PHPExcel_WorksheetIterator::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 76

Deprecated: Return type of PHPExcel_WorksheetIterator::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 94

Deprecated: Return type of PHPExcel_WorksheetIterator::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 86

Deprecated: Return type of PHPExcel_WorksheetIterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 104

Deprecated: Return type of PHPExcel_WorksheetIterator::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/WorksheetIterator.php on line 66
Loading WorkSheet #2 using configurable filter for headings row 1 and for rows 102 to 201

Deprecated: auto_detect_line_endings is deprecated in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/CSV.php on line 249
Loading WorkSheet #3 using configurable filter for headings row 1 and for rows 202 to 301

Deprecated: auto_detect_line_endings is deprecated in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/CSV.php on line 249

3 worksheets loaded

Worksheet #0 -> Country Data #1
array(101) { [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.52845500000000100726538221351802349090576171875) ["D"]=> float(69.1717029999999937217580736614763736724853515625) } [3]=> array(4) { ["A"]=> string(6) "Tirane" ["B"]=> string(7) "Albania" ["C"]=> float(41.3299999999999982946974341757595539093017578125) ["D"]=> float(19.82000000000000028421709430404007434844970703125) } [4]=> array(4) { ["A"]=> string(7) "Algiers" ["B"]=> string(7) "Algeria" ["C"]=> float(36.7528870000000011941665434278547763824462890625) ["D"]=> float(3.042047999999999863263155930326320230960845947265625) } [5]=> array(4) { ["A"]=> string(9) "Pago Pago" ["B"]=> string(14) "American Samoa" ["C"]=> float(-14.2793299999999998561861502821557223796844482421875) ["D"]=> float(-170.70089699999999766077962704002857208251953125) } [6]=> array(4) { ["A"]=> string(16) "Andorra la Vella" ["B"]=> string(7) "Andorra" ["C"]=> float(42.507531000000000176441972143948078155517578125) ["D"]=> float(1.5218160000000000575681724512833170592784881591796875) } [7]=> array(4) { ["A"]=> string(6) "Luanda" ["B"]=> string(6) "Angola" ["C"]=> float(-8.8383330000000004389448804431594908237457275390625) ["D"]=> float(13.234443999999999874717104830779135227203369140625) } [8]=> array(4) { ["A"]=> string(12) "Buenos Aires" ["B"]=> string(9) "Argentina" ["C"]=> float(-34.608417000000002872184268198907375335693359375) ["D"]=> float(-58.37316100000000318459569825790822505950927734375) } [9]=> array(4) { ["A"]=> string(7) "Yerevan" ["B"]=> string(7) "Armenia" ["C"]=> float(40.18333299999999752571966382674872875213623046875) ["D"]=> float(44.5166669999999982110239216126501560211181640625) } [10]=> array(4) { ["A"]=> string(10) "Oranjestad" ["B"]=> string(5) "Aruba" ["C"]=> float(12.5245800000000002683009370230138301849365234375) ["D"]=> float(-70.0264590000000026748239179141819477081298828125) } [11]=> array(4) { ["A"]=> string(8) "Canberra" ["B"]=> string(9) "Australia" ["C"]=> float(-35.30749999999999744204615126363933086395263671875) ["D"]=> float(149.1244169999999940046109259128570556640625) } [12]=> array(4) { ["A"]=> string(6) "Vienna" ["B"]=> string(7) "Austria" ["C"]=> float(48.20833300000000321006154990755021572113037109375) ["D"]=> float(16.37305599999999827787178219296038150787353515625) } [13]=> array(4) { ["A"]=> string(4) "Baku" ["B"]=> string(10) "Azerbaijan" ["C"]=> float(40.37957099999999854844645597040653228759765625) ["D"]=> float(49.89123299999999971987563185393810272216796875) } [14]=> array(4) { ["A"]=> string(6) "Nassau" ["B"]=> string(7) "Bahamas" ["C"]=> float(25.059999999999998721023075631819665431976318359375) ["D"]=> float(-77.344999999999998863131622783839702606201171875) } [15]=> array(4) { ["A"]=> string(6) "Manama" ["B"]=> string(7) "Bahrain" ["C"]=> float(26.216667000000001053194864653050899505615234375) ["D"]=> float(50.58333300000000321006154990755021572113037109375) } [16]=> array(4) { ["A"]=> string(5) "Dhaka" ["B"]=> string(10) "Bangladesh" ["C"]=> float(23.70992100000000135651134769432246685028076171875) ["D"]=> float(90.4071430000000049176378524862229824066162109375) } [17]=> array(4) { ["A"]=> string(10) "Bridgetown" ["B"]=> string(8) "Barbados" ["C"]=> float(13.09611100000000050158632802776992321014404296875) ["D"]=> float(-59.6083330000000017889760783873498439788818359375) } [18]=> array(4) { ["A"]=> string(5) "Minsk" ["B"]=> string(7) "Belarus" ["C"]=> float(53.89999999999999857891452847979962825775146484375) ["D"]=> float(27.566666999999998921566657372750341892242431640625) } [19]=> array(4) { ["A"]=> string(8) "Brussels" ["B"]=> string(7) "Belgium" ["C"]=> float(50.84628099999999761848812340758740901947021484375) ["D"]=> float(4.35472699999999957043428366887383162975311279296875) } [20]=> array(4) { ["A"]=> string(8) "Belmopan" ["B"]=> string(6) "Belize" ["C"]=> float(17.251388999999999640522219124250113964080810546875) ["D"]=> float(-88.766943999999995185135048814117908477783203125) } [21]=> array(4) { ["A"]=> string(7) "Thimphu" ["B"]=> string(6) "Bhutan" ["C"]=> float(27.466667000000001053194864653050899505615234375) ["D"]=> float(89.6416669999999982110239216126501560211181640625) } [22]=> array(4) { ["A"]=> string(6) "La Paz" ["B"]=> string(7) "Bolivia" ["C"]=> float(-16.49900999999999839928932487964630126953125) ["D"]=> float(-68.1462479999999999336068867705762386322021484375) } [23]=> array(4) { ["A"]=> string(8) "Sarajevo" ["B"]=> string(22) "Bosnia and Herzegovina" ["C"]=> float(43.84759999999999990905052982270717620849609375) ["D"]=> float(18.35640000000000071622707764618098735809326171875) } [24]=> array(4) { ["A"]=> string(8) "Gaborone" ["B"]=> string(8) "Botswana" ["C"]=> float(-24.654109999999999303099684766493737697601318359375) ["D"]=> float(25.908739000000000629597707302309572696685791015625) } [25]=> array(4) { ["A"]=> string(8) "Brasilia" ["B"]=> string(6) "Brazil" ["C"]=> float(-15.780148000000000507725417264737188816070556640625) ["D"]=> float(-47.9291699999999991632648743689060211181640625) } [26]=> array(4) { ["A"]=> string(9) "Road Town" ["B"]=> string(22) "British Virgin Islands" ["C"]=> float(18.433333000000001078433342627249658107757568359375) ["D"]=> float(-64.616667000000006737536750733852386474609375) } [27]=> array(4) { ["A"]=> string(19) "Bandar Seri Begawan" ["B"]=> string(17) "Brunei Darussalam" ["C"]=> float(4.94310000000000027142732506035827100276947021484375) ["D"]=> float(114.9424999999999954525264911353588104248046875) } [28]=> array(4) { ["A"]=> string(5) "Sofia" ["B"]=> string(8) "Bulgaria" ["C"]=> float(42.6976259999999996352926245890557765960693359375) ["D"]=> float(23.322283999999999792862581671215593814849853515625) } [29]=> array(4) { ["A"]=> string(11) "Ouagadougou" ["B"]=> string(12) "Burkina Faso" ["C"]=> float(12.3646370000000000999307303573004901409149169921875) ["D"]=> float(-1.533863999999999894185975790605880320072174072265625) } [30]=> array(4) { ["A"]=> string(9) "Bujumbura" ["B"]=> string(7) "Burundi" ["C"]=> float(-3.3613780000000001990656528505496680736541748046875) ["D"]=> float(29.359877999999998365865394589491188526153564453125) } [31]=> array(4) { ["A"]=> string(10) "Phnom Penh" ["B"]=> string(8) "Cambodia" ["C"]=> float(11.550000000000000710542735760100185871124267578125) ["D"]=> float(104.9166670000000038953658076934516429901123046875) } [32]=> array(4) { ["A"]=> string(7) "Yaounde" ["B"]=> string(8) "Cameroon" ["C"]=> float(3.866667000000000076198602982913143932819366455078125) ["D"]=> float(11.5166669999999999873807610129006206989288330078125) } [33]=> array(4) { ["A"]=> string(6) "Ottawa" ["B"]=> string(6) "Canada" ["C"]=> float(45.42349399999999803867467562668025493621826171875) ["D"]=> float(-75.697933000000006131813279353082180023193359375) } [34]=> array(4) { ["A"]=> string(5) "Praia" ["B"]=> string(10) "Cape Verde" ["C"]=> float(14.9208330000000000126192389870993793010711669921875) ["D"]=> float(-23.50833300000000036789060686714947223663330078125) } [35]=> array(4) { ["A"]=> string(11) "George Town" ["B"]=> string(14) "Cayman Islands" ["C"]=> float(19.28693200000000018690116121433675289154052734375) ["D"]=> float(-81.3674390000000045120032154954969882965087890625) } [36]=> array(4) { ["A"]=> string(6) "Bangui" ["B"]=> string(24) "Central African Republic" ["C"]=> float(4.36169799999999963091568133677355945110321044921875) ["D"]=> float(18.555975000000000108002495835535228252410888671875) } [37]=> array(4) { ["A"]=> string(9) "N'Djamena" ["B"]=> string(4) "Chad" ["C"]=> float(12.1047969999999995849293554783798754215240478515625) ["D"]=> float(15.0445060000000001565467755426652729511260986328125) } [38]=> array(4) { ["A"]=> string(8) "Santiago" ["B"]=> string(5) "Chile" ["C"]=> float(-33.4253599999999977399056660942733287811279296875) ["D"]=> float(-70.5664660000000054651536629535257816314697265625) } [39]=> array(4) { ["A"]=> string(7) "Beijing" ["B"]=> string(5) "China" ["C"]=> float(39.9046670000000034406184568069875240325927734375) ["D"]=> float(116.408197999999998728526406921446323394775390625) } [40]=> array(4) { ["A"]=> string(6) "Bogota" ["B"]=> string(8) "Colombia" ["C"]=> float(4.647301999999999821966412127949297428131103515625) ["D"]=> float(-74.0962679999999949131961329840123653411865234375) } [41]=> array(4) { ["A"]=> string(6) "Moroni" ["B"]=> string(7) "Comoros" ["C"]=> float(-11.71721600000000051977622206322848796844482421875) ["D"]=> float(43.2473150000000003956301952712237834930419921875) } [42]=> array(4) { ["A"]=> string(11) "Brazzaville" ["B"]=> string(5) "Congo" ["C"]=> float(-4.2666669999999999873807610129006206989288330078125) ["D"]=> float(15.2833330000000007231619747471995651721954345703125) } [43]=> array(4) { ["A"]=> string(8) "San Jose" ["B"]=> string(10) "Costa Rica" ["C"]=> float(9.9333329999999993020765032269991934299468994140625) ["D"]=> float(-84.0833329999999961046341923065483570098876953125) } [44]=> array(4) { ["A"]=> string(12) "Yamoussoukro" ["B"]=> string(13) "Cote d'Ivoire" ["C"]=> float(6.81666699999999980974507707287557423114776611328125) ["D"]=> float(-5.28333299999999983498355504707433283329010009765625) } [45]=> array(4) { ["A"]=> string(6) "Zagreb" ["B"]=> string(7) "Croatia" ["C"]=> float(45.81491199999999963665686664171516895294189453125) ["D"]=> float(15.9785149999999998016164681757800281047821044921875) } [46]=> array(4) { ["A"]=> string(6) "Havana" ["B"]=> string(4) "Cuba" ["C"]=> float(23.13333300000000036789060686714947223663330078125) ["D"]=> float(-82.366667000000006737536750733852386474609375) } [47]=> array(4) { ["A"]=> string(7) "Nicosia" ["B"]=> string(6) "Cyprus" ["C"]=> float(35.16666699999999678993845009244978427886962890625) ["D"]=> float(33.36666699999999963210939313285052776336669921875) } [48]=> array(4) { ["A"]=> string(6) "Prague" ["B"]=> string(14) "Czech Republic" ["C"]=> float(50.0878110000000020818333723582327365875244140625) ["D"]=> float(14.4204600000000002779643182293511927127838134765625) } [49]=> array(4) { ["A"]=> string(8) "Kinshasa" ["B"]=> string(5) "Congo" ["C"]=> float(-4.32500000000000017763568394002504646778106689453125) ["D"]=> float(15.322222000000000008412825991399586200714111328125) } [50]=> array(4) { ["A"]=> string(10) "Copenhagen" ["B"]=> string(7) "Denmark" ["C"]=> float(55.6762939999999986184775480069220066070556640625) ["D"]=> float(12.568115999999999843339537619613111019134521484375) } [51]=> array(4) { ["A"]=> string(8) "Djibouti" ["B"]=> string(8) "Djibouti" ["C"]=> float(11.5879999999999991899812812334857881069183349609375) ["D"]=> float(43.14500000000000312638803734444081783294677734375) } [52]=> array(4) { ["A"]=> string(6) "Roseau" ["B"]=> string(8) "Dominica" ["C"]=> float(15.301389000000000351064954884350299835205078125) ["D"]=> float(-61.3883330000000029258444556035101413726806640625) } [53]=> array(4) { ["A"]=> string(13) "Santo Domingo" ["B"]=> string(18) "Dominican Republic" ["C"]=> float(18.5) ["D"]=> float(-69.9833330000000017889760783873498439788818359375) } [54]=> array(4) { ["A"]=> string(4) "Dili" ["B"]=> string(10) "East Timor" ["C"]=> float(-8.5666670000000006979234967730008065700531005859375) ["D"]=> float(125.56666699999999536885297857224941253662109375) } [55]=> array(4) { ["A"]=> string(5) "Quito" ["B"]=> string(7) "Ecuador" ["C"]=> float(-0.2294980000000000075477402106116642244160175323486328125) ["D"]=> float(-78.5242769999999978836058289743959903717041015625) } [56]=> array(4) { ["A"]=> string(5) "Cairo" ["B"]=> string(5) "Egypt" ["C"]=> float(30.064741999999998967041392461396753787994384765625) ["D"]=> float(31.249508999999999758756530354730784893035888671875) } [57]=> array(4) { ["A"]=> string(12) "San Salvador" ["B"]=> string(11) "El Salvador" ["C"]=> float(13.6899999999999995026200849679298698902130126953125) ["D"]=> float(-89.1900030000000043628460844047367572784423828125) } [58]=> array(4) { ["A"]=> string(6) "Malabo" ["B"]=> string(17) "Equatorial Guinea" ["C"]=> float(3.75) ["D"]=> float(8.7833330000000007231619747471995651721954345703125) } [59]=> array(4) { ["A"]=> string(6) "Asmara" ["B"]=> string(7) "Eritrea" ["C"]=> float(15.3323599999999995446842149249278008937835693359375) ["D"]=> float(38.9261699999999990495780366472899913787841796875) } [60]=> array(4) { ["A"]=> string(7) "Tallinn" ["B"]=> string(7) "Estonia" ["C"]=> float(59.438862000000000307409209199249744415283203125) ["D"]=> float(24.75447199999999980946085997857153415679931640625) } [61]=> array(4) { ["A"]=> string(11) "Addis Ababa" ["B"]=> string(8) "Ethiopia" ["C"]=> float(9.0227360000000000894715412869118154048919677734375) ["D"]=> float(38.74679900000000287718648905865848064422607421875) } [62]=> array(4) { ["A"]=> string(7) "Stanley" ["B"]=> string(16) "Falkland Islands" ["C"]=> float(-51.7009809999999987439878168515861034393310546875) ["D"]=> float(-57.84919000000000011141310096718370914459228515625) } [63]=> array(4) { ["A"]=> string(8) "Torshavn" ["B"]=> string(13) "Faroe Islands" ["C"]=> float(62.017707000000001471562427468597888946533203125) ["D"]=> float(-6.7718790000000002038405000348575413227081298828125) } [64]=> array(4) { ["A"]=> string(4) "Suva" ["B"]=> string(4) "Fiji" ["C"]=> float(-18.141600000000000392219590139575302600860595703125) ["D"]=> float(178.441900000000003956301952712237834930419921875) } [65]=> array(4) { ["A"]=> string(8) "Helsinki" ["B"]=> string(7) "Finland" ["C"]=> float(60.16981299999999777128323330543935298919677734375) ["D"]=> float(24.93824000000000040699887904338538646697998046875) } [66]=> array(4) { ["A"]=> string(5) "Paris" ["B"]=> string(6) "France" ["C"]=> float(48.8566670000000016216290532611310482025146484375) ["D"]=> float(2.350986999999999937926986603997647762298583984375) } [67]=> array(4) { ["A"]=> string(7) "Cayenne" ["B"]=> string(13) "French Guiana" ["C"]=> float(4.92269999999999985362819643341936171054840087890625) ["D"]=> float(-52.32690000000000196678229258395731449127197265625) } [68]=> array(4) { ["A"]=> string(7) "Papeete" ["B"]=> string(16) "French Polynesia" ["C"]=> float(-17.535021000000000412910594604909420013427734375) ["D"]=> float(-149.56959499999999252395355142652988433837890625) } [69]=> array(4) { ["A"]=> string(10) "Libreville" ["B"]=> string(5) "Gabon" ["C"]=> float(0.3908409999999999939745976007543504238128662109375) ["D"]=> float(9.453644000000000602312866249121725559234619140625) } [70]=> array(4) { ["A"]=> string(6) "Banjul" ["B"]=> string(6) "Gambia" ["C"]=> float(13.453056000000000125282895169220864772796630859375) ["D"]=> float(-16.5775000000000005684341886080801486968994140625) } [71]=> array(4) { ["A"]=> string(8) "T'bilisi" ["B"]=> string(7) "Georgia" ["C"]=> float(41.716667000000001053194864653050899505615234375) ["D"]=> float(44.783332999999998946805135346949100494384765625) } [72]=> array(4) { ["A"]=> string(6) "Berlin" ["B"]=> string(7) "Germany" ["C"]=> float(52.523404999999996789483702741563320159912109375) ["D"]=> float(13.4114000000000004320099833421409130096435546875) } [73]=> array(4) { ["A"]=> string(5) "Accra" ["B"]=> string(5) "Ghana" ["C"]=> float(5.5557169999999995724238033290021121501922607421875) ["D"]=> float(-0.1963060000000000082653883737293654121458530426025390625) } [74]=> array(4) { ["A"]=> string(6) "Athens" ["B"]=> string(6) "Greece" ["C"]=> float(37.9791799999999994952304405160248279571533203125) ["D"]=> float(23.716646999999998257635525078512728214263916015625) } [75]=> array(4) { ["A"]=> string(4) "Nuuk" ["B"]=> string(9) "Greenland" ["C"]=> float(64.1836200000000047793946578167378902435302734375) ["D"]=> float(-51.7214069999999992433004081249237060546875) } [76]=> array(4) { ["A"]=> string(11) "Basse-Terre" ["B"]=> string(10) "Guadeloupe" ["C"]=> float(15.998502999999999474312062375247478485107421875) ["D"]=> float(-61.7220200000000005502442945726215839385986328125) } [77]=> array(4) { ["A"]=> string(9) "Guatemala" ["B"]=> string(9) "Guatemala" ["C"]=> float(14.641389000000000208956407732330262660980224609375) ["D"]=> float(-90.513056000000005951733328402042388916015625) } [78]=> array(4) { ["A"]=> string(14) "St. Peter Port" ["B"]=> string(8) "Guernsey" ["C"]=> float(49.45885799999999932197169982828199863433837890625) ["D"]=> float(-2.53475200000000011613110473263077437877655029296875) } [79]=> array(4) { ["A"]=> string(7) "Conakry" ["B"]=> string(6) "Guinea" ["C"]=> float(9.537029000000000422687662648968398571014404296875) ["D"]=> float(-13.678470000000000794670995674096047878265380859375) } [80]=> array(4) { ["A"]=> string(6) "Bissau" ["B"]=> string(13) "Guinea-Bissau" ["C"]=> float(11.86666699999999963210939313285052776336669921875) ["D"]=> float(-15.5999999999999996447286321199499070644378662109375) } [81]=> array(4) { ["A"]=> string(10) "Georgetown" ["B"]=> string(6) "Guyana" ["C"]=> float(6.80461100000000040921577237895689904689788818359375) ["D"]=> float(-58.15483100000000149520928971469402313232421875) } [82]=> array(4) { ["A"]=> string(14) "Port-au-Prince" ["B"]=> string(5) "Haiti" ["C"]=> float(18.539269000000000886529960553161799907684326171875) ["D"]=> float(-72.3364080000000058134901337325572967529296875) } [83]=> array(4) { ["A"]=> string(11) "Tegucigalpa" ["B"]=> string(8) "Honduras" ["C"]=> float(14.082053999999999405190465040504932403564453125) ["D"]=> float(-87.2062849999999940564521239139139652252197265625) } [84]=> array(4) { ["A"]=> string(8) "Budapest" ["B"]=> string(7) "Hungary" ["C"]=> float(47.4984060000000027912392397411167621612548828125) ["D"]=> float(19.040758000000000293994162348099052906036376953125) } [85]=> array(4) { ["A"]=> string(9) "Reykjavik" ["B"]=> string(7) "Iceland" ["C"]=> float(64.1353380000000043992258724756538867950439453125) ["D"]=> float(-21.89520999999999872898115427233278751373291015625) } [86]=> array(4) { ["A"]=> string(9) "New Delhi" ["B"]=> string(5) "India" ["C"]=> float(28.635307999999998429530023713596165180206298828125) ["D"]=> float(77.2249599999999958299667923711240291595458984375) } [87]=> array(4) { ["A"]=> string(7) "Jakarta" ["B"]=> string(9) "Indonesia" ["C"]=> float(-6.211543999999999954297891235910356044769287109375) ["D"]=> float(106.8451720000000051413735491223633289337158203125) } [88]=> array(4) { ["A"]=> string(6) "Tehran" ["B"]=> string(4) "Iran" ["C"]=> float(35.69621599999999972396835801191627979278564453125) ["D"]=> float(51.422944999999998572093318216502666473388671875) } [89]=> array(4) { ["A"]=> string(7) "Baghdad" ["B"]=> string(4) "Iraq" ["C"]=> float(33.31569999999999964757080306299030780792236328125) ["D"]=> float(44.392200000000002546585164964199066162109375) } [90]=> array(4) { ["A"]=> string(6) "Dublin" ["B"]=> string(7) "Ireland" ["C"]=> float(53.3441040000000015197656466625630855560302734375) ["D"]=> float(-6.26749400000000012056489140377379953861236572265625) } [91]=> array(4) { ["A"]=> string(9) "Jerusalem" ["B"]=> string(6) "Israel" ["C"]=> float(31.78569999999999851070242584683001041412353515625) ["D"]=> float(35.2006999999999976580511429347097873687744140625) } [92]=> array(4) { ["A"]=> string(4) "Rome" ["B"]=> string(5) "Italy" ["C"]=> float(41.89546599999999898500391282141208648681640625) ["D"]=> float(12.4823240000000001970192897715605795383453369140625) } [93]=> array(4) { ["A"]=> string(8) "Kingston" ["B"]=> string(7) "Jamaica" ["C"]=> float(17.99273099999999914189174887724220752716064453125) ["D"]=> float(-76.7920089999999930796548142097890377044677734375) } [94]=> array(4) { ["A"]=> string(10) "St. Helier" ["B"]=> string(6) "Jersey" ["C"]=> float(49.19027799999999928104443824850022792816162109375) ["D"]=> float(-2.108610999999999791043592267669737339019775390625) } [95]=> array(4) { ["A"]=> string(5) "Amman" ["B"]=> string(6) "Jordan" ["C"]=> float(31.95657800000000037243808037601411342620849609375) ["D"]=> float(35.9456950000000006184563972055912017822265625) } [96]=> array(4) { ["A"]=> string(6) "Astana" ["B"]=> string(10) "Kazakhstan" ["C"]=> float(51.10000000000000142108547152020037174224853515625) ["D"]=> float(71.2999999999999971578290569595992565155029296875) } [97]=> array(4) { ["A"]=> string(7) "Nairobi" ["B"]=> string(5) "Kenya" ["C"]=> string(6) "-01.17" ["D"]=> float(36.47999999999999687361196265555918216705322265625) } [98]=> array(4) { ["A"]=> string(6) "Tarawa" ["B"]=> string(8) "Kiribati" ["C"]=> string(5) "01.30" ["D"]=> float(173) } [99]=> array(4) { ["A"]=> string(5) "Seoul" ["B"]=> string(11) "South Korea" ["C"]=> float(37.31000000000000227373675443232059478759765625) ["D"]=> float(126.5799999999999982946974341757595539093017578125) } [100]=> array(4) { ["A"]=> string(11) "Kuwait City" ["B"]=> string(6) "Kuwait" ["C"]=> float(29.300000000000000710542735760100185871124267578125) ["D"]=> float(48) } [101]=> array(4) { ["A"]=> string(7) "Bishkek" ["B"]=> string(10) "Kyrgyzstan" ["C"]=> float(42.53999999999999914734871708787977695465087890625) ["D"]=> float(74.4599999999999937472239253111183643341064453125) } }
Worksheet #1 -> Country Data #2
array(1) { [1]=> array(1) { ["A"]=> NULL } }
Worksheet #2 -> Country Data #3
array(1) { [1]=> array(1) { ["A"]=> NULL } }