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