Microstation: Import Excel ezihambelanayo ezingachanekanga

Ityala: Ndineenkcukacha eziphakanyiswe nge-Promark 100 GPS, kwaye ngokusebenzisa isicelo se-GNSS emva kokuba izixhobo zinakho, ndingathumela ulwazi kwi-Excel.

Iikholam eziphawulwe ngephuzi zimpuma, izilungelelaniso ezisentla kunye nezichaso zazo; Eminye ingcaciso kuphela ephathelene nokuthunyelwa kweposi.

Ingxaki: Ndifuna ukuba abasebenzisi ngeenguqu zabo ze-Microstation ezinokungenisa idatha.

MicroStation uhlela excel

Izindlela zeSlug zokwenza

Ukuba uthengisa iinqununu kunye ne-Microstation kunye umyalelo okwenzelwe oku, amanqaku kuphela eza, hayi iilebheli. Ngendlela ende, umsebenzisi wayebangenisa kwi-CivilCAD eyenzayo ngokumangalisayo, emva koko kwavulwa iMicrostation kwaye yaguqulwa yaya kwi-dgn yeyiphi na ifomathi abasebenza kuyo yonke imihla ye-fucking. Ke… nangona ndiphantse ndihambeNdiyayibulela into yokuba undibuzile ngengcebiso yokuba ungayenza njani; nangona nzulu ngaphakathi ndicinga ukuba bayayenza ukubonisa ukuba imiyalelo ayina rusi. Yinkqubo nje endichaze ngayo ngaphambili nge-AutoCAD.

Indlela yokuqulunqa izilungiso kunye ne-Excel

Vba wayeza ngumnqweno, kodwa ke njengesiqhelo ngenye imini oko sithi: Excel kufuneka ibe nemveliso ngaphezu ukwenza iitafile yemivuzo, apha nenkqubo yokudibanisa imiyalelo Microstation (iqhosha in) kunye nemithetho Excel (concatenated)

Ukwenza inqaku ngeMicrostation kwenziwa ngomyalelo "indawo yendawo", kwaye ukuba ufuna ukuyibeka kulungelelwaniso oluthile, sebenzisa "xy =", uhlala usebenzisa isahluli soku-odola, esisemicolon (;). Ke, xa ungena kumyalelo indawo yendawo; xy = 388218.835,1566315.816 Ndifanele ndidwebe ingongoma kweso sidibaniso.

Kwimeko ye-Excel, i-concatenate command isebenza ngolu hlobo: concatenate command, open parentheses, emva koko ubonise yonke into ekufuneka yenziwe, kwaye ekugqibeleni usondele kubazali. Ndiyicacisa ngendlela ebukhali, kodwa ayinzima xa iqondwa kwaye yenziwe ubuncinci kube kanye:

Qinisekisa umyalelo = QHUBEKA sivula abazali ( ke umyalelo we-commando ngumbhalo, kunye ne-semicolon yayo eyahlula umyalelo Indawo yendawo; ke i-comma ukuhlukanisa umtya olandelayo , ngoko umyalelo kwiingcaphuno njengombhalo «Xy =» i-comma ukubonisa umtya omtsha , kwaye apha sikhetha i-cell efanelekileyo  C3 ngoko i-comma ukubonisa umtya omtsha , kunye ne-comma kwizicatshulwa zokwahlula «,» i-comma ukubonisa umtya olandelayo , iseli equkethe ulungelelwaniso lwasemantla kunye nesemicolon yokugqibela D3,«; )

Kuya kubonakala ngathi:

