Sanya taswira a Excel - samun haɗin gwargwado - Ƙungiyar 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 sakawa da taswirar dole ka tsara tsarin taswira, anyi wannan a cikin "Maƙalar Gida". Yana yiwuwa a daidaita bayanan ta amfani da taswira, hoto ko matasan daga ayyuka:

  • 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

Anyi wannan tare da icon "Get coordin". Hanyar ita ce m:

  • 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 sauke shi daga wannan mahadar. Har ila yau za ta sauke tebur na Excel da aka yi amfani dashi a misali.

Aika haɗin kai zuwa taswirar.

Anyi wannan tare da icon «Ad markers», tun da aka zaba yankin na teburin sha'awa. Bayan haka wani nau'i yana nuna alamar filin ne, wanda shine Length, bayanin cikakken bayani da kuma alamar taswirar. Don cire su sai kawai ku yi "Cire Alamar".

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 ya nuna haɗin gine-gine don nunawa daga taswira a Excel. Idan abin da kake so shine ya nuna a kan wannan taswirar taswirar dake cikin Universal Traverso Mercator (UTM), dole ne ka yi amfani da samfurin kamar wannan. Misalin da aka nuna a hoton da bidiyon yana yin haka:

zaka iya samun samfurin a nan.

8 yana nufin "Sanya taswira a Excel - samun haɗin gine-gine - haɗin UTM"

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

    Gracias

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

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

  4. 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.