Add
CartografiaGoogle Earth / Mapsfarko da ra'ayi

Saka taswira a cikin Excel - sami haɗin haɗin ƙasa - haɗin UTM

Map.XL wani aikace-aikacen da ke ba ka damar saka taswira a cikin Excel kuma samun daidaito kai tsaye daga taswirar. Hakanan zaka iya nuna jerin latitudes da tsawo a taswirar.

Yadda za a saka taswira a Excel

Da zarar an shigar da shirin, ana ƙara shi azaman ƙarin shafin da ake kira "Taswira", tare da ayyukan Map.XL.

Kafin shigar da taswirar dole ne ka saita taswirar baya, ana yin wannan a cikin gunkin "Map Provider". Yana yiwuwa a saita bayanan baya ta amfani da taswirori biyu, azaman hoto ko matasan sabis:

  • Google Duniya / Taswirai
  • Taswirar Bing
  • Bude Street Maps
  • ArcGIS
  • Yahoo
  • Yaro
  • Yandex

Taswirar yana nuna dama zuwa dama, amma za'a iya ja shi don yana iyo, ko kuma a kasa / saman kan tebur.

Wannan bidiyo ta taƙaita yadda ake aiwatar da dukan tsarin da aka bayyana a cikin wannan labarin, yayi aiki a kan shimfiɗar wani makirci ta amfani da Taswirar Bing azaman baya.

[ulp id='hIYBDKfRL58ddv8F']

Yadda za a sami daidaito daga Excel

Ana yin wannan tare da alamar "Samu daidaitawa". Ainihin tsarin shine:

  • Latsa "Sai A hankali,
  • Danna kan taswira,
  • Danna maɓallin Excel
  • Manna, ta amfani da "Ctrl + V", ko maɓallin linzamin kwamfuta na dama kuma zaɓi Manna.

Yadda za a yi lissafin Ma'aikata

Samfurin da aka nuna a misalin bidiyon, Geofumadas ya gina shi, kuma yana ba ka damar manna haɗin gwargwadon gwargwadon mai ganowa, don haka daga bisani zasu bi da layin latitude da tsawo.

MapXL kyauta ne, kuma zaka iya zazzage shi daga wannan mahaɗin. Hakanan zaku sauke tebur na Excel wanda aka yi amfani dashi a cikin misalin.

Aika haɗin kai zuwa taswirar.

Ana yin wannan tare da alamar “Ad markers”, bayan zaɓar yankin teburin da ke da sha'awa. Sa'an nan kuma wani nau'i ya bayyana yana nuna wane filin ne latitude, wanda shine Longitude, dalla-dalla na haɗin gwiwa da alamar taswirar. Don cire su kawai dole ne ku yi "Cire Alamomi".

Sauke nan Map.XL, ciki har da samfurin Excel.

[ulp id='hIYBDKfRL58ddv8F']

Wannan bidiyo yana nuna tsarin da aka bayyana a cikin wannan labarin, ta yin amfani da alamar alama ta yawon shakatawa a kan wani dutsen mai fitattun wuta, ta yin amfani da Open Street Maps a matsayin bango.

Dubi haɗin UTM akan taswira daga Excel:

Wannan aikin da aka nuna a sama yana nuna tsarawar ƙasa da za a iya gani daga taswirar Excel. Idan kuna son nuna abubuwan haɗin da suke cikin Universal Traverso Mercator (UTM) akan wannan taswirar, dole ne ku yi amfani da samfuri kamar wannan. Misalin da aka nuna a hoto da bidiyo yana yin hakan:

zaka iya samun samfurin a nan.

Golgi Alvarez

Marubuci, mai bincike, kwararre a cikin Samfuran Gudanar da Ƙasa. Ya halarci Conceptualization da aiwatar da model kamar: National System of Property Administration SINAP a Honduras, Model na Management of hadin gwiwa Municipalities a Honduras, Integrated Model na Cadastre Management - Registry a Nicaragua, System of Administration na Territory SAT a Colombia. . Editan shafin ilimin Geofumadas tun daga 2007 kuma mahaliccin Kwalejin AulaGEO wanda ya haɗa da darussa sama da 100 akan GIS - CAD - BIM - batutuwan Twins na Dijital.

shafi Articles

9 Comments

  1. Shin akwai wata hanyar bincika Suna ko Suna ??

  2. Sannu, Shin yana aiki daidai ne na Excel Office 365? Ba zan iya ganin Map shafin ba bayan shigar da shi.

    Gracias

  3. Sannu, ba a kunna hanyar haɗi don sauke map.xl ba.

  4. Sannu sir da safe.
    Na sauke samfuri amma babu hanyar haɗi don software kanta.
    Don Allah a iya taimakawa.
    gaisuwa

  5. Yaya zan iya sauke taswirar shirin.xl tare da samfuri mafi kyau

Deja un comentario

Your email address ba za a buga.

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.

Komawa zuwa maɓallin kewayawa