Kos ib tug polygon nrog cov lus qhia thiab deb ntawm Excel rau Microstation

Ob peb xyoos dhau los kuv tau luam tawm ib tsab xov xwm qhia tau tias yuav ua li cas rau concatenate cov ntaub ntawv hauv Excel tsim ib tug polygonal nrog AutoCAD, tsis tas yuav tsum tau ua tag nrho cov txheej txheem:

@distance

Lwm hnub peb tau nyob hauv chav AutoCAD ib tug neeg nug kuv yog tias qhov ntawd tuaj yeem ua tiav nrog kab Microsation kab. Cov lus teb yog YOG, koj tsuas yog yuav tsum to taub tias Microstation's Keyin tsis zoo li AutoCAD cov kab hais kom ua. Cia peb pom yuav ua li cas nws tuaj yeem tsim, hauv dhau peb kawm me ntsis khoom siv me me hauv qhov program no:

Lub npov ntawm sab xis yog ib qho piv txwv ntawm kev sib txawv raws kev qhia thiab qhov chaw.

Autocad microstation thiab nrug daim ntawv qhia

Nrog Microstation koj tuaj yeem kos qhov no raws li kuv tau piav ua ntej, nrog cov cuab kev tsis zoo -thiab ib qho ntawm AutoCAD-, tias nws yog tsho yuav tsum sau ib los ntawm ib tug, tseem ua yuam kev thiab txawm tsis resetting tus yav dhau los chav kawm.

 

microstation cov lus qhia

 

Qhov tshij, txoj kev sib koom tes yog tib yam nkaus dab tsi kuv piav nrog AutoCAD, koj tsuas muaj to taub ib yam dab tsi uas Microstation sib txawv.

Cov keyin tsis tau tsim los ntawm kev ua cov kab lus hauv cov kab ntawv tab sis rau hu cov lus txib nrog kev tawm tsam, yog li nws tsuas yog txhawb 56 tus cim. Tsis tas li ntawd, nws yuav tsum tau siv lub semicolon (;) siv los cais cov kev txiav txim vim tias, tsis zoo li AutoCAD, uas los ntawm cov Basic programming logic, nws coj lub Clipper logic nrog dab tsi Microstation tau ua thaum muaj nws tseem hu ua Kev Tshaj Tawm.

Muab qhov no, qhov yooj yim tshaj yog hu qhov kev txiav txim los ntawm cov ntawv sau nrog @ hais kom ua, uas kuv xav tias tsawg heev paub tab sis twg yog tus txheej txheem uas Microstation ib txwm siv los ua cov ntawv xaj. Xws li cov cov ntsiab lus ntshuam los ntawm ib daim ntawv teev txt nws 's tus mdl uas ua li no.

 

Siv cov ntawv Excel uas kuv tau ua yav dhau los ua los qhia txog kev hloov li cas los ntawm txoj kab thiab kev mus rau qhov chaw, Kuv yuav qhia seb nws yuav ua li cas rau Microstation:

Concatenate cov ntsiab lus.

Yam dab tsi uas peb xav tau yog thaum kawg, tias Qhov tseem ceeb kawg yuav:

qhov chaw taw tes ;xy =374037.736,1580735.145;

Qhov chaw taw tes yog qhov taw tes taw qhia, suav nrog qhov chaw, semicolon yog qhia lwm qhov kev txiav txim, tus xy = yog qhov kev txiav txim nkag mus rau hauv cov chaw tswj hwm thiab ob lub chaw sib xyaw xiav thiab ntsuab yog cov ntsiab lus paub. Ntawm kawg hais qhia txog xim kab ntsig tshiab los qhia a nkag mus los sis cov lus txib tshiab.

Yog li ces, piv txwv tias yog lub hlwb ntawm kuv cov paj laum nyob hauv U7 thiab V7 rau concatenate yuav:

