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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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
}
}