Dhirora mapepa, mitsara uye magwaro epa polygonal kubva kuExcel kusvika kuCodCAD

Ndine runyoro urwu rwemakodha muExcel.

Mune izvi pane X coordination, Y coordination, uye zvakare zita revertex. Chandinoda kudhirowa mu AutoCAD. Mune ino kesi isu tichashandisa kuitiswa kwezvinyorwa kubva kune concatenated zvinyorwa muExcel.

Concatenate murairo wekuiswa kwemashoko muCotCAD

The tafura kuratidzwa girafu, sezvinoonekwa, rinosanganisira wechikamu inonzi vertex, ipapo UTM rinoronga kuti X mbiru Y.

Chinhu chekutanga chatinofanira kuita kubatanidza marongero sekutarisirwa kwazvino AutoCAD. Semuenzaniso, kutora poindi yatichagara: POINT coordinateX, coordinateY.

Saka, zvatichazoita ndeyokuisa chitubu chitsva nemashoko akafananidzirwa, muchimiro:

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

Kuti ndiite izvi kugona ndakaita zvinotevera:

• Ndakadana sero D4 nezita POINT,
• Ini ndakagadzira neiyo concatenate function, tambo inosanganisira iyo POINT cell, zvino ndasiya nzvimbo ndichishandisa "", ipapo ini ndakabatanidza sero B5 ine madhijiti maviri kutenderera, zvino kudhirowa komma yandashandisa "," , ipapo ndakabatanidza cell C5. Ndobva ndakopa kune mamwe mitsara.

Dhonza pfungwa dziri muExcel

Ndanyora zviri mukati me column D kune text file.

Kuti uiite, iwe unyore mubha yekuraira SCRIPT, wobva wapinza kiyi. Izvo zvinounza iye anotsvaga uye ini ndinotsvaga iyo faira randakadaidza geofumadas.scr. Kana uchinge wasarudzwa, bhatani rakavhurika rinodzvanywa.

Uye voila, imomo tine zvidimbu zvakaswededzwa.

Muchiitiko chekuti iwo mapoinzi asingaoneke, zvinodikanwa kuti uswededze pane seti yakazara yezvinhu. Kune izvi tinonyora raira Zoom, pinda, Kuwedzera, pinda.

Kana Dots kuonekwa asazivikanwa, kuti PTYPE murayiro wacho aurayiwa, ipapo zvairatidza mufananidzo anosarudzwa.

Simbisai murayiro muExcel uye torai polygon muCotCAD

Kuti utore polygon ichave yakafanana pfungwa. nemusiyano uyo isu tichagara iwo PLINE rairo, ipapo concatenated marongero uye pakupedzisira iwo KUSVIRA kuraira.

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
PEDYO

Tichadana iyi script geofumadas2.scr, uye kana tachiita isu tinenge tine mucherechedzo wekudhirowa. Ini ndakasarudza yeruvara kuti ndione mutsauko nemavhenekeri matsvuku.

Concatenate mutemo uri muExcel uye ona nheyo muCotCAD

Chekupedzisira, isu tinotora annotating iwo mavara ekoramu yekutanga sezvidimbu pane yega vertex. Kune izvi, isu ticha cheni iwo murairo nenzira inotevera:

TEXT JC 374037.8,1580682.4 3 0 1

Uyu murairo unomiririra:

• Mutemo we TEXT,
• Mamiriro ezvinyorwa, munyaya iyi yakarurama, ndicho chikonzero tsamba J,
• Nheyo huru yemagwaro, takasarudza Center, ndicho chikonzero tsamba C
• The concatenated coordinate X, Y,
• Zvadaro hukuru hwemashoko, takasarudza 3,
• Nzira yekuzungunuka, munyaya ino 0,
• Pakupedzisira rugwaro rwandinotarisira, kuti mumutsara wekutanga uchava nhamba ye1

Yakaparadzirwa kune mamwe masero, ichave seinotevera:

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
...

Ndakadana iyo geofumadas3.cdr file 

Ini ndakaita girini girini, kuti ndione mutsauko. Kamwe kana script yaitwa, isu tine iwo mavara mune yakaratidzwa saizi, pakati chaipo pebato.

Download the AutoCAD file yakashandiswa mumuenzaniso uyu.

Icho chinyorwa chinoratidza maitirwo akaitwa template. Kana iwe ukashandisa iyo template muExcel, yatovakwa kungopa chete data, Unogona kuzvitenga pano.