Taw cov ntsiab lus, cov kab thiab cov ntawv ntawm ib lub polygonal ntawm Excel mus rau AutoCAD

Kuv muaj cov npe no ntawm kev tswj hwm hauv Excel.

Nyob rau hauv no muaj ib tug X coordinate, ib tug Y coordinate, thiab kuj muaj lub npe rau lub vertex. Qhov kuv xav tau yog kos nws hauv AutoCAD. Hauv qhov no peb yuav siv qhov kev ua tiav ntawm cov ntawv sau los ntawm cov ntawv sib txuas hauv Excel.

Concatenate ib lo lus txib rau lub ntsiab ntawm cov ntsiab lus hauv AutoCAD

Cov lus qhia hauv daim phiaj, raws li koj pom, muaj ib kem nrog lub npe ntawm vertex, ces UTM tau sib koom ua ke rau X, Y.

Thawj qhov peb yuav tsum tau ua yog concatenate tswj kev tswj hwm raws li qhov hais kom ua AutoCAD xav kom lawv. Piv txwv li, txhawm rau kos taw peb peb yuav nyob: POINT coordinateX, coordinateY.

Li ntawd, peb yuav ua li cas yog sau ib kem tshiab nrog cov ntaub ntawv no concatenated, hauv daim ntawv:

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

Yuav ua li no concatenation kuv tau ua cov nram qab no:

• Kuv tau hu lub xovtooj ntawm D4 nrog lub npe POINT,
• Kuv tau tsim nrog lub concatenate muaj nuj nqi, ib txoj hlua uas suav nrog POINT cell, ces kuv tau tso qhov chaw siv " ", ces kuv tau concatenated cell B5 nrog ib tug ob-tus lej rounding, ces kos lub comma kuv tau siv "," , ces kuv tau concatenated cell C5. Tom qab ntawd kuv tau theej rau lwm tus kab.

Kos cov ntsiab lus hauv Excel

Kuv tau theej cov ntsiab lus ntawm kab D rau ib phau ntawv.

Yuav kom khiav nws, ntaus SCRIPT hauv kab hais kom ua, tom qab ntawd ntaus Enter. Qhov ntawd nqa tus neeg tshawb xyuas thiab kuv nrhiav cov ntawv uas kuv tau hu geofumadas.scrCov. Thaum xaiv tas, qhib lub pob nyem.

Thiab voila, peb muaj cov vertices twv.

Nyob rau hauv rooj plaub cov ntsiab lus tsis pom, nws yog ib qho tsim nyog yuav tau nce mus rau ntawm kev ua tiav cov khoom tiav. Rau qhov no peb sau cov lus txib Zoom, sau, Extent, nkag.

Nyob rau hauv cov ntaub ntawv cov ntsiab lus tshwm tsis pom heev, cov PTYPE hais kom ua tiav, ces tus uas teev nyob hauv daim duab xaiv.

Concatenate qhov hais kom ua nyob rau hauv Excel thiab kos tus polygon hauv AutoCAD

Txhawm rau kos cov duab thaib nws yuav yog tib lub cav. nrog cov sib txawv uas peb yuav nyob hauv PLINE cov lus txib, tom qab ntawd cov kab sib txuas ua ke kom kawg thiab thaum kawg CLOSE cov lus txib.

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
ZE

Peb yuav hu rau tsab ntawv no geofumadas2.scr, thiab thaum peb ua nws peb yuav muaj kab ntawm daim duab. Kuv xaiv cov xim daj kom pom qhov sib txawv nrog cov kab liab liab.

Concatenate qhov kev hais kom ua nyob rau hauv Excel thiab nco lub vertices hauv AutoCAD

Thaum kawg, peb nyob annotating cov ntawv ntawm thawj kem li ntawv tshaj tawm ntawm txhua kab ntawv. Rau qhov no, peb yuav saw cov lus txib raws li txoj kev hauv qab no:

TEXT JC 374037.8,1580682.4 3 0 1

Qhov hais kom ua no:

• TEXT hais kom ua,
• Lub zwj ceeb ntawm cov ntawv nyeem, nyob rau hauv cov ntaub ntawv no tsis txhaum, yog vim li cas daim ntawv J,
• Lub hauv paus ntsiab lus ntawm cov ntawv nyeem, peb xaiv Center, yog vim li cas tsab ntawv C
• Lub concatenated coordinate X, Y,
• Ces qhov luaj li cas ntawm cov ntawv, peb tau xaiv 3,
• Lub kaum sab xis ntawm kev sib hloov, qhov no 0,
• Thaum kawg cov ntawv nyeem uas peb cia siab, tias thawj kab yuav yog tus 1

Twb tau propagated rau lwm lub hlwb, nws yuav raws li nram no:

TEXT JC 374037.8,1580682.4 3 0 1
TEXT JC 374032.23,1580716.25 3 0 2
TEXT JC 374037.73,1580735.14 3 0 3
TEXT JC 374044.98,1580772.49 3 0 3A
TEXT JC 374097.77,1580771.83 3 0 4
TEXT JC 374116.27,1580769.13 3 0 5
TEXT JC 374127.23,1580779.64 3 0 6
...

Kuv hu xov tooj rau geofumadas3.cdr cov ntaub ntawv 

Kuv tau ua kom ntsuab xim, kom pom qhov sib txawv. Thaum cov ntawv sau tiav, peb muaj cov ntawv sau rau hauv qhov loj me, qhia hauv nruab nrab ntawm qhov chaw ua haujlwm.

Download tau AutoCAD cov ntaub ntawv siv rau hauv qhov ua piv txwv no.

Cov ntawv xov xwm qhia tias tus qauv tsim li cas. Yog tias koj siv tus qauv hauv Excel, twb tau ua los tsuas pub cov ntaub ntawv pub, Koj tuaj yeem yuav nws ntawm no.