AutoCAD-AutoDeskMicrostation-Bentleytopografia

Daga Excel zuwa AutoCAD, taƙaitaccen abu mafi kyau

To, dole ne in yarda cewa yana da ban sha'awa don magana game da wannan batu, don haka a cikin wannan sakon na so in nuna mafi kyau da muka samu.

Amma mafi kyau duka shi to koya daga wani wanda a comments muka yi magana, game da wannan kayan aiki da damar daga wani Excel fayil don samar da wani DXF fayil, ta amfani da lura na x, y, z, wani ganewa code da matakin inda muna son shi ya zama kullun.

An kira wannan aikace-aikace XYZ-DXF kuma zaka iya sauke shi a nan;
Bari mu ga yadda yake aiki:

1 Bayanan asali:

Wannan aikace-aikacen ya dace da bayanan da aka zazzage daga GPS ko tashar gabaɗaya, idan dai haɗin haɗin UTM ne, yana nufin cewa sassanta a cikin jirgin Cartesian suna cikin mita. Shafin lambar shine mai gano ma'anar, to, haɗin x, y, z kuma a ƙarshe lakabin da muke so a zana su, waɗannan na iya zama, alal misali, gefen titi, bishiyoyi, kan iyakoki, polygonal ko duk wata sifa da daga baya zata bamu dama tace bayanai a cikin AutoCAD ko Microstation.
txt zuwa autocad

* Duk lambobi dole ne suna da lambar.
* Dukkan maki dole ne a shiga daya bayan daya, ba tare da bar layuka ba.

Faɗakarwar Bayanai na Bayanai

Godiya ga Juan Manuel Anguita, masanin Topographer daga Jaén, Spain wanda ya yi ƙoƙarin gina wannan macro. Fayil ɗin Excel yana da zanen gado guda uku, ɗaya daga cikinsu ana kiransa Preview yana ba ku damar ganin jadawali a cikin kallon tsari, da ra'ayoyi na gefe (gina zuwa zanen Excel mai tsabta!). Hakanan ana iya duba kowane ɗayan waɗannan 9 quadrants, idan ana canza bayanai a cikin tebur ana amfani da maɓallin "update views".

Excel da autocad

Sanya bayanai don fitarwa

The uku takardar kira zažužžukan, saita ko fayil za ka fitarwa zai tafi a kan biyu ko uku dimenciones, da font size, idan muna so elevations (Heights) da sunan DXF fayil suna nuna.

image

Da zarar an danna maballin shunayya, an ƙirƙiri fayil .dxf, wanda za'a iya buɗe shi tare da Microstation, Arcview, AutoCAD ko kusan kowane shirin CAD. A cikin wannan, ana ƙirƙirar shafi don kowane rubutu daban da aka samo a cikin rukunin 'Layer' (misali: lev), inda maki zai kasance; Hakanan za a sami wani Layer wanda sunansa zai zama rubutun ginshiƙi 'Layer' + txt (misali: levtxt), inda lambobin za su kasance, kuma za a ƙirƙira wani, inda girman zai kasance, tare da sunan 'rubutun na ginshiƙi 'Layer' + girma (misali: levcotas). Hakanan an ƙirƙiri babban fayil mai suna iri ɗaya kuma a wuri ɗaya.

Fayil makullin (dxf)

Wannan shine misalin fayil ɗin da aka gani daga AutoCAD. Sannan zaku iya canza launuka na yadudduka (tsari / yadudduka) ko tsarin ma'ana (tsarin / tsarin maki).

autocad txt excel

A sauƙaƙe aikace-aikace ne mai ban sha'awa, don yadda yake da amfani da sauƙi don sarrafawa. Baya zana layuka, kawai yana aika maki.

Golgi Alvarez

