LitefisoMicrostation-Bentleytopografia

Thala polygon ka mebala le maeto a tsoang Excel ho ea ho Microstation

Lilemong tse 'maloa tse fetileng ke ile ka hatisa sehlooho se bontšitseng mokhoa oa ho lumellana le data ho Excel ho theha leeto le AutoCAD, ntle le hore o tlameha ho etsa pholisi eohle:

@motswedingfm

Ka tsatsi le leng re ne re le tseleng ea AutoCAD motho e mong o ile a mpotsa hore na seo se ka etsoa ka mohala oa taelo ea Microsation. Karabo ke YES, o tlameha feela ho utloisisa hore Keyin ea Microstation ha e tšoane le mola oa taelo oa AutoCAD. Ha re boneng hore na e ka hahuoa joang, ha re feta re ithuta lintho tse nyane tse sa sebelisoeng haholo lenaneong lena:

Lebokose le ka ho le letona ke mohlala oa ho tšela ho itšetlehile ka li-bearings le libaka tse nang le sebopeho se latelang.

lebokose la lipalo le maeto li koetlisa microstation

Ka Microstation u ka atamela sena joalokaha ke hlalositse pele, ka bobebe bo totobetseng - le e tšoanang ea AutoCAD -, hore ho thata ho ngola mong le e mong, monyetla oa hore o fosahetse esita le hore thupelo e fetileng e sa tsosolosoa.

 

microwaves

 

Ha e le hantle, mokhoa oa ho lumellana hantle o ts'oana hantle eo ke e hlalositseng ka AutoCAD, o tlameha ho utloisisa ntho eo microstation e fapaneng ka eona.

Keyin e ne e sa hahuoa ho ipapisitsoe le ho etsa litaelo meleng e ngotsoeng empa bakeng sa ho letsetsa litaelo ka sepheo sa ntho, ka hona e tšehetsa feela litlhaku tse 56. Ntle le moo, ho hlokahala hore semicolon (;) e sebelisoe ho arola litaelo hobane, ho fapana le AutoCAD, e tsoang ho logic ea mantlha ea lenaneo, e tlisa mohopolo oa Clipper le seo Microstation e entsoeng moo ha e ne e ntse e bitsoa Ustation.

Ha ho fanoa ka sena, tsela e bonolo ka ho fetesisa ke ho letsetsa liodara ho tsoa faeleng ea mongolo ka taelo @ eo ke nahanang hore ke ba fokolang haholo ba e tsebang empa ke mokhoa oo Microstation esale e o sebelisa ho sebetsana le li-batch odara. Ho kenyelletsa kenya lintlha ho tsoa lenaneng la txt ke mdl ea etsang sena.

 

Ho sebelisa Letlapa la Excel leo pele ke neng ke le sebelisitse ho ruta mokhoa oa ho fetola ho tloha likoloi le maeto ho ea ho likopano, ke tla bontša hore na e tla hlalosa joang Microstation:

Qetella lintlha.

Seo re se thahasellang ke qetellong hore Kenya qetellong ke:

sebaka sa sebaka ;xy =374037.736,1580735.145;

Sebaka sa sebaka ke taelo ea ntlha, ho kenyelletsa sebaka, semicolon ke ho bonts'a tatellano e ngoe, xy = ke taelo ea ho kenya likhokahanyo mme likhokahanyo tse peli tse putsoa le tse tala ke lintlha tse tsejoang. Qetellong semicolone se secha ho supa kena kapa khato ho taelo e ncha.

Ka hona, ho nka lisele tsa thahasello ea ka li le U7 le V7 ho etsa qeto e tla ba:

=KOPANO("sebaka sa sebaka ;”,”xy =",U7",",",V7",";")

lebokose la lipalo le maeto li koetlisa microstation

Ka tsela ena, ke mpa ke kopitsa se ka hare ho faele ea AA ka faele ea txt, eo ke tla e letsetsa spikedpoints2.txt. Ke khothaletsa hore ba e kenye ka kotloloho ho C hore tsela ha e thata haholo.

Tabeng ena ke e beha litokomaneng tsa ka, tsela e tla ba: C: \ Users \ User \ Documents \ pointsandfumed2.txt

ho e tsamaisa, re sebedisa fensetere ea taelo ea taelo (senotlolo), sena se etsoa ho tloha Lisebelisoa> senotlolo sa ebe o kenya taelo:

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

