Помогите получить макросом из этого листа ексел другой как ниже лист пример приложен.
Вот такой.
Name | Type | Site | Radius | Wkt |
NameRoad1 | SpeedZone | All sites | 0 | POLYGON ((41.3627853393555 34.136905670166, 41.3781471252441 34.1369361877441, 41.3781471252441 34.1302757263184, 41.3775024414063 34.1302757263184)) |
NameRoad2 | SpeedZone | All sites | 0 | POLYGON ((41.448600769043 34.3206100463867, 41.4532089233398 34.3201904296875, 41.4495010375977 34.3047218322754)) |
NameRoad3 | SpeedZone | All sites | 0 | POLYGON ((41.8105697631836 34.8700790405273, 41.8064498901367 34.860481262207, 41.8038291931152 34.8593711853027, 41.8042602539063 34.8583106994629, 41.9526596069336 34.9177017211914)) |
NameRoad4 | SpeedZone | All sites | 21 | POINT (51.9247093200684 35.1282196044922) |
NameRoad5 | SpeedZone | All sites | 12 | POINT (41.4686889648438 34.0699195861816) |
ID | Name | Type | Site | Radius | Wkt | Longitude | Latitude |
1 | NameRoad1 | SpeedZone | All sites | 0 | POLYGON | 41.36279 | 34.13691 |
2 | NameRoad1 | SpeedZone | All sites | 0 | POLYGON | 41.37815 | 34.13694 |
3 | NameRoad1 | SpeedZone | All sites | 0 | POLYGON | 41.37815 | 34.13028 |
4 | NameRoad1 | SpeedZone | All sites | 0 | POLYGON | 41.37750 | 34.13028 |
1 | NameRoad2 | SpeedZone | All sites | 0 | POLYGON | 41.44860 | 34.32061 |
2 | NameRoad2 | SpeedZone | All sites | 0 | POLYGON | 41.45321 | 34.32019 |
3 | NameRoad2 | SpeedZone | All sites | 0 | POLYGON | 41.44950 | 34.30472 |
1 | NameRoad3 | SpeedZone | All sites | 0 | POLYGON | 41.81057 | 34.87008 |
2 | NameRoad3 | SpeedZone | All sites | 0 | POLYGON | 41.80645 | 34.86048 |
3 | NameRoad3 | SpeedZone | All sites | 0 | POLYGON | 41.80383 | 34.85937 |
4 | NameRoad3 | SpeedZone | All sites | 0 | POLYGON | 41.80426 | 34.85831 |
5 | NameRoad3 | SpeedZone | All sites | 0 | POLYGON | 41.95266 | 34.91770 |
1 | NameRoad4 | SpeedZone | All sites | 21 | POINT | 38.92471 | 35.12822 |
1 | NameRoad5 | SpeedZone | All sites | 12 | POINT | 41.46869 | 34.06992 |
Изменено: bkolubenka - 22.06.2018 11:09:37