Marubuci, mai bincike, kwararre a cikin Samfuran Gudanar da Ƙasa. Ya halarci Conceptualization da aiwatar da model kamar: National System of Property Administration SINAP a Honduras, Model na Management of hadin gwiwa Municipalities a Honduras, Integrated Model na Cadastre Management - Registry a Nicaragua, System of Administration na Territory SAT a Colombia. . Editan shafin ilimin Geofumadas tun daga 2007 kuma mahaliccin Kwalejin AulaGEO wanda ya haɗa da darussa sama da 100 akan GIS - CAD - BIM - batutuwan Twins na Dijital.

shafi Articles

64 Comments

  1. Tare da kawai AutoCAD, wannan ba zai yiwu ba.
    Kuna iya, idan ka shigo da teburin a matsayin ma'auni a cikin sassan AutoCAD kamar Civi3D.
    Ko kuma idan kun yi macro tare da AutoLisp wanda ya ba da teburin.

  2. Na gode da ku zai iya taimaka mini ta binciken matakan a cikin autocad na wani ɗaki mai mahimmanci, gano su kuma canza launin, ina fatan za ku iya, gaisuwa.

  3. da gaske ba daidai ba tare da wannan Macro ne bai cika domin shi ba ya bari kanta a yi amfani da sau da yawa, TN sau ɗaya kawai, kuma wannan ya sa a mediocre ko ba a yi amfani amma kuma kokarin haifar da mahara fayiloli amma ya ce cewa fayil da ake amfani da wani shirin ????????

  4. Sannu Juan Manuel

    Ina neman bayanai don aiwatar da wani aikin da na tuna kuma na sami wannan fayil ɗin.

    To hakika ni ba gwani ba ne a cikin progaramción, amma ina da ra'ayin na damu da aikin sarrafawa na tsarin zane na hanyoyi ta wurin mai gani na asali mai kyau.

    Manufar ita ce lissafin nau'ikan abubuwan da ke cikin sassa daban-daban da kuma dabi'un da zan samu a matsayin xls, maido da su zuwa tsarin Hoto don aiwatar da su a cikin dandalin cad da microstation.
    Kuma wannan shine inda ba zan iya ci gaba ba, Ban san yadda za a yi ba. Daga abin da na ga kana da ra'ayi da yawa kuma watakila zaka iya taimaka mini
    Har ila yau ina so in ƙirƙirar wata lambar da zan iya nunawa ta hanyar abin da zan iya ganin fuskar a cikin hoto mai mahimmanci kafin aikawa da bayanai zuwa dandamali daban-daban.

    Don kulawa, na gode sosai

  5. Dole ne ku yi amfani da tashar AutoCAD ko Ƙungiyar 3D don wannan.
    Idan ba ku da shi ba, yi amfani da shirin cin zarafi kamar QGis ko gvSIG

  6. hola

    Na sani ba dole ba ne in yi daidai da wannan batu, amma idan wani ya iya jagorantar da ni akan yadda zan iya fitarwa fayilolin autocad zuwa KML kuma sa zane a kan gmaps.

    Godiya da kyawawan gaisuwa

  7. babu wani abu mai kyau da ya gaya mani cewa dole in haɓaka

  8. Na gode da kayan amma da zarar KAWAI gudanar son yi Podro reusable ko 2003 2007 Excel I ma da wasu tsare-tsare Excel AutoCAD BA TARE A jingina

  9. Kyakkyawan taimako sosai !! Ina kawai bukatar ku karanta fiye da maki 1000, na ga cewa an kiyaye shi ... Na yi nasarar sanya maki har zuwa 950, duk da haka ina da daidaitattun abubuwa sama da maki 5000 ... da rashin alheri yana gaya min kariya da kalmar sirri .. Amma kyakkyawar gudummawa! Ina fatan marubucin ya ga wannan kuma zai iya ƙara yawan maki don samun damar shiga ..

    Gaisuwa ga kowa!

  10. Na gode sosai don ba mu irin wannan aikace-aikace mai kyau. Ina farin cikin aikin, tambaya: Shin zai yiwu a haɗa wani toshe tare da kowane ma'ana, misali da'irar? Idan haka ne, za ku iya gaya mani abin da ake nufi.

    Na gode sosai

    Patricio

  11. kyau kwarai da kyau, wannan aiki na Excel takardar, tambaya bisa ga gwaje-gwaje Na yi wannan iyakance da yawan maki da za a graphed, a yanayin da na bukatar yin jadawalai game 4000 maki kamar yadda zan iya yi don canja wannan Excel PivotTable kamar yadda Zai dauki ni lokaci mai yawa don yin la'akari da sashe.
    sosai godiya

  12. Na aika inã mai tsarkake taya murna ga mawallafin, shi ne babban taimako ga surveyors, fatan ci gaba da samun irin wannan fasaha AIDS wajen samar da kaina a cikin wani mafi sana'a hanya a nan gaba.

  13. Douglas ... a cikin AutoCAD kawai zaku bada file a buɗe,
    a cikin fayilolin fayil saccinas dxf
    Ka zaɓi fayil ɗin da aka kirkiri a C kuma
    Ready !!!!!

  14. Idan yana aiki a 2007, lokacin da ka buɗe fayil yana nuna gargadin tsaro, dole ka zabi a
    Zaɓuɓɓuka ...
    Yarda wannan abun ciki kuma
    yarda da

  15. Idan kana nufin fayil ɗin Excel da aka nuna a cikin misali, da zarar ka shigar da haɗin gwiwar, danna maɓallin shunayya tare da rubutun rawaya: "latsa don ƙirƙirar dxf"

  16. Ina so in san yadda za a kawo bayanan daga tebur a cikin tayi zuwa autocad, menene umurni don amfani.

  17. Ina son ku taimaka min ... Ina kokarin neman aikace-aikace ko wani abu na yau da kullun a cikin lsp. Da abin da zaku iya fitar da matani daga .dwg zuwa .xls kawai rubutun da kuka zaɓa tare da linzamin kwamfuta kuma a lokaci guda za ku iya shigar da bayanai tare da maballin idan ba za ku iya samun rubutu a zane ba. kuma cewa ba a zaɓi matanin da aka fitar ba idan bai bar ni in zaɓi shi sau da yawa kamar yadda ya cancanta ba.
    Ina da wannan al'ada
    (kalubalanci C: TXTOUT (/ v v v v v v v vg vg); V1.0
    ; Ta hanyar Scott Hull, 11-20-86
    ; SAH Hakanan Kayan (415) 343-4015
    ; Sake fitar da rubutu na ASCII zuwa fayil din.

    (kare *kuskure* (st) (st) (da sauri (strcat “kuskure:” st “07\n”))))

    (setq yana tafiya (getstring "Sunan fayil ɗin ASCII don ƙirƙirar: ") vb (buɗe yana "r")))
    (idan (/ = vb nil) (progn (kusa vb) (setq vc (ascii (strcase (getstring
    "An riga an sami fayil mai wannan sunan.\n Kuna son musanya shi? ")))))))
    (zane 89 XIX))
    (idan (= vc 89) (alamar
    (setq vb (bude va “w”) vd (ssget) ve (sslength vd) vf 0)
    (yayin da (

  18. Ban san mabuɗin ba, marubucin ya kare shi. Amma ba ya hana ku daga kwashe sassan

  19. Don samun damar kwafa da manna wani shafi na bayanai daga ɗakunan bayanan wannan ya gaya mani cewa ana kiyaye kodayen, kuma ban sani ba wane mabuɗin don magance wannan matsala ba, idan kun san zan zama godiya sosai

  20. Barka dai abokai, don samun damar amfani da shi a ofis na 2007 kawai sai ku canza shi zuwa sigar, a gunkin da ke saman hannun hagu zaɓi ne, CLICK ALLI. Sannan zaka bashi ya karba. Lokacin da ta nemi zaɓi don rufewa da buɗe littafin, danna YES. Yana yi muku gargaɗi cewa canje-canjen da ba a sami ceto ba za a rasa, wannan ba shi da matsala, ana karɓa ne kawai kuma yanzu (Idan wannan zaɓin bai BUYA ba, ya fi kyau). Kafin amfani da macro dole ne ka kiyaye a ƙasa da sandunan menu GARGADI NA TSARO: An katse wasu abubuwan da ke aiki, ZUWA ZABE DA LATSA A kunna Enable wannan abun ciki da voila…. Zaku iya riga amfani da shi A OFIS 2007.

    LUCK TO ALL !!!!! (KADA KA KASA CEWA YADDA YAKE KYAU YI YI KASA DA RUWA)

  21. Idan kana nufin wucewa da abun ciki, zaɓi rubutun a Excel, kwafi, sannan kuma a cikin AutoCAD, manna

  22. Kamar yadda duka suke kallon tambaya ita ce irin yadda za a yi amfani da fucking mai kyau, zuwa madaidaicin motsa jiki amma a cikin rubutu?

  23. Fayil mai kyau Gaisuwa ga mutumin da ya bar wannan fayil ɗin, don ganin idan aka saki karin gudunmawar.

  24. ba dole ba ne don gyara shi, kawai shigar da bayanai.

    Wannan aikace-aikacen ana kare tare da kalmar sirri, marubucin ya yi

  25. Sannu, Ba zan iya canza zaɓin da ya tambaye ni ba don kalmar sirrin shiga da zan iya yi a wannan yanayin

  26. g! ko wani ina aiki a kan wani zane na wani titi, kusan ko da yaushe ka yi tare da duka tashar amma yanzu sun kawo ni zirga-zirga data da kuma matakin (giciye-sassan) Shin, wani mutum san yadda za a maida wannan bayanai zuwa UTM? Ina da tsare axis da kuma karanta sassan an bar nisa har zuwa + ko -, centerline, dama nisa har zuwa + ko - idan wani taimake ni ...... jcpescotosb@hotmail.com

  27. Wannan macro mai kyau ne mai godiya ga duk waɗanda suke yin wadannan abubuwan da suka faru.

    gaisuwa

  28. sannu Ina neman hanyar haifar da polygon kuma daidaita shi amma a arcgis.

  29. Da farko, na gode wa masanin tarihin Juancho na macro da kuma tsoho! don gano shi da kuma buga shi ... abin da babbar gudummawa !!!!!

  30. Ayyukan IN OFFICE 2007 BA ni kullum ni daga ERROR kuma ya ce fitarwa zuwa babban fayil a KW kome zo daga ina samun wani taga cewa PERUTRAR AND faɗa mini ba ME ZA KA YI SDE

  31. Na gode don gaggawar amsawa, galvarezhn. Abin takaici shi ba ya aiki.

  32. kuskuren hangen nesa, da alama a wurina zai iya zama saboda yanayin yanki, cewa an canza mai raba dubbai da adadi (semicolons), duba ...

  33. yana da ban sha'awa, domin yana da layi; Zan ga idan na yi bita a wata rana na wannan

    godiya ga komai

  34. da zarar kafa da amincewa da matakin da Macro, da falle duk da haka har yanzu nuna wani kuskure sako zuwa na biyu tab (preview).

    Kodayake kuna ci gaba da aikawa da maki zuwa dxf, Ina so in cika dukkan ayyukan da wannan shafin ya kasance.

    Abin farin ciki,

  35. don saita matakin amincewa

    sai ka je wajen maballin excel, wanda yake a hannun hagu na farko, sai ka zabi maballin “Excel Options”,

    sai a zabi "trust center"

    sannan ka zabi "configure trust center"

    sai ka zabi "Macro settings"

    kuma a can za ku zaɓi "enable all macros"

  36. Inda na kafa matakin amincewa a cikin 2007 ya wuce

  37. Na taya muku murna kuma in gaya muku cewa yana aiki sosai a cikin Xxel XXXX kawai cewa dole ne ku tsara kullun a matakin amincewa da shirye

  38. OFICCE 2007 BA TARE DA HIDIMAR, da ta bayyana da wani sabon abu da ya halitta aikace-aikace da kuma sabunta. KYA KA

  39. don mai kyau, to, je don canza yanayin sanyi na yankin zuwa na'urarka

    farawa / iko panel / daidaitawar yankin

    to, ku zaɓi ƙasarku a cikin zaɓuɓɓukan yanki

    a can a tabbata cewa an kafa dubunnan masu rarrabawa tare da alamar "waƙafi" da ƙima mai "dige"

    to, sai ku tafi ya wuce kuma ya kamata ya yi aiki

  40. Yana aiki ba tare da adadi ba …… amma can masu daidaitawa ba zasu zama daidai a cikin jirgin ba… .. chaff, me za ku ba ni shawara ???

  41. shiga tsarawa taso keya gwajin, watau ba tare da dicimal ganin idan matsalar ba Mahalli (wakafi ne domin raba dubbai da kuma gidan goma nufi ga rabuwa).

  42. Ina samun kuskure,

    Na shigar da ƙayyadaddun wuri da kuma estes tare da girma amma ba ya yi previsualizacion

    ya bar kuskure
    Lokacin gudu; '1004,:
    baza su iya samun sigogin Abubuwan da ke cikin ɗakunan ajiya ba

  43. Macro ba ya aiki a gare ni, zaka iya taimake ni ??

    duk boloqueda ne kuma ya riga ya riga ya isa domin tsaro na macro shine ƙananan kamar g! comment, ba ya aiki a gare ni !!!!! taimaka mani

  44. Hi Marcos, tsarin yana haifar da saƙo cewa ba za ka iya canza canje-canje ba, amma idan ka yarda da su. A wasu kalmomi, za ka iya canza sunan fayil ɗin da girman rubutu, kuma lokacin da kake gudanar da shi yana haifar da sakamakon.

    Idan kana da matsala mafi yawa, kada ka canza girman rubutu ko sunan fayil, ba lallai ba. Girman rubutu zai iya gyara a autocad.

  45. Sannu, Ina ƙoƙarin amfani da wannan shirin don aiwatar da wani karamin binciken zuwa CAD, amma a cikin abin da ya fi dacewa bana yarda da ni in sauya kowane irin abubuwan da ke cikin shafin uku ba, shin wannan zai yiwu? Godiya a gaba.

  46. Miguel: Macro ba ya aiki tare da Excel 2007
    Joaquín: Dole ne a kunna macros, ana aiwatar da wannan a cikin kayan aikin / Macro / tsaro kuma ya ba da tsaro a ƙananan matakin.

  47. Fayil ɗinku mafi kyau yana da kyau amma macros da ɗigon rubutu bai yi aiki ba zai kashe abin da zan iya yi don aiki daidai

  48. Yana da kyau mai amfani da na yi amfani dashi na dogon lokaci amma ina da babban matsala:

    Ba ya aiki tare da ofishin 2007.

    Ina godiya da duk wani bayani ga wannan matsala.

  49. Na ga yana da ban sha'awa sosai, musamman ga ayyukan ba manyan manya ba, zan yi kokarin ganin yadda yake aiki.

  50. Hello Jordi, Na gaskiya ba a gwada shi ba a 2007 mafi kyau, don ganin idan wani wanda yayi ƙoƙari a can kuma ya tabbatar da cewa yana da matsala

    gaisuwa

  51. Galvrezhn, na farko, yana jin dadin tarihin da kuka yi a cikin wannan sakon, kuma a daya bangaren (kamar yadda na ga akwai mai shan magani ga XYZ-DXF, hehe) Ina so in gaya muku idan wani, ko da kanka, ya yi kokarin macro a cikin 2007, saboda na yi amfani da shi 5-6 shekaru a cikin sassan da suka gabata, kuma ban san dalilin da ya sa ba, amma a cikin wannan bai sa ta gudu ba (Ina da macros kunna, duk da haka).

    gaisuwa

Deja un comentario

Your email address ba za a buga. Bukata filayen suna alama da *

Komawa zuwa maɓallin kewayawa