Cov txheej txheem:

Yuav ua li cas hloov Excel rau KML?
Yuav ua li cas hloov Excel rau KML?

Video: Yuav ua li cas hloov Excel rau KML?

Video: Yuav ua li cas hloov Excel rau KML?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Tej zaum
Anonim

Txuag Cov Ntaub Ntawv

  1. Hauv "Qhov chaw" qhov rais ntawm Google Earth, right-click lub nplaub tshev "Earth Point Excel to KML ".
  2. Los ntawm cov ntawv qhia zaub mov pop-up, xaiv "Txuag li".

Tom qab ntawd, kuv yuav hloov cov ntaub ntawv KML los ntawm Excel rau Google Earth li cas?

Txhawm rau tsim cov ntaub ntawv KML los ntawm koj cov ntaub ntawv spreadsheet, ua raws cov kauj ruam hauv qab no:

  1. Mus rau batchgeo.com.
  2. Muab koj cov ntaub ntawv tso rau hauv lub thawv loj.
  3. Nyem "Map Now"
  4. Tos rau geocoding kom tiav, ces nias "Ntxiv / Txuag"
  5. Sau cov npe, cov lus piav qhia, thiab nco ntsoov suav nrog koj qhov chaw nyob email, tom qab ntawd nyem "Txuag Daim Ntawv Qhia"

Ib sab saum toj no, Kuv yuav hloov Excel li cas rau Google Earth? Ntshuam cov ntaub ntawv spreadsheet

  1. Hauv koj lub computer, qhib Google Earth Pro.
  2. Nyem Cov Ntaub Ntawv Ntshuam.
  3. Xauj mus rau qhov chaw ntawm cov ntaub ntawv CSV thiab qhib nws.
  4. Nyob rau hauv lub thawv uas tshwm, nyob ib sab ntawm Field Type, xaivDelimited.
  5. Tom ntej no mus rau Delimited, xaiv Comma.
  6. Siv lub pane saib ua ntej kom paub tseeb tias koj cov ntaub ntawv tau raug imported thiab nyem Next.

Ib yam li ntawd, koj tuaj yeem nug, Kuv yuav hloov cov ntaub ntawv KML rau Excel li cas?

Txoj nyem rau ntawm KML cov ntaub ntawv thiab xaiv "Qhib nrog"Notepad:

  1. Nws yuav qhia XML formatted ntawv hauv Notepad. Mus rau Cov Ntaub Ntawv / Txuag Asand xaiv "tag nrho cov ntaub ntawv" kev xaiv.
  2. Daim ntawv ceeb toom, tias ob qho tib si Latitude thiab Longitude nyob rau hauv tib kem, sib cais los ntawm comma.
  3. Txhawm rau hloov KMZ rau KML koj yuav xav tau Google Earthinstalled.

Kuv yuav qhib KML cov ntaub ntawv hauv Excel li cas?

Yog tias koj qhov chaw nyob hauv KML cov ntaub ntawv koj tuaj yeem xa lawv mus rau MS Excel cov ntaub ntawv los ntawm cov txheej txheem hauv qab no:

  1. Hloov npe koj cov ntaub ntawv.kml rau.xml.
  2. Qhib ib daim ntawv tshiab excel (2007 thiab tom qab) thiab nyem rau ntawm Cov Ntaub Ntawv> Los Ntawm Lwm Qhov Chaw> Los Ntawm XML Cov Ntaub Ntawv Ntshuam.
  3. Nrhiav cov ntaub ntawv koj hloov npe thiab nyem qhib.

Pom zoo: