Thala lintlha, mela le litemana tsa polygonal ho tloha Excel ho AutoCAD

Ke na le lenane lena la likhokahano ho Excel.

Ho tsena ho na le khokahanyo ea X, khokahanyo ea Y, hape le lebitso la vertex. Seo ke se batlang ke ho se taka ho AutoCAD. Tabeng ena, re tla sebelisa ts'ebetso ea mangolo ho tsoa ho mongolo o kopantsoeng ho Excel.

Tšoara taelo ea ho kenngoa ha lintlha ka AutoCAD

Tafole e bontšitsoeng ka graph, kamoo u ka bonang kateng, e kenyeletsa mohala o nang le lebitso la vertex, joale UTM e hokahanya bakeng sa likarolo X, Y.

Ntho ea pele eo re tlamehang ho e etsa ke ho tiisa likhokahanyo kamoo taelo ea AutoCAD e li lebelletseng. Mohlala, ho hlahisa ntlha eo re tla e nka: POINT coordinateX, coordinateY.

Kahoo, seo re tla se etsa ke kenya mohala o mocha le data ena e nkiloeng, ka foromo:

POINT 374037.8,1580682.4
POINT 374032.23,1580716.25
POINT 374037.73,1580735.14
POINT 374044.98,1580772.49
POINT 374097.77,1580771.83
POINT 374116.27,1580769.13

E le hore ke etse sena, ke entse se latelang:

• Ke bitsitse cell D4 ka lebitso POINT,
• Ke thehile ka ts'ebetso ea concatenate, khoele e kenyelletsang sele ea POINT, joale ke siile sebaka ke sebelisa "", joale ke kopantse sele ea B5 ka ho pota-pota ka likarolo tse peli, ebe ke hula comma eo ke e sebelisitseng "," , joale ke concatenated cell C5. Ebe ke qopitsa mela e setseng.

Tlosa lintlha ho Excel

Ke kopile se ka hare ho karolo ea D ho file file.

Ho e tsamaisa, o thaepa SCRIPT ka har'a bareng ea litaelo, ebe o kenya konopo ea Enter. Seo se phahamisa mofuputsi mme ke batla faele eo ke e bitsitseng geofumadas.scr. Hang ha e khethiloe, konopo e bulehileng e tobetsa

Hape, mona, re na le lintlha tse huleloang.

Haeba lintlha li sa bonahale, ho hlokahala hore o nyenyele ho sete e felletseng ea lintho. Bakeng sa sena re ngola taelo Katametso, kena, Boholo, kena.

Haeba lintlha li bonahala li sa bonahale, taelo ea PTYPE e etsoa, ​​joale e bontšitsoeng setšoantšong e khethiloe.

Tšoara taelo ea Excel ebe u hula polygon ka AutoCAD

Ho taka polygon e tla ba mohopolo o tšoanang. ka phapang ea hore re tla nka taelo ea PLINE, ebe likhokahano tse lumellanang mme qetellong ke taelo ea CLOSE.

PLINE
374037.8,1580682.4
374032.23,1580716.25
374037.73,1580735.14
...
374111.31,1580644.84
374094.32,1580645.98
374069.21,1580647.31
374048.83,1580655.01
MOTSOALLE

Re tla bitsa script ena geofumadas2.scr, 'Me ha re e phethahatsa re tla ba le mohlala oa setšoantšo. Ke khethile 'mala o mosehla ho hlokomela phapang le li-vertices tse khubelu.

Tšoara taelo ea Excel mme u hlokomele lintlha ka AutoCAD

Kamora nako, re lula re hlalosa litemana tsa kholomo ea pele e le litlhaloso ho vertex ka 'ngoe. Bakeng sa sena, re tla tlama taelo ka tsela e latelang:

TEXT JC 374037.8,1580682.4 3 0 1

Taelo ena e emela:

• Taelo ea TEXT,
• Boemo ba temana eo, tabeng ena e lokile, ke kahoo lengolo J,
• Ntlha e bohareng ea temana eo, re khethile Center, ke kahoo lengolo la C
• Khokahano ea concatenated X, Y,
• Ka nako eo boholo ba temana eo, re khethile 3,
• Palo ea potoloho, tabeng ena 0,
• Qetellong temana eo re e tšepileng, hore molaong oa pele e tla ba palo ea 1

E se e phatlalatsoa lisele tse ling, e tla ba ka tsela e latelang:

TEXT JC 374037.8,1580682.4 3 0 1
TEXT JC 374032.23,1580716.25 3 0 2
TEXT JC 374037.73,1580735.14 3 0 3
TEXT JC 374044.98,1580772.49 3 0 3A
TEXT JC 374097.77,1580771.83 3 0 4
TEXT JC 374116.27,1580769.13 3 0 5
TEXT JC 374127.23,1580779.64 3 0 6
...

Ke e bitsitse geofumadas3.cdr file 

Ke kentse 'mala o motala ho bona phapang. Hang ha script e etsoa, ​​re na le mongolo ka boholo bo bontšitsoeng, bohareng ba khokahano.

Kopanya e Fuputso ea AutoCAD e sebelisitsoeng mohlaleng ona.

Sengoloa se bonts'a hore na template e hahiloe joang. Haeba u sebelisa template ho Excel, e seng e ntse e hahiloe feela ho fepa data, U ka e reka mona.