Kuchokera ku Excel kupita ku AutoCAD, chidule cha zabwino
Ndiyenera kuvomereza kuti zimakhala zokondweretsa kulankhula za mutu uwu, kotero mu positiyi ndikufuna kusonyeza zabwino zomwe tapeza.
- Tinawona kuti Microstation yathandiza ntchito zomwe zingalowe mwachindunji kuchokera pa fayilo ya txt
- Tinaonanso momwe chitani ndi AutoCAD
- Ife tawona momwe kutumiza kuchokera ku AutoCAD o Kusungunula kwapadera kwa csv kapena txt
- Kenako tinawona momwe tingagwiritsire ntchito lamuloli concatenate ngati muli ndi maulendo ndi maulendo oposa
- Ndipo ife tawona a VBA ntchito chifukwa cha Microstation yomwe imagwira ntchito zonse ziwiri
Koma koposa zonse anali kuphunzira kwa munthu amene ndemanga zake tinakambirana za chida chimene chimathandiza wapamwamba ndi kupambana kwa kupanga ndi DXF file, pogwiritsa ntchito ndondomeko ya ×, Y, z, ndi malamulo chizindikiritso ndi msinkhu kumene ife tikufuna izo zikopeke.
Kugwiritsa ntchito kumatchedwa XYZ-DXF ndipo mungathe koperani apa;
Tiyeni tiwone momwe zimagwirira ntchito:
1 Chiyambi cha deta:
Izi ndizoyenera kuti utsitsidwe kuchokera ku gps kapena pa station yonse, bola maulalo ndi UTM, zikutanthauza kuti mayunitsi ake mu ndege ya Cartesian ali mumamita. Mzere wama code ndi chizindikiritso cha mfundoyi, kenako x, y, z imagwirizana ndipo kenako wosanjikiza womwe tikufuna kuti akokedwe, awa akhoza kukhala, mwachitsanzo, olamulira amisewu, mitengo, malire, polygonal kapena mawonekedwe aliwonse omwe pambuyo pake amatilola zoseferani zidziwitso mu AutoCAD kapena Microstation.
* Mfundo zonse ziyenera kukhala ndi mfundo.
* Mfundo zonse ziyenera kulowa chimodzimodzi, popanda kusiya mizere yopanda kanthu.
Kuwonetseratu kwa Deta
Tithokoze Juan Manuel Anguita, Wolemba za Toppograph wa ku Jaén, Spain yemwe adayesetsa kupanga macro. Fayilo ya Excel ili ndi mapepala atatu, amodzi mwa iwo amatchedwa Preview amakulolani kuti muwone graph powonera mapulani, ndi mawonedwe am'mbali (omangidwa ku Excel graph!). Komanso iliyonse ya 9 quadrants iyi imatha kuwonedwa, ngati mutasintha deta patebulo batani la "update view" likugwiritsidwa ntchito.
Konzani deta kuti mutumize
Pepala lachitatu lomwe limatchedwa zosankha, limatithandiza kufotokozera ngati fayilo yomwe tidzatumizako idzapita mu miyeso iwiri kapena itatu, kukula kwa kalatayi, ngati tikufuna kusonyeza zowonjezera (mafano) ndi dzina la fayilo ya dxf.
Batani lofiirira litasindikizidwa, fayilo ya .dxf imapangidwa, yomwe imatha kutsegulidwa ndi Microstation, Arcview, AutoCAD kapena pafupifupi pulogalamu iliyonse ya CAD. Mwa ichi, chopangidwira chimapangidwa pamalemba aliwonse osiyana omwe amapezeka mgawo la 'Layer' (mwachitsanzo: lev), pomwe milozo idzakhala; Padzakhalanso wosanjikiza wina yemwe dzina lake lipanga gawo la 'Layer' + txt (ex: levtxt), pomwe ma code azikhala, ndikupanga wina, komwe kukula kwake kudzakhala, ndi dzina 'mawu a gawo 'Layer' + miyeso (ex: levcotas). Fayilo yopambana yokhala ndi dzina lomweli komanso komweko imapangidwanso.
Fayilo yopita (dxf)
Ichi ndi chitsanzo cha fayilo yowonedwa kuchokera ku AutoCAD. Kenako mutha kusintha mitundu yamitundu (mawonekedwe / zigawo) kapena mtundu wa point (mitundu / mawonekedwe amachitidwe).
Imeneyi ndi ntchito yodabwitsa, chifukwa ndiyothandiza komanso yosavuta kuyigwira. Sijambula mizere, imangotumiza mfundo.
Ndi AutoCAD yokha, zimenezo sizingatheke.
Mungathe, ngati mutumiza tebulo ngati deta mu AutoCAD mawonekedwe monga Civi3D.
Kapena ngati mupanga macro ndi AutoLisp omwe amapereka tebulo.
Ndikuyamikira kuti mungandithandize ndikufufuza malemba mu autocad ya tebulo yabwino, kuwapeza ndikusintha mtundu, ndikuyembekeza kuti mungathe, moni.
Pulogalamu yabwino
Gracias
EXCELLENT !!!! THANK YOU ..
Ndikulakwitsa 1004 nthawi yothamanga….
modzipereka cholakwika ndi zazikulu izi ndi chosakwanira chifukwa salola yokha ntchito kangapo, TN kamodzi kokha ndipo izi zimapangitsa kuti mediocre kapena ayi ntchito koma ndi anayesa kulenga owona angapo koma limanena kuti wapamwamba akugwiritsa ntchito pulogalamu wina ???????
Moni Yoyambira
Ndinkafunafuna chidziwitso kuti ndichite ntchito yomwe ndimaganizira ndikupeza fayiloyi.
Chabwino, ine sindiri katswiri weniweni wa progamming, koma ndiri ndi lingaliro lakumangirira zokhazokha zamakono pamsewu kupyolera mumasewero ofunika owonetsera.
Cholinga chake ndi kuwerengera zinthu zamakono zosiyana siyana ndi zitsulo zomwe ndimapeza monga xls, kuzimasulira kuti zikhale ngati maofesi omwe angawathandize kuti aziwagwiritsa ntchito mu dig ndi microstation platform.
Ndipo ndi pamene ine sindingakhoze kupitirira, ine sindikudziwa momwe ndingachitire izo. Kuchokera pa zomwe ndikuwona muli ndi lingaliro lalikulu la izo ndipo mwinamwake mungandithandize
Ndikufunanso kupanga pulogalamu kuti ndidye momwe ndingaganizireko mpata mu graph kwambiri kuposa kutumiza deta kumapulatifomu osiyanasiyana.
Ndikuyamika kwambiri
Muyenera kugwiritsa ntchito mapu a AutoCAD kapena Civil 3D pa izi.
Ngati mulibe, gwiritsani ntchito pulogalamu yotsegula monga QGis kapena gvSIG
Hola
Ndikudziwa kuti siziyenera kuchita chimodzimodzi ndi mutuwu, koma ngati wina anganditsogolere momwe ndingatumizire mafotolo autocad ku KML ndikuyika zithunzi pazomwe zili.
Zikomo ndi zabwino
palibe chabwino chimandiuza kuti ndikuyenera kugula
Zikomo chifukwa nkhaniyo koma kamodzi akuthamanga kuchita Podro reusable kapena 2003 2007 amakhoza inenso ndili ndi ena akamagwiritsa amakhoza AutoCAD POPANDA Taphunzira
Thandizo
kodi wina angandithandize
Chopereka chabwino kwambiri !! Ndikungofunika kuti muwerenge ma point opitilira 1000, ndikuwona kuti ndiotetezedwa ... ndakwanitsa kupeza malongosoledwewo mpaka 950, komabe ndili ndimakonzedwe amalo opitilira 5000 ... mwatsoka amandiuza kuti ndili ndi chinsinsi .. Koma zopereka zabwino kwambiri! Ndikukhulupirira kuti wolemba awona izi ndipo atha kukulitsa kuchuluka kwa mfundo kuti athe kulowa ..
Moni kwa onse!
Zikomo kwambiri chifukwa chotipatsa ife ntchito yabwino kwambiri. Ndine wokondwa kwambiri ndi ntchito, funso: Kodi n'zotheka kuyanjana ndi chigawo chilichonse, mwachitsanzo bwalo? Ngati ndi choncho, kodi mungandidziwitse kuti ndi njira yanji.
Zikomo kwambiri
Patrick
kwambiri wabwino, magwiridwe ili la pepala kupambana, funso malinga ndi mayesero Ine ndachita izi okha chiwerengero cha mfundo kuti graphed, lakuti Ndikufuna kuti chintchito za 4000 mfundo ngati ndingachite chosintha zimenezi kupambana PivotTable monga Zinganditengere nthawi yochuluka yokhala chiwembu.
oyamikira kwambiri
Ine nditumiza Zabwino langa lodzipereka kwa Mlembi, ndi thandizo lalikulu kwa oyeza, ndikuyembekeza kuti azilandira ngati luso AIDS kukhala ndekha mu njira akatswiri m'tsogolo.
Douglas ... mu AutoCAD muyenera kungotsegula mafayilo,
mu mafayilo a fayilo kusankha dxf
Mukusankha fayilo yomwe inapangidwa mu C ndi
Okonzeka !!!!!
Ngati ikugwira ntchito mu 2007, mutatsegula fayilo imasonyeza chenjezo la chitetezo, muyenera kusankha
Zosankha ...
Thandizani izi ndizo
kuvomereza
Ngati mukunena za fayilo ya Excel yomwe ikuwonetsedwa pachitsanzochi, mukangolowa ma coordinates, dinani batani lofiirira lomwe lili ndi mawu achikasu: "dinani kuti mupange dxf"
Ndikufuna kudziwa momwe mungatengere deta kuchokera pa tebulo muyeso kwa autocad, ndi lamulo lanji lomwe mungagwiritse ntchito.
Ndikufuna kuti mundithandizire ... ndikuyesera kupeza pulogalamu kapena chizolowezi ku lsp. Momwe mungatumizire zolemba kuchokera ku .dwg kupita ku .xls zokhazo zomwe mungasankhe ndi mbewa ndipo nthawi yomweyo mutha kuyika deta ndi kiyibodi kuti mwina simungapeze zolemba pazojambulazo. ndikuti zolemba zomwe zatumizidwa sizimasankhidwa ngati sizikundilola kuti ndizisankhe kangapo kofunikira.
Ndili ndi chizoloŵezi ichi
(defun C: TXTOUT (/ va vb vc vf vg vg); V1.0
; Ndi Scott Hull, 11-20-86
; SAH Mechanical Design (415) 343-4015
; Kutumiza mauthenga aku ASCII kuti apange.
(defun *error* (st) (mofulumira (strcat “error: ” st “07\n”)))
(setq amapita (getstring "Dzina la fayilo ya ASCII kuti mupange:") vb (kutsegula kumapita"r")
(ngati (/ = vb nil) (kulengeza (kutseka vb) (setq vc (ascii (strcase (getstring
“Fayilo yokhala ndi dzinali ilipo kale.\nKodi mukufuna kuyisintha? ")))))
(setq vc 89))
(ngati (= vc 89) (kulengeza
(setq vb (otsegula va “w”) vd (ssget) ve (sslength vd) vf 0)
(pamene (
Ine sindikudziwa fungulo, wolemba anaziteteza izo. Koma sizikulepheretsani kuti musamangidwe maselo
Kuti mukhoze kusindikiza ndi kusunga ndondomeko ya deta kuchokera ku spreadsheet izi zikundiuza kuti maselo amatetezedwa, ndipo sindikudziwa kuti ndi chinsinsi chotani kuthetsera vutoli, ngati mukudziwa kuti ndiziyamikira kwambiri
Moni abwenzi, kuti muzitha kuzigwiritsa ntchito muofesi 2007 muyenera kungozisintha kukhala mtundu, pazithunzi kumanzere kumanzere ndi mwayi, DINANI ALLI. Ndiye mumapereka kuti mulandire. Ikapempha mwayi wotseka ndikutsegula bukulo, dinani INDE. Ikukuchenjezani kuti zosintha zomwe simunasunge zidzatayika, zilibe kanthu, zimangovomerezedwa ndipo tsopano (Ngati njirayi SIWONEKA, ndibwino). Musanagwiritse ntchito macro muyenera kuwona m'munsimu mipiringidzo CHENJEZO CHENJEZO: Zina mwazomwezo zakhala zikulephereka, PITANI KU ZINTHU ZINA NDI KULIMBITSA Yambitsani izi ndi voila…. MUTHA KUGWIRITSIRA NTCHITO NTCHITO YOFUNIKA KU OFFICE 2007.
LIKE KWA ONSE !!!!! (MUSAMAGWIRITSE NTCHITO YA MACRO KUYENERA KUCHITA NDI KUWERENGA)
Ngati mukufuna kutumiza zinthuzo, sankhani malembawo mu Excel, kukopera, ndiyeno mu AutoCAD, pangani
Chabwino momwe onse amawonekera pa funso langa ndi zotsatirazi momwe mungadutse fucking kwambiri, auto car koma mndandanda?
Fayilo yabwino kwambiri Moni kwa mnyamata amene wasiya fayiloyi, kuti awone ngati zopereka zambiri zimasulidwa.
simusowa kusintha, ingozani deta.
Kugwiritsa ntchitoku kutetezedwa ndi mawu achinsinsi, wolembayo anachita
Moni, sindingasinthe zosankha zomwe zimandipempha kuti ndipeze chinsinsi chomwe ndingathe kuchichita
g! kapena munthu Ndikugwira ntchito pa kujambula kwa msewu, pafupifupi nthawi zonse kuchita ndi siteshoni okwana koma tsopano iwo ananditengera deta magalimoto ndi mlingo (mtanda zigawo) Kodi aliyense mumadziwa kuti atembenuke deta izi UTM? Ndili ndi zigawo zofotokozera komanso kuwerenga kwa magawowa ndi kutalika komwe kumakhala kutali + kapena,, pakati, kutalika kutalika + kapena ... ngati wina andithandiza jcpescotosb@hotmail.com
Izi zazikulu ndizoyamikira kwambiri kwa onse omwe amapanga zoterezi.
zonse
Moni ndikuyang'ana njira yopangira polygon ndikuisintha koma mu arcgis.
Choyamba, thokozani wolemba mbiri Juancho chifukwa cha zazikulu komanso nkhalamba! pakuchipeza ndikufalitsa ... ndiwothandiza bwanji !!!!!
fayilo imayambitsa izo mu c:
kumene mumapanga fayilo ya dxf
Si funciona
NTCHITO KU OFFICE 2007 OSATI nthawi zonse ine ndikundikokera kunja zolakwa ndi LIMANENA katundu kwa chikwatu pa CY kanthu akutuluka ndimakhala ndi zenera kuti PERUTRAR NDI musandiuze ZIMENE MUNGACHITE SDE
Pepani, sindikudziwa chomwe chidzakhala
Zikomo chifukwa cha yankho lanu mofulumira, galvarezhn. Tsoka ilo silinagwire ntchito.
zolakwika zowonetseratu, zikuwoneka kwa ine kuti zitha kukhala chifukwa chakusintha kwa zigawo, kuti olekanitsa masauzande ndi zisankho (semicolons) asinthidwa, onani ...
zikuwoneka zosangalatsa, chifukwa ziri pa intaneti; Ndikuwona ngati ndikupenda tsiku limodzi la izi
zikomo chifukwa chazo
Ndapeza webusaiti yaulere ya mauthenga kwa dxf kutembenuzidwa
PASS TEXT X, Y, ZA DXF (TOPOGRAPHY)
http://www.konstruir.com/topografia/
Pomwe chikhulupiliro cha macro chikukonzekera, spreadsheet komabe ikuwonetsabe uthenga wolakwika pa tabu yachiwiri (PREVIEW).
Ngakhale kuti mukupitiriza kutumiza mfundozo ku dxf, ndikufuna ndikuthandizani mokwanira ntchito zapa tsambali.
Zikomo,
kukonza msinkhu wa chidaliro
Pitani ku batani la Excel, lomwe liri koyamba kumanzere kumanzere, ndikusankha batani la "Excel options",
kenako sankhani "trust center"
ndipo pamenepo mumasankha "configure trust center"
Kenako sankhani "Zokonda zazikulu"
ndipo pamenepo mumasankha "yambitsani ma macros onse"
Kumene ndimakhazikitsa chikhulupiliro cha 2007 chapamwamba kwambiri
Ndikukuthokozani ndikukuuzani kuti zimagwira ntchito bwino mu 2007 yokhayokha kuti muyenera kukonzekera akale pamtendere ndi wokonzeka
NDI OFICCE 2007 SABWINO NTCHITO, NGATI PALI PHENOMONI YONSE MMODZI WOKUTHANDIZIRA NTCHITO NDI UPDATES IT. AMAKONDA
kuti ukhale wabwino, ndiye pita kusintha masinthidwe a m'deralo ku makina anu
Yambani / kuyang'anira gulu / kukonzekera m'deralo
ndiye mumasankha dziko lanu muzosankha za m'deralo
pamenepo onetsetsani kuti olekanitsa masauzande akhazikitsidwa ndi chizindikiro "comma" ndi ma decimals okhala ndi "dontho"
ndiye iwe upita kukapambana ndipo uyenera kugwira ntchito
Zimagwira popanda maofesi ...
yesetsani kulowetsa makonzedwe ozungulira, omwe alibe zopanda malire kuti awone ngati si vuto la kukonzekera m'deralo (kuti makasitomala ndi omwe akulekanitsa zikwi ndi mfundo zolekanitsa zowonongeka).
Ine ndikupeza cholakwika,
Ndilowetsani makonzedwe a kumpoto ndi mayiko ndi mbali koma sichichita previsualizacion
zimasiya zolakwika
Nthawi yothamanga; '1004,:
sakutha kupeza katundu wa chartObjects wa gulu la worsheet
Chabwino, iyenera kugwira ntchito popanda mavuto
oposa 2002
kodi ndikusowa chinachake?
Mukuona, ndiyeso yoposa iti yomwe muli nayo?
macro samagwira ntchito kwa ine, kodi mungandithandize?
ndizo zonse zapamwamba ndi zobvala kale kuti chitetezo cha macro chikhale chochepa monga g! ndemanga, izo sizigwira ntchito kwa ine !!!!! thandizani meeee
Hi Marcos, dongosolo limapanga uthenga kuti simungasinthe kusintha, koma ngati muwalandira. Mwa kuyankhula kwina, mukhoza kusintha dzina la fayilo ndi kukula kwa mawuwo, ndipo pamene muthamanga ilo limapanga zotsatira.
Ngati muli ndi mavuto ambiri, musasinthe kukula kwa mawu kapena fayilo, sikofunikira. Kukula kwa malemba kungasinthidwe mu autocad.
Moni, ndikuyesera kugwiritsa ntchito pulogalamuyi kuti ndipereke kafukufuku waung'ono ku CAD, koma paulendo wanga sungalole kuti ndisinthe njira iliyonse ya tsamba lachitatu, kodi izi zingatheke? Zikomo kwambiri.
Miguel: izi zazikulu sizigwira ntchito ndi Excel 2007
Yoaquín: ma macros ayenera kutsimikiziridwa, izi zimachitidwa m'zitsulo / macro / chitetezo ndikupatsanso chitetezo pamtunda wochepa.
pepala lanu labwino kwambiri ndi labwino koma macros omwe spreadsheet sagwira ntchito idzathetsa zomwe ndingathe kuti ndichite moyenera
Ndizofunikira kwambiri ndakhala ndikuzigwiritsa ntchito kwa nthawi yaitali koma ndili ndi vuto lalikulu:
Izo sizigwira ntchito ndi ofesi 2007.
Ndikuyamikira yankho lililonse la vutoli.
Ndimasangalala kwambiri makamaka osati ntchito zazikulu kwambiri ndikuyesera kuwona
Moni Jordi, ine moona sindinayese icho mu 2007 chapamwamba, kuti ndiwone ngati wina wayesera izo apo ndipo akutsimikizira ngati izo zikubweretsa mavuto
moni
galvrezhn, choyamba, feliciarte zosonkhanitsira mwachita kulowa izi, ndi pa dzanja ena (kotero inu mukuona pali osokoneza kwambiri XYZ-DXF, hehe) ankafuna kuti afotokoze ngati munthu, kapena nokha, analawa zazikulu Excel 2007, 5 chifukwa ndinkafuna ntchito-6 zaka Mabaibulo kale za kupambana, ndipo sindikudziwa chifukwa chake, koma osati kuthamangira (ndili macros chinathandiza, ndi zonse).
Zikomo!