Ukusuka kwi-Excel ukuya kwi-AutoCAD, isishwankathelo seyona nto

Ewe, ndimele ndivume ukuba kuye kumnandi ukuthetha ngalesi sihloko, ngoko kule post ndifuna ukubonisa okusemandleni esikufumene.

  • Sibone ukuba iMicrostation lidibene umsebenzi wokungenisa ngqo kwifayile ye-txt
  • Sibone kwakhona indlela yenze nge AutoCAD
  • Sibone indlela ukuthumela ngaphandle kwi-AutoCAD o I-Microstation kwi-csv okanye i-txt
  • Emva koko sabona indlela yokusebenzisa umyalelo ngqamana xa kunokuba kukho izikhokelo kunye nemida ekugqibeleni
  • Kwaye sabona Sicelo seVBA I-Microstation esebenza ngeendlela zombini

Kodwa okuhle konke ukufunda ngumntu othi izimvo zakhe sathetha ngalo esi sixhobo evumela ukusuka kwifayile Excel ukwenza ifayile DXF, kusetyenziswa uququzelelo ye x, y, z, i ikhowudi ukuchonga kwinqanaba apho sifuna ukuba idibene.

Isicelo sibizwa ngokuba yi-XYZ-DXF kwaye unako khuphela apha;
Makhe sibone indlela isebenza ngayo:

1 Imvelaphi yedatha:

Esi sicelo efanelekileyo ulwazi longele evela GPS okanye isikhululo iyonke njalo kwaye xa uququzelelo kukho UTM, ithetha iiyunithi zalo moya we cartesian sele leemitha. Ikholam ye khowudi njengomqwalaseli le ngongoma, ngoko ke 'x', kunye umaleko ekugqibeleni zy sinqwenela ukuba ngokwabo, zinokuba umzekelo taxiway, imithi, imida, polygonal okanye nayiphi na inkalo ukuba ke kusenza ukucoca idatha kwi-AutoCAD okanye kwi-Microstation.
txt ukuzenzekelayo

* Wonke amanqaku kufuneka abe nekhowudi.
* Wonke amanqaku kufuneka angeniswe omnye emva komnye, ngaphandle kokushiya imigqa engenanto.

Ukwaziswa kwedatha

Simele sibulele uJuan Manuel Anguita, umSaveli waseJaen, eSpeyin owenza umgudu wokwakha lo mkhulu. Ifayile Excel uye namagqabi amathathu, omnye ekuthiwa kuqala kubo lets babone igrafu isicwangciso kunye neembono icala (kwakhelwa womzobo Excel nyulu!). Kwakhona nganye yezo 9 quadrants iyakuboniswa, xa kukho utshintshi kwedatha kwitheyibhile «ukubukwa kwembono» isetyenziswe

zigqwesa kwaye zizenzekelayo

Qulunqa idatha yokuthumela ngaphandle

I Iphepha lesithathu ekuthiwa iinketho, wammisa ukuba ifayile uya kumazwe angaphandle uya kuhamba dimenciones ezimbini okanye ezintathu, ubungakanani bomgca, ukuba sifuna ezisezintabeni (eziphakamileyo) kunye negama lefayile DXF window ebonisiweyo.

umfanekiso

Xa iqhosha elibomvu lixinekile, ifayile ye .dxf idalwe, inokuvulwa nge-Microstation, Arcview, AutoCAD okanye phantse nayiphi na inkqubo ye-CAD. Kule ndawo, isalathisi sidalwe kwisicatshulwa ngasinye esifumaneka kwikholomu 'yoLoqo' (umz: i-lev), apho amanqaku agqityiweyo; khona okunye monbre kabani kuba colunma okubhaliweyo 'Layer' + txt (umz:. levtxt), zeziphi ezi khowudi, yaye omnye, apho zobukhulu; ezinokubhaliweyo monbre 'wadala ikholomu 'Imilinganiselo' + (ububanzi: i-levcotas). Ifayili evelele enegama elifanayo kunye kwindawo enye iya kudala.

Ifayili yokuya kuyo (dxf)

Lo ngumzekelo wefayile eboniswe kwi-AutoCAD. Emva koko unokutshintsha imibala yamacandelwana (ifomathi / izalathisi) okanye ifomathi yamanqaku (ifomathi / izitayela zamanqaku).

