Dhirorera pikorogoni nemabheji uye marefu kubva kuExcel kusvika ku Microstation

Makore mashomanana adarika ndakabudisa imwe nyaya yakaratidza nzira yekubatanidza nhamba muExcel kusvika kune kuvaka polygonal neAcotCAD, pasina kuita chirevo chose:

@distance

Rimwe zuva takanga tiri munzira yeAutoCAD mumwe munhu akandibvunza kana izvo zvingaitwe neMicrosation rairo yekuraira. Mhinduro ndeiyi Hungu, iwe unofanirwa kungonzwisisa kuti Microstation's Keyin haina kufanana neAutoCAD yekuraira mutsara. Ngatione kuti ingavakwa sei, pakupfuura tinodzidza zvinhu zvidiki zvishoma zvinoshandiswa muchirongwa ichi:

Bhokisi riri kurudyi muenzaniso wekuyambuka zvichienderana nemabhengi uye madaro ane chinotevera chimiro.

Ne Microstation unogona kutora iyi sezvandakatsanangura kare, nechinetso chisina kujeka-uye chimwe chete cheAustCAD-, kuti zvinotyisa kunyora rimwe chete, mukana wokuita zvikanganiso uye kunyange kutadza kugadzirisa chikoro chekare.

Zvakanaka, kuratidzira kwacho kunongofanana chete izvo zvandakatsanangura ne AutoCAD, iwe unongoda kunzwisisa chimwe chinhu umo Microstation yakasiyana.

Iyo keyin haina kuvakwa zvichienderana nekugadzira mirairo mumutsara wezvinyorwa asi yekudaidzira mirairo ine chinhu chakatarisana, saka inongotsigira mavara makumi mashanu nematanhatu. Pamusoro pezvo, zvinoda kuti semicolon (;) ishandiswe kupatsanura iwo maodha nekuti, kusiyana neAutoCAD, iyo inouya kubva kuChechi kuronga manyorerwo, inounza pfungwa yeClipper neicho Microstation yakaitwa ipapo apo yakanga ichiri kunzi Ustation.

Tichifunga izvi, nzira yakapusa ndeyekudaira maodha kubva kune faira reruzhinji nemirairo @, iyo yandinofunga vashoma kwazvo vanoziva asi inova ndiyo nzira iyo Microstation yagara ichishandisa kuita mabatch odha. Kusanganisira iyo import mapoinzi kubva kune txt runyorwa Ndiyo mdl anoita izvi.

Kushandisa Excel pepa I ini ndamboshanda kuti ndidzidzise kuti ndingashandura sei kubva kune zvikwereti uye marefu kuenda kuhutano, ndicharatidza kuti ingaratidza sei kuti Microstation:

Concatenate the points.

Chinotifarira isu pakupedzisira, kuti Key in Pakupedzisira:

nzvimbo nzvimbo ;xy =374037.736,1580735.145;

Nzvimbo poindi iwo murairo wepfungwa, kusanganisira nzvimbo, semicolon ndeye kuratidza imwe hurongwa, iyo xy = ndiyo yekuraira kuti upinze makonati uye iwo maviri ebhuruu neeruvara rwegreen ndiwo anozivikanwa mapoinzi. Pakupera semicolon nyowani kuratidza a pinda kana kutora kumirairo mutsva.

Saka saka, ndichifungidzira kuti masero ezvandinofarira ari muU7 uye V7 kuti iite concatenate yaizova:

= CONCATENATE(“nzvimbo nzvimbo ;”,xy ="U7,",",V7";")

Nenzira iyi, ini chete ndinonyora zviri mukati mekhoma AA mufaira re txt, randichadana punchpoints2.txt. Ini ndinopa zano kuti vaiise zvakananga muC saka nzira haina kuoma.

Muchiitiko ichi, ndiri kuisa mumagwaro angu, nzira ingadai iri: C: \ Users \ User \ Documents \ pf-points2.txt

kuti tiite, tinoshandisa mutemo wehwindo (key in), izvi zvinoitwa kubva Zvishandiso> kiyi mukati uye zvino pinda urongwa:

@C: \ Users \ User \ Documents \ punchpoints2.txt

Isu tinopinda, uye ipapo unayo, iwo mapoinzi akadhirowewa muhurongwa hwavo. Izvo zviri nyore kuve neakakura mutsetse ukobvu kuti ivo varatidzwe.

Concatenate mitsara.

Nokuda kweizvi, kushanda kwakafanana, mutemo watinofanira kuita ndewokuti nzvimbo lineMukuwedzera, tinoratidza kuti mutsetse une chikonzero chekutanga uye chinangwa chekuenda.

nzvimbo line ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

= CONCATENATE(“nzvimbo line ;”,xy =",U6,",",V6,";","xy =“,U7,””,,V7,”;”)

Tinoteedzera nekunamatira kune txt faira, chengeta uye kumhanya zvakare

@C: \ Users \ User \ Documents \ punchpoints2.txt

Uye ikoko vanezvo:

Uye imwezve inobatsira, ndeyokuti kuvaka bhokisi rekutakura uye kureba kunoda kungoita mufananidzo mu Excel, uye kudya mu Microstation. Namafuta akakosha iwe unogona kusarudza pakati pekuve mufananidzo, yakadzamidzirwa kana yakabatanidzwa spreadsheet

Kuti apedzise iyo nyaya, Ndiri kuronga muenzaniso wefaira mu Excel, umo mairi chete pfungwa yezvakabva, mazano uye marefu anofanirwa kuchinjwa uye template inogona kubatsira chero ipi zvayo iguana inopfuura hafu yepaundi yemibvu.  Uyewo pano muenzaniso txt.

Inoda mupiro wekufananidzira wekuburitsa, waunogona kuita nawo Kadhi kadikiti kana Paypal.