Ishadi Lemilayezo Nezindawo ezihamba nge-Excel nge-Microstation

Saqala ezinsukwini ezimbalwa ezedlule sikhuluma mayelana nokuthi singakwenza kanjani lokhu, kodwa senza ukungena ngemvume I-Excel ye-AutoCAD noma kusuka ku I-CSV ku-Microstation; womabili amabombo kanye nezixhumanisi. Ngaleso sikhathi kwaphakama ukungabaza Uma kuzoba nohlelo olungadingi ukunamathiselwa kwamakhophi, kepha oluzosebenzisana nelogi ye-Excel futhi esikhundleni samaphoyinti luzokhiqiza imigqa, ngemuva kokusesha ngikhathele, futhi impela kuningi i-mdl yeMicrostation neLisp ye-AutoCAD ... ngeshwa angikutholanga okuningi ... lokho kuzosebenza

Okuwukuphela kwami ​​engingayithola kuyisicelo esakhiwe ku-Visual Basic ye-Moicrostation V8 ebizwa ngokuthi Rumbosdisttoexcel.mvba, ungayilanda kufomethi ye-zip kusuka lapha.

I-1. Indlela yokuyilayisha

• Ngemuva kokulanda kufanele uyivule
• Ukuyilayisha, yenza okulandelayo: izinsiza / imacro / umphathi wephrojekthi / umthwalo weprojekthi / funa uhlelo lokusebenza lapho ulugcine khona bese ukhetha ok

I-2. Indlela yokwenza ngayo

• Uma usuyilayishile, uyikhetha kuMphathi Wephrojekthi bese usebenzisa inkinobho yomcibisholo oluhlaza “amamakhro”
• Bese ukhetha uhlelo lokusebenza "RunApplication.runMainMenu"
• Usebenzisa inkinobho "run".
• futhi iphaneli enjengale izovela

I-3. Lokho isicelo esenzayo

Lolu hlelo lokusebenza lunemisebenzi emibili, kokubili basebenza ne-Microstation Geographics.

• Thumela ku-Excel, ngenxa yalokhu, yenza ucingo olufaka i-polygon, bese ukhetha okukhethwa kukho kwe-Export
• Lokhu kudala ifayela ku-Excel, lapho ukubheja, amabanga kanye nezixhumanisi ze-UTM zihlukaniswa.
• Ngesikhathi esifanayo ubeka ama-vertices kuya ku-polygon eqala ngeyona eningi eningizimu-ntshonalanga.
• Ibuye ikuvumele ukuba wenze okungafaniyo, kusukela ku-data ku-Excel ungavuselela i-polygon.

Le vidiyo Ibonisa ukuthi isebenza kanjani.

Uma othile efuna ukuyizama, ayilande futhi angazise uma ikunikeza izinkinga ... kubi kakhulu ukuthi i-VBA inephasiwedi, uma othile elinga ukuyiphula ... kungenzeka ukuthi ayinike amandla amakhulu.

Ngiyaqonda ukuthi kufanele isebenze neMicrostation ejwayelekile, yize ngokusobala idinga iMicrostation Geographics ngephrojekthi evulekile, noma ngubani. Akufanele futhi ngesihleli se-Visual Basic seMicrostation kufanele kube khona ukususa leyo ngxenye ... impela, ngalokho kufanele wephule iphasiwedi.

Imisebenzi elindile:

• Zama futhi ungitshele
• Umuntu kufanele azi ukuthi angaphonsa kanjani iphasiwedi, ngoba isicelo sishisa kakhulu
• Uma othile ekwazi mayelana nesicelo, kuyokwamukeleka