Rea kena, 'me ke ena moo u nang le eona, lintlha tse huloang ka tatellano ea tsona. Ho bonolo ho ba le botenya ba mohala bakeng sa bona hore ba bontšoe.

 

lebokose la lipalo le maeto li koetlisa microstation

Tšoara mela.

Bakeng sa sena, ts'ebetso e ts'oana, taelo eo re lokelang ho e etsa ke mohala oa sebaka, ho phaella moo re bontša hore mola o na le ntlha ea tlhaho le ntlha ea ho etela.

mohala oa sebaka ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

=KOPANO("mohala oa sebaka ;”,”xy =“,U6,””,V6,”;”,”xy =“,U7,””,V7,”;”)

Re kopitsa le ho beha faele ea txt, ho e boloka le ho e sebetsa hape

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

'Me moo ba na le eona:

lebokose la lipalo le maeto li koetlisa microstation

 

'Me phaello e eketsehileng ke hore ho haha ​​lebokose la mebala le maeto ho hloka feela ho etsa khopi ho Excel, le pata ka Microstation. Ka peista e khethehileng u ka khetha pakeng tsa ho ba setšoantšo, spreadsheet e kentsoeng kapa e hokahaneng

lebokose la lipalo le maeto li koetlisa microstation

litaelo ho Lits'oants'o tsa microstationHo phethela sehlooho sena, Ke hlophisa mohlala ho file Excel, eo ho eona feela ntlha ea tlhaho, litaelo le maeto a lokelang ho fetoloa 'me template e ka ba molemo ho iguana leha e le efe e nang le likhohlo tse fetang halofo ea likhopo.  Hape mona mona mohlala oa txt.

E hloka monehelo oa tšoantšetso bakeng sa download, eo u ka e etsang Karete ea mokitlane kapa Paypal.

Golgi Alvarez

Mongoli, mofuputsi, setsebi sa Mehlala ea Tsamaiso ea Mobu. O kentse letsoho ho nahanoa le ho kenya ts'ebetsong ea mehlala e kang: Sistimi ea Sechaba ea Tsamaiso ea Thepa SINAP ho Honduras, Mohlala oa Tsamaiso ea Masepala a Kopanetsoeng Honduras, Mohlala o Kopanetsoeng oa Tsamaiso ea Cadastre - Registry in Nicaragua, System of Administration of Territory SAT in Colombia. . Mohlophisi oa blog ea tsebo ea Geofumadas ho tloha 2007 le moetsi oa AulaGEO Academy e kenyelletsang lithuto tse fetang 100 ka lihlooho tsa GIS - CAD - BIM - Digital Twins.

Related Articles

14 Comments

  1. Kas Teie Trimble ja PowerDraft vaheline expot / import ja koodide mkm programmi teete?

  2. ha a ntumelle hore ke e etse, ka Microstation o mpolella taelo ea ho kenya letsoho

  3. hello !!! metsoalle e ne e batla ho ba botsa, ke hloka lenaneo la autocad ea 2015.el 6 kapa haeba o ka ntsopeletsa ho intarlar.grasias.

  4. Na ho na le motho ea ka mpolelang hore na template ea exell e hula li-polygone ka autocad, e lumellana le phetolelo leha e le efe ea autocad kapa Civil 3d?

  5. Motsoalle ea ratehang, ke fumane faele eo ke e kōpileng, ke leboha haholo !!

  6. Mantsoe a kopa chelete ka Pay Pal empa ha ke fumane tsela ea ho ntumella hore ke kopolle file ea Excel bakeng sa microstation

  7. Nka ho etsa joang e le hore bonyane u tle u ikhethele, u nthomelle ka lengolo-tsoibila, ho na le batho ba thatafalloang ke ho e fumana ka ho lefa…. Kea leboha 'me re leboha haholo…

  8. Leqepheng la ho lata websaete ena ho na le lakane e u lumellang ho hula lintlha ho tsoa likopanong ho Excel

  9. LUMELANG KAMOO LE KE KOPANENG LITLHAKU TSE KHOLO HO AUTOCAD MEGUSTARIA E ETSA AUTOCAD MIO KE 2007

Siea ho hlahisa maikutlo

aterese ya hao ya imeile ke ke ho phatlalatswa. masimo a hlokahala a tšoailoe ka *

Konopo ea holimo