uluhlu Rhweba ngaphandle kwe Google Earth zilungelelanise eendawo kwi-Excel, Umfanekiso ne Rich Text

Lo mzekelo nje nge-Excel ungathumela umxholo kwiGoogle Earth. Ityala yilo:

Sinoluhlu lwee-coordinates kwifomati yesimo se-decimal (lat / lon). Sifuna ukuthumela kwiGoogle Earth, kwaye sifuna ukubonisa ikhowudi yenkalo yomdla, isicatshulwa ngesibindi, umbhalo ochazayo, umfanekiso wesimboli kunye ne hyperlink ukuvula iphepha kwi-intanethi.

Ngezantsi umzekelo wento esiyethembayo ukuyibonisa xa sichofoza kwinqanaba:

Ikhowudi yile: XL-3458

Ubude:

-103.377499

Latitude:

20.654443

Kwaye oku sinethemba lokubona:

XL-3458 Kwinqanaba eliphakathi Indlu kaMnu Joaquín Gómez Padre, apho iYunivesithi yeSizwe yayiqala khona kwaye ibuye ibuyiselwe njengemyuziyam ekhuselwe yiNational Institute of Anthropology Jonga iphepha kwi-intanethi

Nangona ithemplate iya kulayishwa, umoya wecatshulwa ukuchaza indlela yokwenza ngayo wena.

Oko sikwenzayo kukudala iithegi ze-html kumakholomu ahlukeneyo ukuze bakwazi ukuxubusha: Ikhodi yale nto iya kuba:

<p><strong>Kwinqanaba eliphakathi</ strong></ P>
<p>Indlu kaMnu Joaquín Gómez Padre, apho iYunivesithi yeSizwe yayiqala khona kwaye ibuye ibuyiselwe njengemyuziyam ekhuselwe yiNational Institute of Anthropology</ P>
<p>
<p><img src = »http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpgUbubanzi = »144Ukuphakama =168«></ P>

<p>

<p><a href = »http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg«>Jonga iphepha kwi-intanethi</a></ P>

Zonke iilebula ezithi <p> ​​zibonisa ukuba umgca ohlukile, ukuvala nge </ p> elilingana ne-Enter.

Emva koko, <strong> yileyibhile ukubonisa ukuba lo mbhalo unesibindi, ngokuqinisekileyo uvale nge </ strong>

im iilebula yomfanekiso, ophakathi ngaphakathi uphethe iipropati ezifana nobubanzi (ububanzi), ukuphakama (ukuphakama) kunye nesalathiso apho umfanekiso (src)

Ekugqibeleni kukho ithempthi yokuxela, evula <a href, koko kukho idilesi kunye nombhalo odibanisa i hyperlink, kwaye ivala kunye </a>

Into ephawulwe ngombala obomvu yinto enokutshintsha ngomfanekiso ngamnye, ngoko siya kuba nomdla emva koko siyeke kwiiseli.

Ngaphandle kokubuya okukhulu, unokwazi ngoko ukuba umsebenzi we-concatenate uza kushwankathela kwinto efana nale:

= QHUBEKA(<p><strong>,CELDA,</ strong></ P>,CELDA,<p>,CELDA,</ p> <p> <p><img src = »,CELDA,Ububanzi = »,CELDA,»Ukuphakama =»,CELDA,«></ P><p><p><a href = »,CELDA,«>,CELDA,</a></ P>)

Oku kuthetha ukuba siya kuthatha iikholomu ze-8 ukugcina yonke idatha esifuna ukuyibonisa. Nangona kwimeko yabathengi abasebenzisa isimboli = kunye neempendulo eziphindwe kabini ziyinkimbinkimbi kwi-Excel ngokokuqala ibonisa umsebenzi kwaye yesibini isetyenziselwa ukwahlula umxholo wombhalo. Oku kusisombululo ngokubeka ezi ziqulatho kwiiseli ezahlukileyo ngokungathi zibhalwe.

Ekugqibeleni sinakho oku:

Kwaye ukuthumela kwiGoogle Earth ndibeke iqhosha elenza ifayile. Kulapho uchaza indlela apho ifayile kunye negama okulindele ukuba ube nencazelo ye kml xa iboniswe kwipaneli ekhohlo.

Ithemplate inezibonakaliso ezithile xa uhambisa imouse phezu kweeseli ukubonisa indlela idatha ifanele ifakwe ngayo. Ngokuqhelekileyo, ngokuqhelekileyo kunenkinga xa i-macros ayinakunyulwa kwaye xa umendo apho ifayili idalwe ayinalungelo lokubhala.

Kukho esinakho, unokukhangela ngekhowudi kwibar yebhedi yeGoogle Earth, kwaye ukucofa kwinqanaba liboniswa njengoko silindele.

Ukukhuphela umzekelo kml

Ifuna inqaku lokufuzisela ukukhuphela, ongayenza nalo Paypal okanye kwikhadi lekhredithi.

Kufanekisela ukuba umntu ucinga ngento ebonelela ngayo kunye nokukhululeka okungafumaneka kuwo.

---

Funda ukuba ungayenza njani le kunye nezinye itemplate kwi Ikhosi yokukopela ye-Excel-CAD-GIS.

---

Iingxaki eziqhelekileyo

Kungenzeka ukuba, xa usebenzisa isicelo, esinye seziganeko ezilandelayo siyakubonakala:

Iphutha le-75 - Inkqubo yefayile.

Oku kwenzeka ngenxa yokuba indlela echazwe apho ifayile ye-kml iya kugcinwa ayifumanekanga okanye ayikho imvume yeli nyathelo.

Ngokufanelekileyo, kukubeka indlela kwiDiski, enezithintelo ezincinci kuneyiphi idisk.

D: \

Amaphuzu aphuma eNtshona Pole.

Oku kuya kwenzeka, ngokuba kwiifestile zethu, njengoko kuboniswe kumyalelo wethemplate ukusebenza, ukucwangciswa kwendawo kufuneka kusekwe kwiphaneli yesithili:

• -Point, for separator decimals
• -Coma, ngamawaka ahlukeneyo
• -Coma, ukuze uhlalutye uluhlu

Ngoko ke, idatha enjengale: Iwaka elinesibhozo elinamakhulu asixhenxe anesibhozo kunye neesentimitha ezilishumi elinesibini kufuneka ibonakale njenge-1,780.12

Umfanekiso ubonisa indlela oku kulungiswa ngayo.

Lo mnye umfanekiso obonisa ukucwangciswa kwipaneli yokulawula.

Emva kokuba utshintsho lwenziwe, ifayile iphinda iveliswe kwakhona kwaye, amanqaku aya kubonakala apho ihambelana neGoogle Earth.

Ukuba unemibuzo, bhala kwi-email editor@geofumadas.com. Njalo ubonise ukuguqulelwa kweefestile ozisebenzisayo.