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, kuphela kuphela amaphuzu, kungekhona amalebula. Ngeendlela ezide, umsebenzisi wabangenisa kwi-CivilCAD, ebenzi kakuhle, ngoko kuvela kwi-Microstation yavulwa kwaye yaguqulwa kuyo ifomathi apho yonke imihla isebenza. Ngoko ... nangona ndiphantse ndihambe, Ndiyakuxabisa ukuba undicelile ukuba ndicebise indlela yokwenza ngayo; nangona unzulu ngaphantsi ndicinga ukuba bayayenza ukuba baqinisekise ukuba imiyalelo ayinqunywanga. Yinto nje endiyichazayo 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)

Ukudala inqaku ngeMicrostation kwenziwa ngomyalelo "wendawo yokubonisa", kwaye ukuba ufuna ukuyibeka kulungelelwaniso oluthile, sebenzisa "xy =", uhlala usebenzisa umhlukanisi womyalelo oyisemololon (;). Ke, xa ungena kumyalelo indawo yendawo; xy = 388218.835,1566315.816 Ndifanele ndidwebe ingongoma kweso sidibaniso.

Kwimeko ye-Excel, umyalelo we-concatenate usebenza ngale ndlela: umyalelo wokubambisana, abazali abavulekileyo, uze ubonise yonke into eya ku-concatenate, kwaye ekugqibeleni ngabazali abavaliweyo. Ndiyichaza ngokukhawuleza, kodwa akunzima xa kuqondwa kwaye kwenziwa okungenani 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 eququzelele ukulungelelanisa ngasenyakatho kunye ne-semicolon 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 akufanele libe neendawo, kwaye kulungele ukuyibeka ngendlela 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 umzila, into efanayo iya kwenziwa, kodwa ngomyalelo wendawo, ngokuqaphela ukuba amanqaku kufuneka alandelelanise; akusiyo le meko. Ingaba ngumyalelo wendawo yokuqala, qalisa ukulungelelanisa, ukujolisa ekujoliswe kuyo ...

Ngokuqinisekileyo kukho ezinye iindlela zokwenza oko, kunye neenkqubo ezivulekileyo ezivela kuyo. Kodwa usebenziso luncedo ukukhawulezisa ingqondo kwaye kwimeko yam, thintela ukugquma imiyalelo.

I-6 iphendula kwi- "Microstation: Ngenisa unxibelelaniso kunye neenkcazo kwi-Excel"

  1. Molo mhlobo, ulwazi olugqibeleleyo, ndikwazile ukuvuselela kwaye ngcono ndisombulula iimeko endicinga ukuba zingenziwa kumbhobho, ndinombuzo ohambelana nesihloko esixoxwe ngentla apha, ndingenisa njani isangqa endaweni yenqaku kunye nesalathiso ? Ndenze onke la manyathelo akhankanyiweyo ngentla ndisebenzisa ipharamitha: = QINISEKA ("isangqa sendawo; ... ..) emva koko sathathelwa ku .txt emva koko sathathwa sangena kwiqhosha njengo @d: \ circulo.txt, kodwa andikhange ndikwazi ukuyigraza. ndincede kulento?

    Ukubulisa

  2. Sawubona, kusasa ekuseni, ndingathanda ukwazi ukuba unayo isifundo okanye inqaku malunga nendlela yokwenza i-postprocess ye-200 gps kwisisombululo se-GNSS ?? Ndibe ndizama iintsuku kodwa andinakukwazi ngenxa yokuba i-GPS iphosa iifayile .csv ... Ndikulindele impendulo yakho, mbulela.

  3. Good, ngokuba ndithi kuni, ukuba ivenkile ayizange ifike Victores Ke xa ndifuna ukubonisa nabo ngoncedo lwenu, kwaye kunokuba ndayiqhela kwezinye izinto, ndaza freaked ebabuza nangoko njengoko babenzile ... Heh Heh indixelela victor look for kuyo egeomates ... into elungileyo sisoloko inkxaso kuba bekusoloko inkosi yam le, plus andizange uzame ndakwenzayo kuba wakhangela Ndikwazile ukuqonda nto encinane okanye vuelterio ukuba kwafuneka yokwenza Civilcad kodwa ngokwenene wonke kumasifundisane bachukumiseka ...

    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.