AutoCAD-AutoDeskMicrostation-Bentleytopografia

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.
txt kuti autocad

* 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.

bwino komanso autocad

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.

chithunzi

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).

autocad txt wapamwamba

Imeneyi ndi ntchito yodabwitsa, chifukwa ndiyothandiza komanso yosavuta kuyigwira. Sijambula mizere, imangotumiza mfundo.

Golgi Alvarez

Wolemba, wofufuza, katswiri wa Land Management Models. Iye watenga nawo gawo pakukonza ndi kukhazikitsa zitsanzo monga: National System of Property Administration SINAP ku Honduras, Model of Management of Joint Municipalities ku Honduras, Integrated Model of Cadastre Management - Registry ku Nicaragua, System of Administration ya Territory SAT ku Colombia. . Mkonzi wa blog ya chidziwitso cha Geofumadas kuyambira 2007 ndi mlengi wa AulaGEO Academy yomwe imaphatikizapo maphunziro oposa 100 pa GIS - CAD - BIM - Digital Twins mitu.

Nkhani

64 Comments

  1. 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.

  2. Ndikuyamikira kuti mungandithandize ndikufufuza malemba mu autocad ya tebulo yabwino, kuwapeza ndikusintha mtundu, ndikuyembekeza kuti mungathe, moni.

  3. 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 ???????

  4. 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

  5. Muyenera kugwiritsa ntchito mapu a AutoCAD kapena Civil 3D pa izi.
    Ngati mulibe, gwiritsani ntchito pulogalamu yotsegula monga QGis kapena gvSIG

  6. 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

  7. palibe chabwino chimandiuza kuti ndikuyenera kugula

  8. Zikomo chifukwa nkhaniyo koma kamodzi akuthamanga kuchita Podro reusable kapena 2003 2007 amakhoza inenso ndili ndi ena akamagwiritsa amakhoza AutoCAD POPANDA Taphunzira

  9. 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!

  10. 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

  11. 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

  12. 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.

  13. Douglas ... mu AutoCAD muyenera kungotsegula mafayilo,
    mu mafayilo a fayilo kusankha dxf
    Mukusankha fayilo yomwe inapangidwa mu C ndi
    Okonzeka !!!!!

  14. Ngati ikugwira ntchito mu 2007, mutatsegula fayilo imasonyeza chenjezo la chitetezo, muyenera kusankha
    Zosankha ...
    Thandizani izi ndizo
    kuvomereza

  15. Ngati mukunena za fayilo ya Excel yomwe ikuwonetsedwa pachitsanzochi, mukangolowa ma coordinates, dinani batani lofiirira lomwe lili ndi mawu achikasu: "dinani kuti mupange dxf"

  16. Ndikufuna kudziwa momwe mungatengere deta kuchokera pa tebulo muyeso kwa autocad, ndi lamulo lanji lomwe mungagwiritse ntchito.

  17. 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 (

  18. Ine sindikudziwa fungulo, wolemba anaziteteza izo. Koma sizikulepheretsani kuti musamangidwe maselo

  19. 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

  20. 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)

  21. Ngati mukufuna kutumiza zinthuzo, sankhani malembawo mu Excel, kukopera, ndiyeno mu AutoCAD, pangani

  22. Chabwino momwe onse amawonekera pa funso langa ndi zotsatirazi momwe mungadutse fucking kwambiri, auto car koma mndandanda?

  23. Fayilo yabwino kwambiri Moni kwa mnyamata amene wasiya fayiloyi, kuti awone ngati zopereka zambiri zimasulidwa.

  24. simusowa kusintha, ingozani deta.

    Kugwiritsa ntchitoku kutetezedwa ndi mawu achinsinsi, wolembayo anachita

  25. Moni, sindingasinthe zosankha zomwe zimandipempha kuti ndipeze chinsinsi chomwe ndingathe kuchichita

  26. 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

  27. Izi zazikulu ndizoyamikira kwambiri kwa onse omwe amapanga zoterezi.

    zonse

  28. Moni ndikuyang'ana njira yopangira polygon ndikuisintha koma mu arcgis.

  29. Choyamba, thokozani wolemba mbiri Juancho chifukwa cha zazikulu komanso nkhalamba! pakuchipeza ndikufalitsa ... ndiwothandiza bwanji !!!!!

  30. 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

  31. Zikomo chifukwa cha yankho lanu mofulumira, galvarezhn. Tsoka ilo silinagwire ntchito.

  32. zolakwika zowonetseratu, zikuwoneka kwa ine kuti zitha kukhala chifukwa chakusintha kwa zigawo, kuti olekanitsa masauzande ndi zisankho (semicolons) asinthidwa, onani ...

  33. zikuwoneka zosangalatsa, chifukwa ziri pa intaneti; Ndikuwona ngati ndikupenda tsiku limodzi la izi

    zikomo chifukwa chazo

  34. 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,

  35. 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"

  36. Kumene ndimakhazikitsa chikhulupiliro cha 2007 chapamwamba kwambiri

  37. Ndikukuthokozani ndikukuuzani kuti zimagwira ntchito bwino mu 2007 yokhayokha kuti muyenera kukonzekera akale pamtendere ndi wokonzeka

  38. NDI OFICCE 2007 SABWINO NTCHITO, NGATI PALI PHENOMONI YONSE MMODZI WOKUTHANDIZIRA NTCHITO NDI UPDATES IT. AMAKONDA

  39. 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

  40. 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).

  41. 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

  42. 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

  43. 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.

  44. 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.

  45. Miguel: izi zazikulu sizigwira ntchito ndi Excel 2007
    Yoaquín: ma macros ayenera kutsimikiziridwa, izi zimachitidwa m'zitsulo / macro / chitetezo ndikupatsanso chitetezo pamtunda wochepa.

  46. pepala lanu labwino kwambiri ndi labwino koma macros omwe spreadsheet sagwira ntchito idzathetsa zomwe ndingathe kuti ndichite moyenera

  47. Ndizofunikira kwambiri ndakhala ndikuzigwiritsa ntchito kwa nthawi yaitali koma ndili ndi vuto lalikulu:

    Izo sizigwira ntchito ndi ofesi 2007.

    Ndikuyamikira yankho lililonse la vutoli.

  48. Ndimasangalala kwambiri makamaka osati ntchito zazikulu kwambiri ndikuyesera kuwona

  49. Moni Jordi, ine moona sindinayese icho mu 2007 chapamwamba, kuti ndiwone ngati wina wayesera izo apo ndipo akutsimikizira ngati izo zikubweretsa mavuto

    moni

  50. 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!

Kusiya ndemanga

Anu email sati lofalitsidwa. Amafuna minda amalembedwa ndi *

Bwererani pamwamba