= QINISEKA («indawo yendawo ;«, "xy =«,C3, ",«,D3, ";«)

Xa sele senziwe, siyakhuphela ifom elandelayo kwiikholamu ezilandelayo:

indawo yendawo; xy = 388218.835,1566315.816;
indawo yendawo; xy = 388219.911,1566320.28;
indawo yendawo; xy = 388216.28,1566320.868;
indawo yendawo; xy = 388215.36,1566316.473;
indawo yendawo; xy = 388211.706,1566317.245;
indawo yendawo; xy = 388212.713,1566321.593;

 

Indlela yokuyithumela kwi-Microstation

Lo mbhalo unokukopishwa kwaye ugqitywe ngqo kumgca womyalelo (ukhiye osebenzayo) kwaye ubone ukuba amaphuzu adwetshiwe.

MicroStation uhlela excel

Kodwa ndinokuyikopisha kwakhona kwifayile ye-txt okanye csv engayifumana njengesikripthi.

Umzekelo, ifayile ibizwa phobiafreedom.txt, kwaye igcinwe ku-C; ngoko ukubiza ukuba uthayiphe iqhosha  @c: \ sweetpots.txt. Igama akufuneki libe nezikhala, kwaye kukhethwa ukulibeka kwindlela elula.

Indlela yokungenisa izichasiselo

Isebenza ngendlela efanayo, ngokwahlukileyo ukuba umyalelo awunanto kodwa icatshulwa yombhalo:  icwecwe lombhalo

I-Concatenamos ifomu elilinganayo, umyalelo wendawo yombhalo, iseli equle i-annotation, iququzelela apho umbhalo uya kufakwa khona:

= QINISEKISA («indawo yomfanekiso wokubhaliweyo;», B3, »;», »xy =», C3, »,», D3, »;»)

Kwaye kufuneka sihlale njengale.

uphawu lwetekisi; 10; xy = 388218.835,1566315.816;
uphawu lwetekisi; 11; xy = 388219.911,1566320.28;
uphawu lwetekisi; 12; xy = 388216.28,1566320.868;
uphawu lwetekisi; 13; xy = 388215.36,1566316.473;
uphawu lwetekisi; 14; xy = 388211.706,1566317.245;
uphawu lwetekisi; 15; xy = 388212.713,1566321.593;

Kwaye banakho;

MicroStation uhlela excel

Ukwenza ukuwela, kuya kwenziwa okufanayo, kodwa ngomgca wendawo yomyalelo, ngononophelo lokuba amanqaku kufuneka alandelane; ayisiyiyo le meko. Ingayindawo yomyalelo wokuyalela, qala ulungelelwaniso, indawo yokulungelelanisa

Ngokuqinisekileyo zikho ezinye iindlela zokwenza, kunye neenkqubo zomthombo ovulekileyo ezenza ngokumangalisayo. Kodwa ukwenza umthambo kuluncedo ekuhleleni ingqondo yam kwaye kwimeko yam, kuthintela imiyalelo yam kurhwaphiliza.

6 Impendulo kwi "Microstation: Ukungenisa izilungelelwaniso kunye nezichaso ezivela kwi-Excel"

  1. Molo mhlobo, ulwazi olugqwesileyo, ndikwazile ukuvuselela kunye nokusombulula imeko endicinga ukuba ayinakwenziwa kwi-microstation, ndinombuzo onxulumene nesihloko esixoxwe ngasentla, ndingenisa njani isangqa endaweni yenqaku njengesalathiso esifanelekileyo ? Ndenze onke la manyathelo akhankanywe apha ngasentla ndisebenzisa njengeparameter: = CONCATENATE («indawo yesangqa;… ..) emva koko ndasiwa kwi-.txt kwaye kamva ndasiwa kwisitshixo njenge @d: \ circle.txt, kodwa khange ndikwazi ukuzoba igrafu, Ndincede kule nkalo?

    Ukubulisa

  2. Molo, molweni ekuseni, ndingathanda ukwazi ukuba unesifundo okanye uqaphele ukuba ungayenza njani inkqubo yokuposa emva kwe-promark 200 gps kwinkqubo yezisombululo ze-GNSS? Kudala ndizama iintsuku kodwa khange ndikwazi kuba i-gps indiphosa .csv iifayile ... Ndilinde impendulo yakho, enkosi.

  3. Kulungile, kulungile, ndiyakuxelela ukuba abaphumeleleyo abakhange beze kumasifundisane kwaye ukufika kwam bendifuna ukubakholisa ngoncedo lwabo, endaweni yoko bazilungisile ezinye izinto, ndaye ndoyika ukubabuza kwangoko ukuba benze njani ... hehe uthi uVictor simkhangela kwiigeofumadas ... Kuhle ukuba uhlala esixhasa kuba ebesoloko eyinkosi yam kule nto, kwaye khange ndiyenze njengovavanyo endiyenzileyo kuba ndibonile ukuba abanokuqonda kancinci okanye akukho nto ngembuyekezo ekufuneka yenziwe nge-civilcad kodwa eneneni wonke umntu kwi-workshop wayechukumisekile ...

    oku kusinceda sikhiqize umgangatho omkhulu kwiwaka lamaqhinga angenziwa ngePC, kodwa isikhokelo soloko siyimfuneko ukuba sikwazi ukufunda.

    egameni lamagcisa akuthandayo, kuba kufuneka ndixelele indlela epholile ngayo ishizi.

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.