= CWJ PWM («qhov chaw taw tes ; »,»xy =",U7, »,»,V7, »;»)

Autocad microstation thiab nrug daim ntawv qhia

Ua li no, kuv tsuas luam cov ntsiab lus ntawm kem AA rau hauv cov ntaub ntawv txt, uas kuv yuav hu punchpoints2.txtCov. Kuv hais kom lawv muab nws ncaj qha rau C yog li txoj kev tsis nyuaj.

Hauv qhov no, Kuv tabtom tso nws rau hauv kuv cov ntaub ntawv, txoj kev yuav: C: \ Cov neeg siv \ Neeg siv \ Cov ntaub ntawv \ pf-points2.txt

los coj nws, peb qhib cov lus txib kab qhov rai (tseem ceeb hauv), qhov no yog ua los ntawm Cov Kev Siv> tus yawm sij hauv thiab ces nkag mus rau qhov kev txiav txim:

@C: \ Cov neeg siv \ Neeg \ Cov ntaub ntawv \ punchpoints2.txt

Peb ua Sau, thiab nyob ntawd koj muaj nws, cov ntsiab lus raug kos hauv lawv qhov kev txiav txim. Nws yog qhov yooj yim kom muaj cov kab tuab tuab rau lawv tau ua kom pom.

 

Autocad microstation thiab nrug daim ntawv qhia

Concatenate cov kab.

Rau qhov no, txoj haujlwm zoo sib xws, qhov kev hais kom ua peb yuav tsum tau coj qhov chaw kabTsis tas li ntawd xwb, peb qhia tau hais tias txoj kab muaj qhov chaw ntawm keeb kwm thiab lub ntsiab lus ntawm qhov chaw.

qhov chaw kab ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

= CWJ PWM («qhov chaw kab ; »,»xy =«, U6,», », V6,»; »,»xy =«, U7,», », V7,»; »)

Peb theej thiab muab tshuaj txhuam rau cov ntawv txt, txuag thiab khiav dua

@C: \ Cov neeg siv \ Neeg \ Cov ntaub ntawv \ punchpoints2.txt

Thiab muaj lawv muaj nws:

Autocad microstation thiab nrug daim ntawv qhia

 

Thiab qhov kom zoo dua, yog qhov tsim lub npov ntawm cov kabmob thiab kev mus tsuas yog yuav tsum tau ua Copy hauv Excel, thiab muab tshuaj txhuam hauv Microstation. Nrog muab tshuaj txhuam tshwj xeeb koj tuaj yeem xaiv los ua tus duab, ib qho txuas los yog txuas rau pob ntawv tawm

Autocad microstation thiab nrug daim ntawv qhia

cov lus qhia rau microstation DownloadsUa kom tiav cov tshooj, Kuv tabtom npaj cov qauv ntaub ntawv hauv Excel, nyob rau hauv uas tsuas yog qhov chaw ntawm keeb kwm, kev qhia thiab ncua mus yuav tsum tau hloov thiab template yuav ua tau rau ib tug iguana nrog ntau tshaj ib nrab phaus ntawm tav.  Kuj ntawm no piv txwv txt.

Nws yuav tsum muaj cov cim qhia rau lub download, uas koj tuaj yeem ua nrog Credit card los yog Paypal.

14 Replies rau "Kos ib lub duab muaj ntau cov kabmob thiab qhov sib txawv ntawm Excel rau Microstation"

  1. Kas teie Trimble thiab PowerDraft vaheline expot / ntshuam thiab koodide mkm programmi teete?

  2. nws tsis cia kuv ua nws, hauv Microstation nws qhia kuv hais kom paub txog cov lus pom zoo

  3. Nyob zoo! Cov phooj ywg xav nug lawv, Kuv xav tau qhov kev pab cuam rau autocad 2015.the mdt 6 los sis yog tias koj tuaj yeem pab kuv kom intaries.grasias.

  4. Puas muaj leej twg qhia kuv yog tias tus qauv exell kom kos cov duab uas muaj autocad, puas tau tshaj txhua yam ntawm autocad los yog civil 3d?

  5. Nyob zoo cov phooj ywg, Kuv tau txais cov ntaub ntawv uas kuv tau thov, ua tsaug ntau ntau !!

  6. Messrs kojvie cov nyiaj rau Pay Pal tab sis kuv nrhiav tsis tau txoj kev uas yuav cia kuv download tau cov ntaub ntawv Excel rau microstation

  7. Yuav ua li cas Kuv tuaj yeem ua nws kom koj tsawg kawg ua qee qhov kev tshem tawm, xa rau kuv los ntawm email, muaj cov neeg pom tias nws nyuaj rau nws los ntawm kev them nyiaj… .ua tsaug koj thiab kuv zoo siab heev…

  8. Nyob rau hauv nplooj ntawv ntawm qhov website no muaj ib daim ntawv uas tso cai rau koj kos cov ntsiab lus ntawm cov hauj lwm hauv Excel

  9. HELLO YUAV UA LI CAS THIAB LWM LUB CORDENADA NTAWM SHEET NTAWM EXCEL RAU COV NEEG TSIS TXAUS SIAB AUTOCAD LOS UA NWS COV AUTOCAD MIO YOG 2007 THANKS

Sau ntawv cia

Koj email chaw nyob yuav tsis tsum luam tawm.

Qhov Web site no siv Akismet los txo cov kev pabcuam. Kawm li cas koj cov ntaub ntawv tawm tswv yim tiav.