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ā kuhikuhina ma Excel. I loko o kēia mau mea, he hoʻonohonoho X, he coordinate Y, a he inoa pū no ka hulu. ʻO kaʻu e makemake ai e kikoo iā ia i AutoCAD. Ma kēia hihia, e hoʻohana mākou i ka hoʻohanaʻana i nā hōʻailona mai kahi kikokikona i 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 e pono ai mākou ke hana i ka hoʻohuiʻana i nā kaʻina hana e like me ke kauoha a ka hoʻokele AutoCAD no lākou. Eia kekahi laʻana, e huki i kahi helu e hoʻopaʻa mākou i kahi: POIP X coordinate, Y coordinate.

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,
  • Au i hana ai me ka papa concatenate, he kaula i ka loaʻa o ka halepaahao wahi, au laila, haʻalele i kekahi makahiki me ka hoʻohana ' "", au laila, concatenated ka B5 aeea me ka polopelema mau huahelu, alaila, e unuhi i ka comma aʻu i hoʻohana "," laila au ua hoʻokumu i ka pūnaewele C5. A laila ua kope wau no nā 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.

No ka hoʻokōʻana, ua kākauʻia i loko o ka papa kauoha kauoha SCRIPT, a laila, kaomi Kele. ʻO ka hoʻouluʻana i ke kiʻikuhi a ke nānā nei wau no ka file aʻu i hea aku ai keikuai.scr. Ke koho kokeʻia, ke pihiʻia ka pihi.

A voila, aia i kahi o nā kaha.

Ināʻaʻole iʻikeʻia nā māhele, pono pono ke hoʻokokoke i ka pae holoʻokoʻa o nā mea. No kēia ke kākau nei mākou i ke kauoha Zoom, e komo, nui, e 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

No ka huki i ke polygon, like ka loea like. me keʻano likeʻole e paʻa ai mākou i ka palapala PLINE, a laila ua hoʻokomoʻia ka papa kuhikuhi a me ka'ōlelo hope 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, ai ka wā e hoʻokō ai i ka hana, e loaʻa iā mākou ke kahakiʻi o ke kiʻi. Ua koho wau i ka lanu melemele no kaʻikeʻana i keʻano me nā kiko uila.

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

Ma hope,ʻike mākou i nā kikokikona ma ke kolamu mua e like me nā helu i kēlā me kēia huahelu. No kēia, e hoʻopaʻa mākou i ke kauoha e like me kēia:

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ʻomaka au i ka'ōmaʻomaʻo'ōmaʻomaʻo, eʻike i kaʻokoʻa. Ke hoʻopauʻia ka hōʻailona, ​​aia mākou i ka kikokikona i ka nui i hōʻikeʻia, aia i waenakonu o ka pūnaewele.

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

Hōʻike kaʻatikala i ka hanaʻana o ka hoʻoponopono. Inā nohoʻoe i ka mameli ma Excel, i kūkuluʻia e mālama i nāʻikepili, Hiki iāʻoe ke kūʻai mai maʻaneʻi.

Haʻalele i ka manaʻo hoʻopuka

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.