Nā kuhikuhi, nā laina a me nā kikokikona o kahi polygonal mai Excel i ka AutoCAD

Loaʻa iaʻu kēia papa inoa o nā hoʻonohonoho ma Excel. I kēia mau mea aia kahi hoʻohui X, kahi hoʻohui Y, a me kahi inoa no ka piko. ʻO ka mea aʻu e makemake ai e kahakiʻi iā ia ma AutoCAD. I kēia hihia e hoʻohana mākou i ka hoʻokō ʻana i nā palapala mai kahi huaʻōlelo concatenated ma Excel.

Concatenate he kauoha no ka hoʻokomoʻana i nā helu ma ka AutoCAD

Ka papa hoike i loko o ka pakuhi, e like me ka ike, ka loaʻa o ke kia ao i kapaia o vertex, laila UTM kahi kūlike no ka X kolamu, Y.

ʻO ka mea mua a mākou e hana ai ka concatenate i nā kikowaena e like me ke kauoha a AutoCAD e manaʻo nei iā lākou. ʻO kahi laʻana, e kaha i kahi kiko a mākou e noho ai: POINT coordinateX, coordinateY.

No laila,ʻo kā mākou hana e hoʻokomo i kahi kolamu hou me kēiaʻikepili concatenated, ma keʻano:

POINT 374037.8,1580682.4
POINT 374032.23,1580716.25
POINT 374037.73,1580735.14
POINT 374044.98,1580772.49
POINT 374097.77,1580771.83
POINT 374116.27,1580769.13

No ka hanaʻana i kēia concatenation ua hana wau i kēia mau mea:

  • Ua kapa aku au i ka pūnaewele D4 me ka POINT inoa,
  • Ua hana wau me ka hana concatenate, kahi kaula i komo pū me ka pūnaewele POINT, a laila ua waiho wau i kahi e hoʻohana ai i ««, a laila ua hoʻohui wau i ka pūnaewele B5 me kahi pōʻai pālua, a laila e kahakiʻi i ke koma aʻu i hoʻohana ai «,», a laila pūnaewele C5 i hoʻohui ʻia. A laila ua kope wau no ke koena o nā lālani.

E kaha i nā helu ma Excel

Ua kope au i nā mea o ka pahu D i kahi kikokikona.

E holo iā ia, kikokiko ʻoe i ka SCRIPT ma ka ʻaukā kauoha, a laila ke kī komo. Hāpai kēlā i ka mea ʻimi a nānā wau i ka faila aʻu i kāhea ai keikuai.scr. Ke koho ʻia, kaomi ʻia ka pihi hāmama.

A voila, aia i kahi o nā kaha.

 

 

 

 

 

 

 

 

Inā ʻaʻole ʻike ʻia nā kiko, pono e hoʻokokoke i nā mea kikoʻī. Kākau mākou i kēia i ke kauoha Zoom, komo, Extent, komo.

Ināʻikeʻoleʻia nā kikowaena, ua hoʻokōʻia ka kauoha PTYPE, a laila kohoʻia ka mea i hōʻikeʻia ma ke kiʻi.

E hoʻokumu i ka kauoha ma Excel a huki i ke polygon i AutoCAD

E kahakiʻi i ka polygon e like ia manaʻo. me ka mea ʻokoʻa a mākou e noho ai i ke kauoha PLINE, a laila nā concatenated coordinate a ʻo ka hope loa ke kauoha CLOSE.

ʻO PLINE
374037.8,1580682.4
374032.23,1580716.25
374037.73,1580735.14
...
374111.31,1580644.84
374094.32,1580645.98
374069.21,1580647.31
374048.83,1580655.01
kokoke

E kāhea mākou i kēia hōʻali geofumadas2.scr, a ke hoʻokō mākou iā ia e loaʻa iā mākou ke kiko o ke kaha kiʻi. Koho wau i ka waihoʻoluʻu melemele e nānā i ka ʻokoʻa me nā pale ʻulaʻula.

E hoʻokumu i ka papa kauoha ma Excel a e nānā i nā puka ma AutoCAD

ʻO ka mea hope loa, noho mākou i ka annotating i nā huaʻōlelo o ke kolamu mua ma ke ʻano he annotations i kēlā me kēia piko. No kēia, e kaulahao mākou i ke kauoha ma ke ala penei:

NUI KULA XCUM 374037.8,1580682.4 3 0

Hōʻike kēia kauoha:

  • ʻO ke kauoha TEXT,
  • ʻO keʻano o ka kikokikona, i kēia hihia e'āponoʻia,ʻo ia ke kumu o ka leka J,
  • ʻO ka kikowaena o ka kikokikona, koho mākou i ka Hale,ʻo ia ke kumu o ka leka C
  • ʻO ke kūkākūkā concatenated X, Y,
  • A laila ka nui o ka kikokikona, ua koho mākou iā 3,
  • ʻO kaʻoki o ka lihi, ma kēia hiʻohiʻona 0,
  • ʻO ka hope loa i nā mea a mākou i manaʻo ai,ʻo ka helu 1 ka lālani mua

Ua kauʻia i mua o nā pūnaewele'ē aʻe, penei:

NUI KULA XCUM 374037.8,1580682.4 3 0
NUI KULA XCUM 374032.23,1580716.25 3 0
NUI KULA XCUM 374037.73,1580735.14 3 0
NUI KULA XCUM 374044.98,1580772.49 3 0A
NUI KULA XCUM 374097.77,1580771.83 3 0
NUI KULA XCUM 374116.27,1580769.13 3 0
NUI KULA XCUM 374127.23,1580779.64 3 0
...

Ua kāhea au kānaewele geofumadas3.cdr 

Ua hoʻoheheʻe wau i ke kala ʻōmaʻomaʻo, e ʻike ai i ka ʻokoʻa. Ke hoʻokō ʻia ka script, loaʻa iā mākou ka huaʻōlelo i ka nui i hōʻike ʻia, ma ke kikowaena o ka coordinate.

Hoʻoili i ka Ke hoʻohana 'ia ke' ano AutoCAD i kēia 'ano.

Hōʻike ka ʻatikala pehea e kūkulu ʻia ai ke anakuhi. Inā ʻoe e hoʻohana i ke anakuhi ma Excel, ua kūkulu ʻia e hānai ʻikepili wale nō. Hiki iāʻoe ke kūʻai mai maʻaneʻi.

Hoʻokahi Pane i "E kahakiʻi i nā kiko, nā lālani a me nā ʻatikala o kahi hele mai Excel a i AutoCAD"

  1. pono wau i ke kōkua
    Pono wau e huki i nā haneli o nā ʻahālima e hōʻike ana i nā kumuwaiwai mining, he mau kīʻaha lākou me ka midpoint a me x a me nā ʻaoʻao, e pono ai wau i ke kōkua, loaʻa iaʻu nā ʻikepili i kahi ʻokoʻa.

Waiho i kahi pane

Kāu leka uila aae? E,ʻaʻole e paʻiʻia.

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.