Export jerin Google Earth Gwargwadon tsarawa daga Excel, Image da Rich Text

Wannan misali ne tare da Excel zaka iya aika abun ciki zuwa Google Earth. Shari'ar ita ce:

Muna da jerin jerin haɓakawa a cikin tsarin yanayin ƙasa (lat / lon). Muna so mu aika zuwa Google Earth, kuma muna so ya nuna lambar da mahimmancin sha'awa, rubutu a cikin m, rubutun bayanin, hoto na batu da kuma hyperlink don bude shafin a Intanit.

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.

Abin da muke yi shi ne ƙirƙirar takardun html a cikin ginshiƙai masu rarrafe domin su iya ƙaddarawa: Lambar wannan zai zama:

<p><Strong>Tsarin tsakiya</ strong></ p>
<p>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.</ p>
<p>

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

<p>

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

Duk kalmomin <p> suna nuna cewa yana da rabaccen layi, rufe tare da </ p> wanda ya dace da Shigar.

Sa'an nan kuma <karfi> alama ce ta nuna cewa wannan rubutu yana da ƙarfin hali, koda yake yana rufe shi tare da </ strong>

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 lakabin don hyperlink, wanda ya buɗe tare da <a href,ôôss gaba shine adireshin da rubutu da ke hade da hyperlink, kuma ya kusa da </a>

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(<p><karfi>,CELDA,</ strong></ p>,CELDA,<p>,CELDA,</ p> <p> <p><img src = ",CELDA,»Width =»,CELDA,»Height =»,CELDA,«></ p><p><p><a href = »,CELDA,«>,CELDA,</a></ p>)

Wannan yana nufin, cewa za mu mallaki ginshiƙan 8 don adana duk bayanan da muke so mu nuna. Kodayake a cikin sha'anin wadanda suke da alamun da suke amfani da alamar = da saukewa biyu suna da wuya a Excel sannan na farko ya nuna aiki kuma ana amfani da na biyu don raba abubuwan da ke cikin rubutu. An warware wannan ta hanyar ajiye abubuwan nan a cikin sassan daban-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 alamomi lokacin da motsi da linzamin kwamfuta a kan sel don bayar da shawarar yadda za a shigar da bayanai. Gaba ɗaya yana da matsala yayin da macros ba a kunna ba kuma lokacin da aka sanya fayil din ba shi da hakkin yin rubutu.

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 taimako na musamman don saukewa, wanda zaka iya yi tare Paypal ko katin bashi.

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


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.

Ya dace, shi ne sanya hanya a kan faifai D, wanda yana da ƙananan ƙuntatawa fiye da abin da faifai C. yawanci yana da shi 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 kana da wata tambaya, rubuta zuwa adireshin imel ed@geofumadas.com. Koyaushe nuna fannin windows da kake amfani dashi.

22 yana maida hankali ga "Jerin fitarwa na haɗin gwiwar zuwa Google Earth, daga Excel, tare da hoton da rubutu mai arziki"

  1. Na riga na yi saukar da samfuri zan yi nazarin shi kuma duk wata shakka ko gyara zan rubuto muku. Thanks 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:
    "An sami kuskuren '75' a lokacin gudu.
    Kuskuren samun damar hanya 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. Kyauta mai kyau ne kawai don lura cewa lokacin da na sanya saituna ba ya nuna mani inda yake ... ba saboda ka yi zaton zai kasance?

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.