Dulani polygon ndi zonyamulira ndi maulendo kuchokera ku Excel kufikira Microstation

Zaka zingapo zapitazo ndinasindikiza nkhani yomwe ine ndasonyeza momwe ndingagwirizanitsire data ku Excel kwa kumanga msewu ndi AutoCAD, popanda kuchita malamulo onse:

@alirezatalischioriginal

Tsiku lina tili mu AutoCAD wina adandifunsa ngati zingachitike ndi mzere wamagetsi wa Microsation. Yankho ndi INDE, muyenera kumvetsetsa kuti Keyin ya Microstation siyofanana ndi mzere wa lamulo la AutoCAD. Tiyeni tiwone momwe zingamangidwire, tikamadutsa timaphunzira zazing'ono zomwe sizigwiritsidwe ntchito pulogalamuyi:

Bokosi lomwe lili kumanja ndi chitsanzo cha njira yodutsa potengera ma bere ndi mtunda wokhala ndi dongosolo lotsatirali.

Ndi Microstation mungatenge izi monga ndanenera poyamba, ndi zovuta zoonekeratu - ndi chimodzimodzi cha AutoCAD -, kuti ndi zovuta kuti muzilemba chimodzimodzi, kuthekera kukhala kolakwika komanso ngakhale kuti njira yapitayi siikonzanso.

Chabwino, ndondomeko ya kugwirizanitsa ndi chimodzimodzi zomwe ndakufotokozera ndi AutoCAD, mumangomvetsa zomwe Microstation imasiyana.

Makiyiwo sanamangidwe potengera kupanga malamulo m'mizere koma poyitanitsa malamulo okhala ndi zinthu, kotero amangogwira zilembo 56. Kuphatikiza apo, pamafunika semicolon (;) kugwiritsidwa ntchito kupatulira malamulowo chifukwa, mosiyana ndi AutoCAD, yomwe imachokera ku Basic programic logic, imabweretsa malingaliro a Clipper ndi zomwe Microstation idapangidwa pamenepo pomwe idatchedwa Ustation.

Popeza izi, njira yosavuta ndikutumiza maoda kuchokera pa fayilo yolembedwa ndi command @, yomwe ndikuganiza kuti ndi ochepa omwe amadziwa koma ndiyo njira yomwe Microstation yakhala ikugwiritsa ntchito pokonza ma batch. Kuphatikiza tumizani mfundo kuchokera mndandanda wama txt Ndi mdl yemwe amachita izi.

Kugwiritsa kupambana kuphunzitsa poyamba ankagwira ntchito wotembenuka ntchito malangizo ndi kutalika, ndidzakuwonetsa monga concatenate kwa Microstation:

Sungani mfundozo.

Chimene chimatikonda ife potsiriza ndicho Chofunikira chomaliza ndi:

malo a malo ;xy =374037.736,1580735.145;

Malo amalo ndi lamulo lolozera, kuphatikiza danga, semicolon ndikuwonetsa dongosolo lina, xy = ndiye dongosolo lolowera makonzedwe ndipo maubuluu awiri abuluu ndi obiriwira ndiwo malo odziwika. Pamapeto pake semicolon yatsopano yosonyeza a Lowani kapena ayambe ku lamulo latsopano.

Kotero, kuganizira maselo omwe ndikukondweretsedwa nawo mu U7 ndi V7 kuti ndiwonetsetse kuti:

=KULUMIKIZANI("malo a malo ;”,xy =",U7",",V7,;”)

Mwanjira iyi, ndimangolemba zomwe zili m'kalemba AA mu fayilo ya txt, yomwe ndiyitchula punchpoints2.txt. Ndikulangiza kuti ayike mwachindunji mu C kotero kuti njirayo siyovuta kwenikweni.

Pankhani iyi, ndikuyiyika mu zolemba zanga, njira idzakhala: C: \ Users \ User \ Documents \ pf-points2.txt

kuti tichite izo, timatsegula fayilo la mzere wa lamulo (chofunikira), izi zachitika Zida> zofunika mu kenako alowetsani dongosolo:

@C: \ Users \ User \ Documents \ pf-points2.txt

Timalowa, ndipo pamenepo muli nacho, mfundozo zidakonzedwa motsatana. Ndikosavuta kukhala ndi makulidwe akuda mzere kuti awonetsedwe.

Konzani mzere.

Kwa ichi, ntchitoyi ndi yofanana, lamulo limene tiyenera kuchita ndilo mzere wa malo, kuwonjezera apo timasonyeza kuti mzere uli ndi chiyambi ndi malo opita.

mzere wa malo ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

=KULUMIKIZANI("mzere wa malo ;”,xy =",U6,",",V6,";","xy =",U7,",",V7,";")

Timasindikiza ndikunama pa fayilo ya txt, ndikusunga ndikuyambiranso

@C: \ Users \ User \ Documents \ pf-points2.txt

Ndipo apo iwo ali nacho icho:

Ndipo kupindula kwina ndikuti kumanga bokosi la zida ndi maulendo kumafuna kuchita Koperani mu Excel, ndi phala mu Microstation. Ndi phala lapadera mungasankhe pakati pokhala fano, spreadsheet yolumikizidwa kapena yolumikizidwa

Kuti mumalize nkhaniyi, Ndikukonzekera fayilo yachitsanzo mu Excel, zomwe zimangosintha ndondomeko ya chiyambi, maulendo ndi maulendo ndi template zingakhale zothandiza kwa iguana iliyonse yomwe imakhala ndi nthiti zoposa nusu ya nthiti.  Komanso apa chitsanzo cha txt.

Pamafunika chopereka chophiphiritsira kutsitsa, komwe mungachite Makhadi a ngongole kapena Paypal.