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

Tiyenera kuthokoza a Juan Manuel Anguita, Wofufuza kuchokera ku Jaén, Spain yemwe adayesetsa kupanga izi. Fayilo ya Excel ili ndi mapepala atatu, imodzi mwa iyo yotchedwa Preview imakupatsani mwayi wowona tchati, ndi mawonedwe am'mbali (omangidwa pama chart oyera a Excel!). Komanso iliyonse ya ma quadrants 9 imatha kuwonedwa, ngati mungasinthe zomwe zili patebulo gwiritsani batani «kusintha malingaliro»

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.

64 Imayankha "Kuchokera ku Excel kupita ku AutoCAD, chidule cha zabwino kwambiri"

  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. Zowona mtima kwambiri macro awa ndi osakwanira popeza saloledwa kugwiritsa ntchito maulendo angapo, kamodzi kokha ndipo izi zimapangitsa kuti ikhale ya Mediocre kapena mwina sigwiritsidwe ntchito koma kuyesera kupanga mafayilo angapo koma akuti fayilo ikugwiritsidwa ntchito ndi pulogalamu ina ???????

  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 ndikuwerengera momwe zinthu zimasinthira ma curve osiyanasiyana ndi mfundo zomwe ndimapeza ngati ma xls, kuzisintha kuti zikhale mawonekedwe a ascii kuti ziwakwaniritse pa cad ndi mawonekedwe a micostation.
    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 mungayang'ane fayilo ya Excel yomwe mwawonetsedwa pachitsanzocho, mutalowa maulalo, kanikizani batani lofiirira 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 * cholakwa * (st) (chofulumira (strcat «cholakwa:» st «07 \ n»))

    (setq va (akupanga «dzina la fayilo la ASCII kuti apange:«) vb (Open va «r»))
    (ngati (/ = vb nil) (kulengeza (kutseka vb) (setq vc (ascii (strcase (getstring
    «Fayilo yokhala ndi dzinali ilipo kale. \ NGU mukufuna kuisintha? «)))))
    (setq vc 89))
    (ngati (= vc 89) (kulengeza
    (setq vb (yotsegula "w") vd (ssget) ve (sslength vd) vf 0)
    (pamene (

  18. Sindikudziwa fungulo, wolemba adaliteteza. Koma sikukulepheretsani kutsitsa 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 munthu amene wasiya fayiloyi, kuti awone ngati zopereka zambiri zimatulutsidwa.

  24. simusowa kusintha, ingozani deta.

    Kugwiritsa ntchitoku kutetezedwa ndi mawu achinsinsi, wolembayo anachita

  25. moni, sindingathe kusintha momwe andifunsira mawu achinsinsi, ndingatani pamenepa?

  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 choyankha kwanu msanga, galvarezhn. Tsoka ilo sizinagwire 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

    mumapita ku batani labwino kwambiri, lomwe lili kumanzere kumanzere, ndikusankha batani la "bora",

    ndiye mumasankha "malo ogulitsa"

    ndipo mumasankha «kukhazikitsa malo odalirika”

    ndiye mumasankha "macro macro"

    ndipo pamenepo mumasankha "athe ma macro 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 zikwizikwi olekanitsa ndi chizindikiro "comma" ndi zigawo zomwe zili ndi "nthawi" zimakhazikitsidwa

    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. Moni Marcos, makompyutawa amapereka uthenga womwe sungathe kusintha zosintha, koma mumawalandira. Izi zikutanthauza kuti mutha kusintha dzina la fayiloyo ndi kukula kwa malembawo, ndipo mukayigwiritsa ntchito imabweretsa zotsatira zake.

    Ngati muli ndi vuto lochulukirapo, musasinthe kukula kwa malembawo kapena dzina la fayilo, sikofunikira. Kukula kwa malembawa 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!

Siyani yankho

Anu email sati lofalitsidwa.

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.