Jerin jerin abubuwan tsara kasa zuwa Google Earth, daga Excel, dauke da hoto da kuma rubutu mai wadatacce

Wannan misali ne na yadda Excel zata iya aika abun ciki zuwa Google Earth. Shari'ar ita ce:

Muna da jerin haɗin kai a cikin tsarin yanayin ƙasa (lat / lon). Muna so mu aika zuwa Google Earth, kuma muna so a can don nuna lambar maɓallin sha'awa, rubutu a sarari, rubutu mai bayyanawa, hoto na maɓallin da maɓallin haɗin yanar gizo don buɗe shafi a Intanet.

Wadannan su ne misalin abin da muke fata mu nuna ta danna kan mahaɗin:

Lambar ita ce: XL-3458

Length:

-103.377499

Latitude:

20.654443

Kuma wannan shine abinda muke fata ganin:


XL-3458

Tsarin tsakiya

Mista Joaquín Gómez gidan mahaifin, inda Jami'ar {asa ta farko ta kasance, kuma yanzu an sake mayar da shi a matsayin kayan kare kayan gargajiya ta Cibiyar Nazarin Harkokin Kifi.

Duba shafin yanar gizon


Kodayake samfurin za a aika, ruhun labarin shine bayyana yadda za ayi shi akan kansa.

Abinda muke ciki shine ƙirƙirar alamun html a cikin ginshiƙai daban don samun damar haɗawa: Lambar wannan zai zama:

Tsarin tsakiya
Mista Joaquín Gómez gidan mahaifin, inda Jami'ar {asa ta farko ta kasance, kuma yanzu an sake mayar da shi a matsayin kayan kare kayan gargajiya ta Cibiyar Nazarin Harkokin Kifi.

<img src=»http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg»Width =»144»Height =»168«>

<a href=»http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg«>Duba shafin yanar gizon

Duk alamun cewa sune don nuna cewa layi ne na daban, yana rufe tare da wanda yayi daidai da Shiga ciki.

Bayan haka lakabi ne don nuna cewa wannan rubutun yana cikin haske, tabbas yana rufe shi da

im shi ne alama don hoton, wanda ke ɗauke da kaddarorin kamar nisa (nisa), tsawo (tsawo) da adireshin inda hoton yake (src)

A ƙarshe akwai alamar don haɗin haɗin, wanda ya buɗe tare da

Alamar a purple yana da abun ciki wanda zai canza tare da kowane hoton, saboda haka za mu sha'awar barin shi a cikin kwayoyin halitta.

Ba tare da komawa mai yawa ba, za ka iya ganin cewa aikin da za a yi tare da shi zai kasance kamar wani abu kamar haka:

= SANTAWA(,CELDA,,CELDA,,CELDA,<img src=»,CELDA,»Width =»,CELDA,»Height =»,CELDA,«><a href=»,CELDA,«>,CELDA,)

Wanda hakan ke nuna cewa zamu mamaye ginshikai 8 don adana duk bayanan da muke son nunawa. Kodayake game da waɗanda suke da alamun da ke amfani da = alama da maganganu biyu, yana da wahala a gare mu saboda a cikin Excel na farko yana nuna aiki kuma ana amfani da na biyu don raba abubuwan rubutu. Ana warware wannan ta hanyar sanya waɗancan abubuwan a cikin ɗakuna daban kamar suna rubutu.

A karshe muna da wannan:

lat lon google duniya

Kuma in aika zuwa Google Earth Na sanya maɓallin da ke haifar da fayil.  lat lon google duniyaA can ka saka hanyar inda fayil ɗin yake da kuma sunan da muke sa ran za mu yi bayanin kilomita idan an nuna shi a cikin hagu.

Samfurin yana da wasu alamu game da shawagi akan sel don bayar da shawarar yadda yakamata a shigar da bayanan. Gabaɗaya, yakan zama yana da matsala yayin da ba'a kunna macros ba kuma lokacin da hanyar da ake ƙirƙirar fayil ɗin ba za a iya rubutawa ba.

A nan muna da shi, zaku iya bincika ta hanyar code a cikin labarun gefe na Google Earth, kuma danna kan batun yana nuna kamar yadda muke sa ran.

lat lon google duniya

 

latin zuwa google downloads DownloadsSauke misali kml

Yana buƙatar gudummawa ta alama don saukarwa, wanda zaku iya yi da shi Paypal ko katin bashi.

Shi ne m la'akari da darajar da shi na samar da sauƙi da wanda za ka iya saya.

 

 


 

Koyi yadda ake yin wannan da sauran samfura a cikin Excel-CAD-GIS hanya mai cuta.


 

Matsaloli masu yawa

Zai yiwu cewa, yayin amfani da aikace-aikacen, ɗayan abubuwan da ke faruwa zasu iya bayyana:


Kuskuren 75 - Hanyar fayil.

Wannan yana faruwa saboda hanyar da aka ƙayyade inda fayil din km zai sami ceto ba shi da damar ko babu izini don wannan aikin.

Da kyau, ya kamata ka sanya hanya a kan diski D, wanda ke da ƙuntatawa kaɗan fiye da diski C. Misali:

D: \

Matakan suna fitowa a arewacin iyaka.

Wannan yakan faru, saboda a cikin windows ɗinmu, kamar yadda aka nuna a cikin umarni don samfurin don aiki, dole ne a kafa daidaitattun yanki a cikin rukunin yanki:

  • -Wa'ayi, don masu rabawa na adadi
  • -Coma, ga dubban masu rabawa
  • -Coma, don masu rabawa

Saboda haka, bayanai kamar: Miliyan dari bakwai da tamanin da mita goma sha biyu ya kamata a gani kamar 1,780.12

