Kusuka ku-Excel kuya ku-AutoCAD, isifinyezo sezinto ezihamba phambili
Ngiyavuma ukuthi kuye kwaba mnandi ukukhuluma ngalesi sihloko, ngakho kulokhu okuthunyelwe ngifuna ukukhombisa okungcono kakhulu esikutholile.
- Sibone ukuthi i-Microstation uye wahlanganiswa ukusebenza okungeniswa ngqo kwifayela le-txt
- Siphinde sibone ukuthi kanjani yenza nge-AutoCAD
- Sibone indlela thekelisa kusuka ku-AutoCAD o Microstation kuya csv noma txt
- Sabe sibona ukuthi singayisebenzisa kanjani umyalo concatenate uma kunezikhombisi-ndlela nezindawo ezikude kakhulu
- Futhi sibonile a Isicelo se-VBA for Microstation esebenza kokubili amathrekhi
Kodwa okungcono kunakho konke ukufundela kumuntu othile okukhulunywe ngaye ekutshuleni kwakhe ngaleli thuluzi evumela ukuthi kusuka efayeleni elidlula ukukhiqiza ifayela le-dxf, usebenzisa izixhumanisi ze-x, y, z, ikhodi yokuhlonza kanye nezinga lapho sifuna ukuthi idonseke.
Uhlelo lokusebenza lubizwa nge-XYZ-DXF futhi ungakwazi landa lapha;
Ake sibone ukuthi kusebenza kanjani:
I-1 Idatha yemvelaphi:
Lolu hlelo lokusebenza lufanele imininingwane elandwe kusuka ku-GPS noma esiteshini esiphelele, inqobo nje uma izixhumanisi ziyi-UTM, kusho ukuthi amayunithi ayo endizeni yeCartesian akumamitha. Ikholomu yekhodi iyisihlonzi sephoyinti, bese i-x, y, z ixhumanisa futhi ekugcineni ungqimba esifuna badwetshwe kulo, lokhu kungaba, ngokwesibonelo, i-eksisi yomgwaqo, izihlahla, imingcele, i-polygonal noma esinye isici esizovumela kamuva hlunga idatha ku-AutoCAD noma kwi-Microstation.
* Wonke amaphuzu kumele abe nekhodi.
* Wonke amaphuzu kumele afakwe ngemuva komunye, ngaphandle kokushiya imigqa engenalutho.
Ukubukwa kwedatha
Sibonga uJuan Manuel Anguita, Umdwebi Wezithombe Zomhlaba waseJaén, eSpain owenze umzamo wokwakha le macro. Ifayela le-Excel linamashidi amathathu, elinye lawo elibizwa ngokuthi Buka kuqala likuvumela ukuthi ubone igrafu ekubukeni kohlelo, kanye nokubukwa okuseceleni (eyakhelwe kugrafu ye-Excel emsulwa!). Futhi ngalinye kulawa maquadranti angu-9 lingabukwa, uma kushintsha idatha kuthebula kusetshenziswe inkinobho ethi "buyekeza ukubuka"
Lungiselela idatha yokuthumela
Ishidi lesithathu elibizwa ngokuthi okukhethwa kukho, lisenza sikwazi ukuchaza uma ifayela esizolithumela lizohamba ngobukhulu obukhulu noma abathathu, ubukhulu bombhalo, uma sifuna ukukhombisa ukuphakama (ubukhulu) negama lefayela le-dxf.
Lapho inkinobho ebubende icindezelwe, ifayela le-.dxf liyakhiwa, elingavulwa nge-Microstation, Arcview, AutoCAD noma cishe noma yiluphi uhlelo lwe-CAD. Kulokhu, kudalelwa ungqimba wombhalo ngamunye ohlukile otholakala kukholomu ye 'Layer' (isb: lev), lapho amaphuzu azoba khona; Kuzoba futhi nolunye ungqimba igama lalo okuzoba umbhalo wekholomu 'Layer' + txt (isb.: Levtxt), lapho amakhodi ezoba khona, futhi kuzokwakhiwa elinye, lapho ubukhulu bayo bube khona, negama 'umbhalo we Ubukhulu bekholomu 'Layer' + (isb: levcotas). Ifayela elihamba phambili elinegama elifanayo nasendaweni efanayo nalo liyakhiwa.
Ifayela lokuya (dxf)
Lesi yisibonelo sefayela elibukwe ku-AutoCAD. Ngemuva kwalokho ungashintsha imibala yezendlalelo (ifomethi / izingqimba) noma ifomethi yephoyinti (izitayela zefomethi / zephoyinti).
Kumane nje kuyisicelo esihlaba umxhwele, sokuthi sisebenziseka kanjani futhi kulula ukusiphatha. Ayidwebi imigqa, ithumela amaphuzu kuphela.
Nge-AutoCAD kuphela, lokho akunakwenzeka.
Ungakwazi, uma ungenisa ithebula njenge-database ku-AutoCAD izinguqulo njenge-Civi3D.
Noma uma wenza i-macro ne-AutoLisp enikeza ithebula.
Ngikwazisa ungase ungisize nge isihloko search izwi excell e AutoCAD ka isithombe, uwathole futhi ushintshe umbala, Ngithemba ungakwazi, ukubingelela.
Uhlelo oluhle kakhulu
Gracias
EXCELLENT !!!! THANK YOU ..
Ngithola iphutha 1004 ngesikhathi sokusebenza….
okungalungile ngobuqotho nale Macro akuphelele ngoba engafuni uqobo ingasetshenziswa izikhathi eziningana, TN kanye kuphela futhi lokhu kwenza ukuba Okuqukethwe akuzwakali noma kungenzeka ingasetshenziswa kodwa futhi wazama ukwakha amafayela amaningi kodwa uthi ifayela lisetshenziswa olunye uhlelo ????????
Sawubona Juan MAnuel
Ngangifuna imininingwane yokwenza iphrojekthi engangiyicabangayo futhi ngithole leli fayela.
Yebo, angiyona isazi ngempela ekuthuthukeni, kodwa nginomqondo wokweqa ukuzenzekela kwe-geometric design of roads ngokusebenzisa umhleli oyisisekelo we-excel.
Inhloso ukubala izakhi ze-geometri zezingqikithi ezahlukene kanye nalawo maqiniso engiwathola njengama-xls, ngiwaguqule kwifomathi ye-ascii ukuze ngiwafeze ku-cad kanye ne-platform yesikhungo se-microstation.
Futhi yilapho engikwazi ukuqhubeka khona, angikwazi ukukwenza. Kusuka kulokho engikubona unemiqondo eminingi yalowo futhi mhlawumbe ungangisiza
Ngingathanda futhi ukwakha ikhodi ukuze ngidle lapho ngiyakwazi ukubona ngeso lengqondo ijika ngaphakathi kwegrafu elihle kakhulu ngaphambi kokuthumela idatha kuma-platforms ahlukene.
Ukuze unakekele, ngiyabonga kakhulu
Kumele usebenzise imephu ye-AutoCAD noma i-Civil 3D yalokhu.
Uma ungenayo, sebenzisa uhlelo lokuvula njengeQGis noma gvSIG
Hola
Ngiyazi ukuthi akudingeki ukuba yenze kahle ngalesi sihloko, kodwa uma othile engangikhombisa ukuthi ngingayithumela kanjani amafayela autocad ku-KML futhi ngibeke imidwebo kwi-gmaps.
Siyabonga futhi sibheke kahle
akukho okuhle kungitshela ukuthi kufanele ngiphumelele
NGIYABONGA NGOKUBAMBISANA oyifundayo kodwa UMA KUPHELA ISEBENZA NJENGO UKWENZE Podro esebenza KUNGABA NOMA 2003 2007 EXCEL Nami nginenhliziyo ezinye KUYI EXCEL AUTOCAD NGAPHANDLE Lean
Usizo
umuntu angangisiza
Umnikelo omuhle kakhulu !! Ngidinga nje ukuthi ufunde amaphuzu angaphezu kwe-1000, ngiyabona ukuthi ivikelwe ... ngikwazile ukubeka amaphuzu afinyelela ku-950, kepha nginezixhumanisi zamaphoyinti angaphezu kwama-5000 ... ngeshwa ingitshela ukuthi ivikelwe nge-password .. Kepha umnikelo omuhle kakhulu! Ngiyethemba umbhali uyakubona lokhu futhi angakhuphula inani lamaphuzu ukuze akwazi ukungena ..
Ukubingelela kubo bonke!
Siyabonga kakhulu ngokusinika isicelo esihle kangaka. Ngiyajabula kakhulu nomsebenzi, umbuzo: Kungenzeka yini ukuhlanganisa ibhulogi ngephuzu ngalinye, isibonelo umbuthano? Uma kunjalo, ungangitshela ukuthi iyiphi indlela.
Ngiyabonga kakhulu
UPatrick
kakhulu ezinhle, lokhu ukusebenza ishidi le-Excel, umbuzo ngokuvumelana ukuhlolwa engikwenzele lesi yanciphisa inani lamaphuzu ukuba graphed, ngokuqondene nami ngidinga ukwenza amagrafu mayelana 4000 amaphuzu njengoba engingakwenza ukushintsha lokhu Excel weThebula njengoba Kungangithatha isikhathi esiningi sokuhlehlisa isigaba.
ngiyabonga kakhulu
Ngithumela siyakuhalalisela sami esiqotho umbhali, kuba usizo olukhulu ukuze abahloli, ngethemba ukuthi ngizoqhubeka ukubamukela abanjalo EZOBUCHWEPHESHE AIDS ukuthuthukisa ngokwami ngendlela echwepheshile esikhathini esizayo.
UDouglas ... ku-AutoCAD kufanele uvule ifayela livuleke,
ngohlobo lwamafayela we-seleccionas dxf
Ukhetha ifayela elakhiwe ku-C futhi
Ready !!!!!
Uma isebenza ku-2007, uma uvula ifayela libonisa isixwayiso sokuphepha, kufanele ukhethe
Izinketho ...
Nika amandla lokhu okuqukethwe futhi
ukwamukela
Uma ubhekisela kufayela le-Excel eliboniswe esibonelweni, uma usuwafakile izixhumanisi, cindezela inkinobho ensomi enombhalo ophuzi: “cindezela ukuze udale i-dxf”
Ngifuna ukwazi ukuhambisa idatha kusuka etafuleni ngendlela engcono kakhulu ku-autocad, yimuphi umyalo ongayisebenzisa.
Ngingathanda ungisize ... ngizama ukuthola uhlelo lokusebenza noma inqubo ku-lsp. Ungathumela ngayo imibhalo kusuka ku-.dwg kuye ku-.xls kuphela imibhalo oyikhethayo negundane futhi ngasikhathi sinye ungafaka idatha ngekhibhodi uma kungenzeka ungawutholi umbhalo emdwebeni. nokuthi imibhalo ethunyelwa kwamanye amazwe ayikhethiwe uma ingangivumeli ukuthi ngiyikhethe kaningi ngangokunokwenzeka.
Nginalo mkhuba
(defun C: I-TXTOUT (/ va vb vc vf vg vg); i-V1.0
; Ngu-Scott Hull, i-11-20-86
; I-SAH Mechanical Design (415) i-343-4015
; Ukuthumela kwe-ASCII umbhalo kuya kufayili.
(defun *error* (st) (prompt (strcat “iphutha: ” st “07\n”)))
(setq iya (getstring "Igama lefayela le-ASCII elizokwakhiwa:") i-vb (i-open iya "r")
(uma / / vb nil) (ukuxolisa (vv vb) (setq vc (ascii (strcase (getstring
“Ifayela elinaleli gama selivele likhona.\nIngabe ufuna ukulishintsha? ")))))
(setq vc 89))
(uma (= vc 89) (phenya
(setq vb (vula va “w”) vd (ssget) ve (sslength vd) vf 0)
(ngenkathi (
Angazi isihluthulelo, umbhali wayilondolozile. Kodwa akukuvimbeli ekukopheni amangqamuzana
Ukuze ukwazi ukukopisha nokunamathisela ikholomu yedatha kusuka kuspredishithi lokhu kungitshela ukuthi amaseli avikelekile, futhi angazi ukuthi iyiphi isihluthulelo sokuxazulula le nkinga, uma uyazi ukuthi ngizobonga kakhulu
Sanibonani bangani, ukuze nikwazi ukuyisebenzisa ehhovisi 2007 kufanele nje niyiguqulele enguqulweni, kusithonjana esingenhla kwesobunxele kuyindlela yokukhetha, QHAWULA U-ALLI. Ngemuva kwalokho uyinika ukwamukela. Lapho icela inketho yokuvala nokuvula incwadi, chofoza u-YES. Ikuxwayisa ukuthi ushintsho olungalondoloziwe luzolahleka, lokho akunandaba, kwamukelwa kuphela futhi manje (Uma le nketho INGABONI, kungcono). Ngaphambi kokusebenzisa i-macro kufanele uqaphele ngezansi kwemigoqo yemenyu ISEXWAYISO SEZOKUPHEPHA: Okunye okuqukethwe okusebenzayo kukhutshaziwe, YIYA KOKUKHETHA FUTHI UCHofoze Vumela lokhu okuqukethwe bese u-voila…. USUNGAYIVAYELA NJENGO-OFFICE 2007.
LUCK TO ALL !!!!! (UNGAFUNA UKUTHI UKUKHETHA KWAMACACI KUFANELE KUHLELELE KANYE NOKUBHALISA)
Uma usho ukuthatha okuqukethwe, khetha umbhalo ku-Excel, ukopishe, bese u-AutoCAD, unamathisele
Kuhle njengoba bonke babukeka embuzweni wami yilokhu okulandelayo ukuthi kudlule kanjani i-fucking exel, ku-auto cad kodwa kumbhalo?
Ifayela elihle kakhulu Ukubingelela kumfana oshiye leli fayela, ukuze abone ukuthi ukukhishwa okwengeziwe kukhishwa.
awudingi ukuwuguqula, vele ufake idatha.
Lolu hlelo lokusebenza luvikelwe ngephasiwedi, umbhali akwenzile
Ngiyabonga, angikwazi ukuguqula izinketho engizibuzayo ngephasiwedi yokuhlola engingayenza kulokhu
g! noma othile, ngisebenza emdwebeni wesitaladi, cishe njalo ngikwenza ngesiteshi esiphelele kodwa manje ngilethe idatha yethrafikhi nezinga (izingxenye ezihambayo) ingabe kukhona umuntu owazi ukuguqula le datha ku-UTM? Ngine-axis ecacisiwe nokufundwa kwezigaba ubude obude obusele ngakwesokunxele ku + noma-, isikhungo sendawo, amabanga ukuphakama okulungile ku + noma-... uma othile engisiza jcpescotosb@hotmail.com
Lesi sibalo sibonga kakhulu kubo bonke abenza lezi zintuthuko zenzeka.
Phendula ngokucaphuna
Ngiyabonga ngifuna indlela yokwakha i-polygon futhi ngiyilungise kodwa ku-arcgis.
Okokuqala, bonga umdwebi we-togographer uJuancho nge-macro nangekhehla! yokuyithola nokuyishicilela ... yeka umnikelo omkhulu lowo !!!!!
ifayela lidala ku c:
lapho udala ifayela le-dxf
hhayi funciona
IMISEBENZI IN IHHOVISI 2007 NGASO SONKE ISIKHATHI ME ME OUT IPHUTHA FUTHI ITHI ukuthekelisa kwifolda ku CY lutho uyaphuma ngithola ifasitela PERUTRAR KANYE Ungangitsheli OKUMELWE UKWENZE SDE
Uxolo, angazi ukuthi kuzoba yini
Siyabonga ngokuphendula kwakho okusheshayo, galvarezhn. Ngeshwa ayizange isebenze.
iphutha lokubuka kuqala, kubonakala kimi ukuthi kungenzeka kungenxa yokulungiswa kwesifunda, ukuthi ukwahlukanisa izinkulungwane namadesimali (ama-semicolon) kushintshiwe, hlola ...
kubonakala kuthakazelisayo, ngoba ku-intanethi; Ngizobona uma ngenza isibuyekezo ngosuku olulodwa ngalokhu
ngiyabonga ngolwazi
Ngithole isicelo sewebhu samahhala sombhalo kuya ekuguqulweni kwe-dxf
I-PASS TEXT X, Y, ZA DXF (TOPOGRAPHY)
http://www.konstruir.com/topografia/
Uma izinga lokuzethemba le-macro lilungisiwe, ispredishithi nokho ibonisa namanje umlayezo wephutha kuthebhu yesibili (PREVIEW).
Nakuba uqhubeka ukuthumela amaphuzu ku-dxf, ngingathanda ukunika amandla ngokugcwele ukusebenza kwaleli paspredishithi yakamuva.
Siyakuhalalisela,
ukulungisa izinga lokuzethemba
uya kunkinobho ye-excel, eyokuqala phezulu kwesokunxele, bese ukhetha inkinobho ethi "izinketho ze-excel",
bese ukhetha okuthi “trust center”
futhi lapho ukhetha "lungiselela isikhungo sokuthembana"
bese ukhetha "izilungiselelo ze-macro"
futhi lapho ukhetha "vumela wonke ama-macros"
Lapho ngibeka khona izinga lokuzethemba ku-2007 kakhulu
Ngikuhalalisela futhi ngikutshela ukuthi kusebenza kahle ku-ecxel 2007 kuphela ukuthi kufanele ulungiselele i-exel ezingeni lokuzethemba nokulungele
I-OFICCE I-2007 AKUSEBENZISI, NOMA NOMA PHENOMONONI NJENGOMUNYE OTHAKA ISICELO NOKUQALA IT. THANKA
kuya okuhle, khona-ke hamba ukuguqula ukumiswa kwesifunda kumshini wakho
qala / control panel / ukumiswa kwesifunda
bese ukhetha izwe lakho ezikhethweni zesifunda
lapho qiniseka ukuthi isihlukanisi sezinkulungwane sisungulwa ngophawu "ukhefana" namadesimali ano"chashazi"
bese uya phambili futhi kufanele usebenze
Isebenza ngaphandle kwamadesimali …… kepha lapho izixhumanisi bekungeke kube ngqo endizeni… .. amakhoba, ungicebisa ini ???
zama ukufaka izixhumanisi ezizungezile, okungenakuqhathaniswa ukubona ukuthi akuyona inkinga yokucushwa kwesifunda (ukuthi amakhomithi ahlukaniswe izinkulungwane kanye nephuzu lokuhlukaniswa kwezinhlawulo).
Ngithola iphutha,
Ngifaka izixhumanisi zaseNortes nama-estes ngombono kodwa akwenzi lokho okushiwo ngaphambili
ishiya iphutha
Isikhathi sokuqalisa; '1004,:
ayitholakali ukuthola ishadi lezinkampani ze-chartIsigaba se-worsheet
Kuhle, kufanele isebenze ngaphandle kwezinkinga
I-2002 ihamba phambili
Ingabe ngizolahlekelwa okuthile?
hi shaka, yiliphi inguqulo enhle kakhulu onayo?
i-macro ayisebenzi kimi, ungangisiza?
yiyo yonke i-boloqueda futhi i-habilete kakade ukuze ukuphepha kwe-macro kubuncane njenge-g! ukuphawula, akusebenzi kimi !!!!! ngisize meeee
Sawubona uMarcos, uhlelo luveza umlayezo wokuthi awukwazi ukuguqula izinguquko, kodwa uma uwamukela. Ngamanye amazwi, ungashintsha igama lefayela kanye nobukhulu bombhalo, futhi uma ugijima lenza umphumela.
Uma kwenzeka unezinkinga eziningi, ungashintshi usayizi wetheksthi noma igama lefayela, akudingekile. Ubukhulu bombhalo buhlelwe ku-autocad.
Sawubona, ngizama ukusebenzisa lolu hlelo ukudlulisa inhlolovo encane kuya ku-CAD, kodwa ngokuhamba phambili akuvumeli ukuthi ngiyekeze noma yimaphi amathuba ekhasi lesithathu, ingabe lokhu kufanele kube khona? Siyabonga kusengaphambili.
Miguel: i-macro ayisebenzi no-Excel 2007
I-Joaquín: ama-macros kumele anikwe amandla, lokhu kwenziwa ngamathuluzi / macro / ukuphepha futhi unike amandla ukuphepha ezingeni eliphansi.
ishidi lakho elihle kakhulu lihle kakhulu kodwa ama-macros ukuthi ispredishithi ayisebenzi kuwo izokhubaza lokho engingakwenza ukuze ngisebenze kahle
Kuyinto enhle kakhulu engiye ngayisebenzisa isikhathi eside kodwa nginenkinga enkulu:
Akusebenzi nehhovisi 2007.
Ngizokwazisa noma yisiphi isisombululo kule nkinga.
Ngiyithokozisa kakhulu, ikakhulukazi ngemisebenzi emikhulu kakhulu, ngizozama ukubona ukuthi isebenza kanjani.
Sawubona Jordi, ngokuthembeka angizange ngizame ku-2007 kakhulu, ukubona ukuthi ngabe ubani oye wazama lapho futhi uqinisekisa uma kunika izinkinga
ukubingelela
galvrezhn, kuqala, feliciarte iqoqo wenzile lokhu entry, futhi ngakolunye uhlangothi (ngakho ubona kukhona wotshwala xaxa XYZ-DXF, hehe) wafuna amazwana uma othile, noma wena ngokwakho, banambitha Macro Excel 2007, 5 ngoba ngangiba ukuyisebenzisa-6 iminyaka ezinguqulweni ngaphambili e-Excel, futhi awazi ukuthi kungani, kodwa akusho ugijime (enginakho amamakhro amandla, futhi bonke ukuthi).
Un saludo