autocad txt ngaphezu

Kuyinto yesicelo esesabekayo, ukuba luncedo kwaye kulula ukuyilungisa. Musa ukudweba imigca, vele uthumele amanqaku.

Iimpendulo ze-64 "Ukusuka kwi-Excel ukuya kwi-AutoCAD, isishwankathelo sezona zinto zilungileyo"

  1. Ngo-AutoCAD kuphela, akunakwenzeka.
    Unako, ukuba ungenisa itafile njengedatha kwiinguqulo ze-AutoCAD njenge-Civi3D.
    Okanye ukuba wenza i-macro ne-AutoLisp enika itafile.

  2. Ndiyayixabisa ukuba ungandinceda ngophando lweetekisi kwi-autocad yeetafile ezigqwesileyo, zifumane kwaye zitshintshe umbala, ndiyathemba ukuba unako, ukubingelela.

  3. Ngokunyanzelekileyo le macro ayigqitywanga kuba ayivumelekanga ukuba isebenzise amaxesha ngamaxesha, kube kanye kwaye oku kuyenza ukuba ifakwe phakathi okanye mhlawumbi ayisetyenziswanga kwaye izamile ukwenza iifayile ezininzi kodwa ithi le fayile isetyenziswa yenye inkqubo ????????

  4. Sawuni Juan MAnuel

    Ndandifuna ulwazi ukuze ndiqhube iprojekthi endiyenayo engqondweni kwaye ndafumana le fayile.

    Ewe, andiyiyo ingcali ngokuqhubekayo, kodwa ndinengcamango yokuqhawula i-automation ye-geometric design of roads ngokusebenzisa i-editor ebonakalayo yomhleli.

    Injongo kukubala izinto zejometri zeejika ezahlukeneyo kwaye ezo zinqobo ndifumana njengexls, ziyiguqulele kwifomathi ye-ascii ukuyenza kwi-cad kunye neqonga le-micostation.
    Kwaye apho ndikwazi ukuqhubeka, andazi ukuba ndingayenza njani. Ukusuka oko ndikubona unayo ingcamango eninzi kwaye mhlawumbi unokunceda
    Ndingathanda kwakhona ukudala ikhowudi yokukhangela apho ndingayibona ngeso lengqondo i-curve kwisigcawu esiphezulu ngaphambi kokuthumela idatha kwiipulatifomu ezahlukeneyo.

    Ingqalelo yakho, mbulela kakhulu

  5. Kufuneka usebenzise imephu ye-AutoCAD okanye i-Civil 3D kule nto.
    Ukuba ungenayo, sebenzisa inkqubo yokuvula njengeQGis okanye gvSIG

  6. Hola

    Ndiyazi ukuba akufuneki ukwenza ngoku ngqo nesi sihloko, kodwa ukuba umntu unokundikhokela ngendlela endinokuthumela ngayo iifayile ze-autocad kwi-KML kwaye ndibeke imidwebo kwi-gmaps.

    Siyabonga kunye nokubhekiselele

  7. Siyabulela IZINTO KODWA KANYE KUPHELA luhamba UKWENZA Podro ngebhegi ENOBA OKANYE 2003 2007 EXEL ndinaye nam ezinye Iifomati EXEL AutoCAD NGAPHANDLE iphilile

  8. Igalelo elihle kakhulu! Ndifuna nje ukuba ufunde ngaphezulu kwe 1000 ingongoma, ndiyabona ukuba lukhuselwe ... ndakwazi ukufumana amanqaku kwi 950, ke mna zilungelelanise zamanqaku ngaphezu 5000 ... ngelishwa kundixelela password protected .. Kodwa negalelo elihle! Ndiyathemba ukuba umbhali uyakubona kwaye angakwandisa inani lamaphuzu ukungena.

    Nibingelela bonke!

  9. Siyabonga kakhulu ngokusinika isicelo esihle kakhulu. Ndiyonwabile kakhulu ngomsebenzi, umbuzo: Ngaba kunokwenzeka ukudibanisa ibloko kunye nephuzu ngalinye, umzekelo isangqa? Ukuba kunjalo, unokundixelela ukuba yintoni indlela.

    Ndiyabonga kakhulu sele sele

    UPatrick

  10. emihle kakhulu, oku ukusebenza kwee-Excel sheet, umbuzo ngokutsho iimvavanyo ndenze oku kuphela inani leendawo ekufuneka zenziwe igrafu, kwimeko yam kufuneka benze iigrafu points 4000 njengoko angenza ntoni ukutshintsha oku Excel yePivotTable njengoko Kuza kuthatha ixesha elide ukuba ndibe necebo lokucwangcisa.
    mbulelo kakhulu

  11. Ndiya kuthumela halala wam onyanisekileyo nombhali, oko kuya kukunceda gqitha ukuba abahloli, banethemba ukuqhubeka ukubaxhasa abanjalo TECHNICAL AIDS ukuphuhlisa ngokwam ngendlela echubekileyo ngakumbi kwixesha elizayo.

  12. Douglas ... kwi-AutoCAD Umele uvule ifayile,
    kwifayile yeefayile ezikhethiweyo dxf
    Ukhetha ifayile eyakhiwe ku-C kunye
    Ulungele !!!!!

  13. Ukuba isebenza kwi-2007, xa uvula ifayile ibonisa isilumkiso sokhuseleko, kufuneka ukhethe kuyo
    Khetha ...
    Nika amandla oku okuqukethwe kunye
    ukwamukela

  14. Ukuba ubhekisa kwifayile ye-Excel eboniswe kulo mzekelo, xa sele ungenisile kumakhonkco onxibelelwano, cofa iqhosha eliluhlaza ngombala ophuzi: «cofa ukuze wenze dxf»

  15. Ndifuna ukwazi indlela yokuhambisa idatha esuka etafileni ngokugqithiseleyo kwi-autocad, yintoni umyalelo wokusebenzisa.

  16. Ndingathanda ukuba undincede ... Ndizama ukufumana isicelo okanye isistim e-lsp. apho ungathumela khona iimpepha ukusuka kwi .dwg ukuya ku- .xls kuphela itekisi ozikhethayo kunye nemouse kwaye ungangena idatha ngebhobhodi xa ungeke ufumane umbhalo kumdwebo. kwaye ukuba izitriki ezingaphandle zikhethiweyo ukuba azivumeli ukuba ndiyikhethe kangangexesha elifunekayo.
    Ndine le ndlela
    (defun C: I-TXTOUT (/ vv vc vd vf vg vg); i-V1.0
    ; Ngo-Scott Hull, 11-20-86
    ; SAH Mechanical Design (415) 343-4015
    ; Imveliso ye-ASCII yokuthumela ifayile.

    (defun * impazamo * (st) (ngokukhawuleza (strcat «impazamo:» st «07 \ n»))

    (iseti yevaq (ifika igama «Igama lefayile ye-ASCII ukwenza:«) vb (vula (vula nge «r»))
    (ukuba (/ = = vb nil) (nxu lanisa (vv vb) (setq vc (ascii (cc
    «Ifayile eneli gama sele ikhona. «)))))
    (setq vc 89))
    (ukuba (= vc 89) (nxu lisela
    (iseti ye-vb (vula i-ve «w») vd (ssget) ve (sslength vd) vf 0)
    (ngexesha (

  17. Andisazi isitshixo, umbhali wasikhusela. Kodwa ayikuyekisi ukukopa iiseli

  18. Ukukopisha uncamathisele ikholam lwe data kwi spreadsheet oku andixelele ukuba iiseli akhuselwe, hayi yintoni na isitshixo ukusombulula le ngxaki, ukuba uyazi ukuba ube nombulelo gqitha

  19. Molweni bahlobo, ukuba ukusebenzisa 2007 ofisi kufuneka nje ukuba incwadi kuzakuguqula yona kwi uguqulelo, i icon kwi yasekhohlo ephezulu yeyona ndlela, nqakraza apho. Emva koko unika ukungenisa. Xa ucela ukhetho lokuvala nokuvula incwadi, nqakraza ku-YE. Iluxwayisa ukuba utshintsho olungalondoloziwe luya kulahleka, oko akunandaba, luyakwamkelwa kwaye sele lukhona (Ukuba le khetho ayifumananga ngcono). Ngaphambi kokuba usebenzise i macro bayenze phantsi menu nemivalo yayo Isilumkiso LOKHUSELEKO: Abanye asset umxholo iye ukhubazekile, nina Khetha LE DAS uya nqakraza kwi Yenza umxholo kwaye ukulungele .... UNGAKWAZI UKUSETSHENZISWA KWI-OFISI 2007.

    YENZA KONKE !!!!! (UNGAKHUMBI UKUBA UMSEBENZI WEMACRO KUFANELE UKUQHUBA NOKUBHALISA)

  20. Ukuba uthetha ukupasa umxholo, khetha itekisi kwi-Excel, ikopi, uze u-AutoCAD, unamathisele

  21. lungile njengoko bonke babuka kumbuzo wam kuku oku kulandelayo ukudlula i-fucking ephezulu, kwi-auto cad kodwa kwisicatshulwa?

  22. Ifayile elungileyo kakhulu. Imibuliso kulomfo oshiye le fayile, ukubona ukuba kuyakhutshwa kusini na imirhumo.

  23. akudingeki uguqule, faka nje idatha.

    Esi sicelo sikhuselwe ngephasiwedi, umbhali wenza

  24. molo, andikwazi ukuguqula iinketho zindibuza ngephasiwedi yokuphuma, ndingenza ntoni kule meko?

  25. g! okanye umntu Ndiza usebenza umzobo kwesitalato, phantse ndihleli ndizenza nesikhululo iyonke kodwa ngoku uziswe mna data yendlela kunye level (cross-macandelo) Ngaba umntu akwazi ukuguqula indlela ledatha UTM? Ndingayifumana axis echazwe kunye namacandelo zokufunda ezishiyekileyo imigama ukuya ku + okanye -, ekumbindi, imigama ekunene ukuya ku + okanye - ukuba umntu undinceda ...... jcpescotosb@hotmail.com

  26. Siyabonga kakhulu kubo bonke abenza oku kuphucuka.

    Phendula nge quote

  27. Ndiyabona ndifuna indlela yokwenza i-polygon kwaye uyilungiselele kodwa kwi-arcgis.

  28. Ndifuna kuqala ukubonga ihohofofo juancho ye-macro kunye ne-old g! ukufumana nokupapasha ... oko ndifaka isandla !!!!!

  29. ESEBENZA IN OFISI 2007 akusoloko ME kum isiphoso UTHI kumazwe angaphandle ukuya ifolda CY nto iphuma ndifumana window ukuba PERUTRAR ungandixeleli into emandiyenze SDE

  30. Enkosi ngempendulo yakho ekhawulezileyo, galvarezhn. Ngelishwa ayisebenzi.

  31. Imposiso kuqala, ndicinga ukuba kungaba ngenxa locale, apho watshintsha amawaka kunye umahluli (semicolon) buyekezwa wokugqibela ...

  32. kubonakala kunomdla, kuba ku-intanethi; Ndiya kubona ukuba ndiyakwenza uhlaziyo olunye usuku lwalo

    mbulela ulwazi

  33. xa inqanaba lokuzithemba le-macro liqwalaselwe, i-spreadsheet nokho ibonisa kwakhona umyalezo wephutha kwisithuba sesibini (PREVIEW).

    Nangona uqhubeka uthumela amaqaku kwi-dxf, ndingathanda ukunika ngokupheleleyo ukusebenza kwezi festile.

    Ndiyakuvuyela,

  34. ukuqwalasela izinga lokuzithemba

    Uya kwiqhosha lokugqwesa, elokuqala elingaphezulu ngasekhohlo, kwaye ukhethe iqhosha "lokubalasela",

    emva koko ukhetha "iziko lokuthemba"

    kwaye apho ukhetha «seta iziko lokuthemba»

    emva koko ukhetha "useto lweMacro"

    kwaye apho ukhetha "yenza zonke ii-macros"

  35. Ndiyakuvuyela kwaye ndikuxelele ukuba isebenza kakuhle kwi-ecxel 2007 kuphela ukuba kufuneka uqulunqe ukuxhomekeka kwizinga lokuzithemba kwaye ulungele

  36. I-OFICCE I-2007 AYISEBENZISI, UKUBA KUNYE NOKUPHENOMONI NJENGOMUNYE OTHINTILE ISICELO NO-UPDATES IT. KUTHANDA

  37. kulungile, ke uye kutshintsha ukulungiswa kwendawo kumatshini wakho

    qalisa / ukulawula ipaneli / isethingi sendawo

    ngoko ukhetha ilizwe lakho kwiinketho zengingqi

    Qiniseka ukuba amawaka asahluli anophawu "lwekoma" kunye neendlela zokwenza "ixesha" ziyasekwa

    ke uya kuhamba kwaye kufuneka usebenze

  38. isebenza ngaphandle kwemigxobhozo ...... kodwa kukho izilungiso aziyi kuba ngqo kwi-plane ... .. umtshini, ucebisa ntoni ???

  39. ufake zika rounded uvavanyo, okt ngaphandle idesimali ukubona ukuba ingxaki ayikho indawo (iziphumlisi kuba eyahlula amawaka kunye kwesishumi ngenxa yokuzahlula).

  40. Ndifumana iphutha,

    Ndingena kwii-nortes ne-eses idibene kunye nobukhulu kodwa akwenzi okokuqala

    lishiya i mpazamo
    Ixesha lokuqalisa; '1004,:
    akakwazi ukufumana isakhiwo se chart_bjects kwiklasi ye-worsheet

  41. i-macro ayisebenzi kum, unako ukunceda ???

    yonke i-boloqueda kwaye sele ikhona isakhono ukuze ubuninzi be-macro bubuncinane banjenge g! ukuphawula, akusebenzi kum! !!!!! ndincede

  42. Molo Marcos, inkqubo ivelisa umyalezo ongenakukwazi ukuguqula utshintsho, kodwa uyamamkela. Oko kukuthi ungatshintsha igama lefayile kunye nobungakanani besicatshulwa, kwaye xa uyikhupha uvelisa iziphumo.

    Kwimeko apho unengxaki enkulu, ungatshintshi ubungakanani bombhalo okanye igama lefayile, akuyimfuneko. Ubungakanani bokubhaliweyo bunokuhlelwa kwi-ngokuzenzekelayo.

  43. Sawu, ndizama ukusebenzisa le nkqubo ukupasa uphando olutshanje kwi-CAD, kodwa kwi-Excel yam ayivumeli ukuba ndiyitshintshe nayiphi na inokwenzeka kwiphepha lesithathu, ngaba le nto ingafanelekile? Siyabulela kwangaphambili.

  44. Miguel: i-macro ayisebenzi kunye ne-Excel 2007
    Joaquín: i-macros kufuneka inikwe amandla, oku kwenziwa kwizixhobo / macro / ukhuseleko kunye nokwenza ukhuseleko kwizinga eliphantsi.

  45. iphepha lakho eligqwesileyo lihle kakhulu kodwa i-macros ukuba ispredishithi ayisebenziyo iya kukhubaza into endiyenza ukuze ndisebenze ngokuchanekileyo

  46. Kuyindlela endiyisebenzisileyo ndiyisebenzise ixesha elide kodwa ndinenkinga enkulu:

    Akusebenzi neofisi ye2007.

    Ndiya kuxabisa nayiphina isisombululo kule ngxaki.

  47. Ndiyifumana umdla kakhulu kwimisebenzi engekho enkulu, ndiza kuzama ukubona indlela isebenza ngayo

  48. Sawubona Jordi, ngokunyanisekileyo andizange ndizame kwi-2007, ukubona ukuba ubani oye wazama apho kwaye uyaqinisekisa ukuba unika iingxaki

    ukubingelela

  49. galvrezhn, kuqala, feliciarte ingqokelela usuke wena kwenziwa kolu ngeno, kwaye kwelinye icala (ngoko ubona kukho wayelikhoboka ngakumbi xyz-DXF, hehe) wayefuna ukuphawula ukuba umntu, nokuba wena, basiva macro Excel 2007, 5 kuba kwakufuneka ukulusebenzisa-6 iminyaka kwiinguqulelo yangaphambili ye-Excel, kwaye andazi kutheni, kodwa oko akuthethi ukubaleka (mna imacros zesikocan yenziwe, nabo bonke).

    Un saludo

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.