Hoton yana nuna yadda ake aiwatar da wannan sanyi.

Wannan wani hoton ne wanda yake nuna sanyi a cikin kulawar kulawa.

Da zarar an sauya canji, an sake samar da fayil kuma sannan, maki zasu bayyana inda ya dace a Google Earth.

 

Idan kuna da tambaya, rubuta zuwa ga imel ɗin tallafi edita@geofumadas.com. A koyaushe yana nuna sigar windows da kuke amfani da ita.

22 Amsawa zuwa "Aika jerin jeri na tsara bayanai zuwa Google Earth, daga Excel, dauke da hoto da wadataccen rubutu"

  1. Na riga na zazzage samfurin, zan yi nazarinsa kuma zan rubuta kowane tambayoyi ko gyare-gyare. Godiya g '

  2. Babu wata hanyar sadarwa ta bayyana don biyan kuɗi ta hanyar hanyar banki. Ni daga El Salvador. Na gode.

  3. Ina so in saya samfuri amma ba ni da katin kamar na yi

  4. Duba, yaya amincin kake sanya murfin sama? Wannan misali:
    D: obrasalc

  5. Sauke fayiloli na Excel, kuma ina da matsaloli wajen aika hotunan daga faifai na D: / ayyukan / alc, don Allah za ku aiko mani bayani game da yadda zan iya upload hotuna daga wannan adireshin.
    Shin hotuna suna da takamaiman girman? ko za ku iya aiki tare da hotunan 4 mb

  6. Ee, hakika zaka iya gano hanyoyin gida a kwamfuta ko cibiyar sadarwa

  7. yana yiwuwa a karanta hotuna da aka ajiye a gida a kan PC ko ta amfani da tafiyar da cibiyar sadarwa. Na gode

  8. Shin wannan aikin zai iya karanta hotunan da aka ajiye a gida ba tare da amfani da URL ba?

  9. Barka dai, ina sha'awar siyan samfuran ka.ina daga Peru ne, amma idan na danna mahadar canja wurin asusun banki, ban sami komai kamar Aug da zan sanya kudin ka ba.

  10. Mun yi nadama da abin da ya faru, amma mun riga mun biya shi kuma an riga an kunna tsarin biya.

    Na gode.

  11. Ina so in biya bashi da yawa daga cikin tsare-tsaren da suke nan kuma ba zan iya ba

  12. Ee.
    Macro ba shi da maɓallin kariya don haka za'a iya canza shi.

  13. Saukewa ya haɗa da ikon canza tsarin fayil ko babban macro na shirin a cikin tarin.

  14. Ba daidai ba ne gameda cin nasara, yana da cewa an cire siffar Google

  15. Lalle ne, tarihin da na ke cikin Google Earth shine WGS84.
    Shin kun gano dalili na rashin nasarar tare da bayanai na?

  16. Aika su zuwa mail don ganin su. Aika mini tebur a cikin Excel da fayil ɗin kml da yake samarwa. editor@geofumadas.com

    Bincika idan kana amfani da Datum masu amfani, Google Earth yana amfani da UTM WGS84.

  17. Na gode da saurin a cikin maganin wanda yayi aiki. Koyaya, lokacin da na gudanar da fayil ɗin «kml» tare da Google Earth, kusan babu ɗayan abubuwan daidaitawa da suka bayyana kuma kaɗan ne kawai ake gani, kusan ko da yaushe 1º da na ƙarshe na jerin, amma ya yi nisa da abin da ya dace (100 Kms. Pe. Pe ). Na gaji da yin gwaje-gwaje kuma babu komai. Zan iya aiko maka da fayil din tare da bayanan da aka tura wa wasu imel? Don haka zaku ga abin da ya faru. Na gode

  18. Wannan matsala ce da aka sani, kamar yadda aka rubuta a sama.
    Canza hanyar, ana saka fayil ɗin da za a ƙirƙira kai tsaye a C: kuma galibi ba sa izinin saitin Windows. Yi amfani da wata hanyar kuma ka tabbata akwai shi.

  19. Shirin yana da kyau kuma ina da wahala lokacin gano shi.
    Na samu a kan biyan kuɗin 2 $ amma sai ya juya cewa lokacin da nake gudana ba ya aiki kuma sanarwa ya ce:
    'Kuskure' 75 'ya faru a lokacin gudu.
    Kuskure ga samun hanyar ko fayil »
    Ina godiya idan zaka iya gaya mani yadda za a warware shi ko kuma idan ka aiko mani wani takarda Excel, da wuri-wuri, saboda dole in shirya aiki na wakiltar wurare na gefe kuma na yi latti.
    Na gode,

  20. Ya dogara ne da maye gurbin.

    Idan suna gudun hijira aan mitoci (10 zuwa 15 mita) shi ne saboda an goge hoton google, zaku ga yana canza hoton zuwa shekarun da suka gabata kuma zaku ga cewa yanayin ƙasa ba shi da kyau. Kodayake daidaitawa daidai ne.

    Idan fitarwa sun fi girma, zai iya zama cewa su masu haɓakar wani Datum ne. Google yana amfani da WGS84.

    Idan masu gudanarwa suka fadi a wani yanki na duniyar, zai iya kasancewa kuna shiga latti da latti zuwa baya. Ko kuma ba ku yin amfani da alamar ba: A cikin yammacin hemisphere canjin ba shi da kyau, a cikin kudu hemisphere latitude mara kyau ne.

  21. Gudummawa mai kyau kawai ku lura cewa lokacin da na sanya haɗin kai na ba zai nuna min daidai inda yake ba ... me yasa kuke tsammanin hakan zai kasance?

Barin amsa

Your email address ba za a buga.

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