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, an kara shi kamar ƙarin shafin da ake kira "Map", tare da siffofin Map.XL.

Kafin saka taswirar dole ne ka saita taswirar bango, ana yin wannan a gunkin «mai ba da taswira». Zai yiwu a saita bango ta amfani da duka taswirori, hoto ko matasan daga 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.

Yadda za a sami daidaito daga Excel

Ana yin wannan tare da gunkin "Get coord" Hanyar ita ce mahimmanci:

  • Latsa «Get Coord,
  • Danna kan taswira,
  • Danna maɓallin Excel
  • Manna, ta amfani da «Ctrl V», ko maɓallin linzamin kwamfuta na dama da kuma zabi 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 gunkin «Ad alamomin», waɗanda aka zaɓi yankin teburin da kuke sha'awa. Sannan wani nau'i ya bayyana don nuna wane filin ne latitude, wanda shine Longitude, cikakken bayani game da daidaitawa da kuma alamar taswirar. Don cire su sai kawai kayi "Cire Alama".

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

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.

9 Amsawa zuwa "Saka taswira a cikin Excel - sami haɗin haɗin ƙasa - haɗin UTM"

  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.
    Da fatan za ku iya taimako.
    gaisuwa

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

Barin amsa

Your email address ba za a buga.

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