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ā koina ma Excel.

Aia i loko o ia mau mea he hoʻohui X, he hoʻohui Y, a he inoa pū kekahi no ka vertex. ʻO kaʻu makemake e huki iā ia ma AutoCAD. I kēia hihia, e hoʻohana mākou i ka hoʻokō ʻana i nā palapala mai nā kikokikona 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 au me ka hana concatenate, he kaula i komo pū me ka POINT cell, a laila ua waiho au i kahi hakahaka me ka hoʻohana ʻana i " ", a laila ua hoʻohui au i ka cell B5 me kahi pōʻai helu ʻelua, a laila e kaha i ke koma aʻu i hoʻohana ai "," , a laila ua hoʻohui au i ka cell C5. A laila ua kope au 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.