Kubva Excel kusvika AutoCAD, muchidimbu chezvakanakisisa
Zvakanaka, ndinofanira kubvuma kuti zvave zvichifadza kutaura pamusoro pehurukuro iyi, saka mumutsetse uyu ndinoda kuratidza zvakanakisisa zvatakawana.
- Takaona kuti Microstation has integrated iro basa rinopinza zvakananga kubva pane faira re txt
- Takaonawo kuti sei ita izvi neAustCAD
- Takaona sei kutumira kunze kubva kuAccAD o Microstation kune csv kana txt
- Ipapo takaona kuti tingashandisa sei murairo concatenate kana vane mazano uye mararamiro ari nani
- Uye takaona a VBA application nokuti Microstation inoshanda nenzira mbiri
Asi kupfuura ose raiva kudzidza kubva munhu mutsanangudzo ake takataura pamusoro chokushandisa ichi unobvumira kubva Excel faira kuti vaunze mumwe DXF faira, uchishandisa Coordonatele ose X, y, z, imwe kuzivikanwa bumbiro uye pamwero apo tinoda kuti iwedwe.
Basa racho rinonzi XYZ-DXF uye iwe unogona download it here;
Ngationei kuti inoshanda sei:
1 Mhemberero yedhara:
Ichi chishandiso chakakodzera ruzivo rwakadzvanywa kubva kune vegps kana chiteshi chese, sekureba sekunge maumbirwo ari UTM, zvinoreva kuti zvikamu zvaro mundege yeCartesian zviri mumamita. Iyo kodhi kodhi chiratidzo cheinongedzo, kozoti x, y, z zvinowirirana uye pakupedzisira danga ratinoda kuti vatorwe, idzi dzinogona kuve, semuenzaniso, nzira yemugwagwa, miti, miganhu, polygonal kana chero hunhu hunotibvumidza gare gare Sefa iyo data muAutoCAD kana Microstation.
* Pfungwa dzose dzinofanira kuva nekodhi.
* Pfungwa dzose dzinofanira kunge dzakapinda imwe pashure peimwe, pasina kusiya mitsetse isina chinhu.
Kuona Dhiyabhorosi
Kutenda kuna Juan Manuel Anguita, munyori wepamusoro kubva kuJaén, Spain uyo akaedza kuvaka iyi macro. Iyo Excel faira ine mapepa matatu, rimwe rawo rinonzi Preview rinokutendera kuti uone girafu muchirongwa chekutarisa, uye nedivi maonero (akavakwa kune yakachena Excel graph!). Zvakare imwe neimwe yeaya 9 quadrants inogona kutariswa, kana ichichinja data mutafura iyo "update maonero" bhatani rinoshandiswa.
Rongedza dare rekutumira
Dhidhi yechitatu inonzi zvingasarudzwa, inotibvumira kutsanangura kana faira yatinozotengesa ichaenda mumatanda maviri kana matatu, ukuru hwetsamba, kana tichida kuratidzira kukwirira (kuyerwa) uye zita re dxf file.
Kamwe bhatani repepuru parinodzvanywa, iyo .dxf faira inogadzirwa, iyo inogona kuvhurwa neMicrostation, Arcview, AutoCAD kana chero chero chirongwa cheCAD. Mune izvi, rukoko rwunogadzirirwa yega yega zvinyorwa zvakasiyana zvinowanikwa mukoramu ye 'Layer' (semuenzaniso: lev), panovepo poindi. Pachavewo nehumwe hwara rine zita rinozove iwo mavara ekoramu 'Layer' + txt (ex.: Levtxt), pachave nemacode, uye imwe ichagadzirwa, panenge paine zviyero, iine zita rekuti 'zvinyorwa zve column 'Layer' + zvimiro (ex: levcotas). Faira rakapfuura rine zita rimwe chete uye munzvimbo imwechete rakagadzirwa zvakare.
Ifa yekuenda (dxf)
Uyu ndiwo muenzaniso wefaira rinotariswa kubva kuAutoCAD. Ipapo iwe unogona kushandura iwo mavara ezvidimbu (fomati / zvidimbu) kana iyo poindi fomati (fomati / poindi zvitaera).
Icho chingori chiri chinoshamisira kunyorera, chekuti chinobatsira sei uye zvakapusa kubata. Iyo haina kudhirowa mitsara, inongotumira mapoinzi.
Ne AutoCAD chete, izvozvo hazvibviri.
Iwe unogona, kana iwe ukatora tafura se database pane AutoCAD versions seCivi3D.
Kana kana iwe ukaita macro neAllLisp inopa tafura.
Ndinoonga kuti iwe unogona kundibatsira nekutsvaga magwaro mu autocad yefurafura yakanakisisa, uiwane uye uchinje ruvara, ndinovimba iwe unogona, kukwazisa.
Zvakanaka purogiramu
gracias
EXCELLENT !!!! THANK YOU ..
Ini ndinowana kukanganisa 1004 panguva yekumhanya….
kutendeseka zvakaipa izvi zvakawanda hazvina kukwana sezvo zvisiri kushandiswa kanoverengeka, kamwe chete uye izvi zvinoita kuti zvive zvisina kufanira kana zvichida hazvisati zvashandiswa asi zvakaedza kugadzira mafaira akawanda asi inoti faira iri kushandiswa neimwe purogiramu ????????
Hello Juan MAnuel
Ndakanga nditsvaga ruzivo kuti ndiite basa randakanga ndava mupfungwa uye ndakawana iyi faira.
Zvakanaka, ini handiri nyanzvi yekufambira mberi, asi ndine pfungwa yekunyengedza kushandiswa kwejiyamuri yemugwagwa yemigwagwa kuburikidza nemuvara wezvinyorwa mukuru wepamusoro.
Chinangwa ndechokuverenga mazamu ejemiometric ezvimwe mavhesi uye maitiro ayo andinowana sei xls, achivashandura kune mafaira ascii kuti avatevere mu cad uye microstation platform.
Uye ndiko kwandisingagoni kuramba, ini handizivi kuti ndinozviita sei. Kubva pane zvandinokuona iwe une mazano mazhinji ezvo uye zvichida iwe unogona kundibatsira
Ndinodawo kuumba kodeti kuti iite nharo iyo ini ndinogona kufungidzira ivhare iri mune imwe mafirimu asati apfuura kunze kwekutumira data kumapuratifomu akasiyana.
Nokuda kwako, unotenda zvikuru
Iwe unofanirwa kushandisa muto weAcotCAD kana Civil 3D yeizvi.
Kana iwe usina, shandisa chirongwa chepensource seQGis kana gvSIG
Hola
Ndinoziva kuti hazvifaniri kuita chaizvoizvo nehurukuro iyi, asi kana mumwe munhu achanditungamirira pane zvandingaita kutumira mafaira autocad kuKML uye kuisa mifananidzo pane gmaps.
Vongai uye zvakanakisisa matauriro
hapana chakanonditaurira kuti ndinofanira kubvisa
Ndinokutendai ACHASHANDISWA ASI kamwe chete Rinomhanyira kuita Podro reusable kana 2003 2007 Excel Iniwo ndine mamwe UIVERENGE KANA Excel AUTOCAD PASINA A dzakaonda
Rubatsiro
mumwe munhu anogona kundibatsira
Mupiro wakanaka kwazvo !! Ini ndinongoda kuti iwe uverenge zvinopfuura chiuru poindi, ini ndinoona kuti yakachengetedzwa ... ini ndakakwanisa kuisa mapoinzi anosvika ku1000, zvisinei ini ndine zvinongedzo zvinopfuura 950 poindi ... zvinosuwisa kuti zvinondiudza zvakachengetedzwa nepassword .. Asi chakanakisa mupiro! Ndinovimba munyori anoona izvi uye anogona kuwedzera huwandu hwemapoinzi kuti akwanise kupinda ..
Kwaziso kune vose!
Ndinokutendai zvikuru pamusana pokutipa sarudzo yakadaro. Ndiri kufara kwazvo nebasa racho, mubvunzo: Zvinoita here kushamwaridzana nechigadziro nechikamu chimwe nechimwe, somuenzaniso denderedzwa? Kana zvakadaro, iwe unogona kundiudza kuti ndeipi nzira.
Ndinokutendai zvikuru
Patricio
chakanakisisa zvakanaka, functionality uku Excel jira, mubvunzo maererano nemiedzo ndakaita izvi rinongotaura nhamba pfungwa kuti graphed, kana hwangu zvandinoda kuita calculators pamusoro 4000 pfungwa sezvo ini kuita kuti achinje ichi Excel PivotTable sezvo Zvaizoda nguva refu kuti kuronga seccionadamente.
thank you very
Ndinotuma dzangu makorokoto yakatendeseka kuti munyori, ndiko kubatsira zvikuru vaiongorora, tariro kuramba kugamuchira vakadaro Technical AIDS kukudziridza pachangu nenzira zvikuru nyanzvi nzira mune ramangwana.
Douglas ... muAutoCAD iwe unongofanirwa kupa faira kuvhura,
in file file type dxf
Iwe unosarudza faira yaive yakaitwa muna C uye
Ready !!!!!
Kana ikashanda mu2007, kana iwe ukazarura faira inoratidza nyevero yekuchengeteka, iwe unofanirwa kusarudza
Sarudzo ...
Itai kuti zvinyorwa izvi uye
kubvuma
Kana uri kureva faira reExcel rinoratidzwa mumuenzaniso, kana wangopinda mumakonisheni, dzvanya bhatani repepuru rine mavara eyero: “dzvanya kugadzira dxf”
Ndinoda kuziva kuti kutakura sei data kubva patafura mune zvakanakisisa ku autocad, chii chiri murairo wokushandisa.
Ndinoda kuti mundibatsire ... ndiri kuyedza kutsvaga chishandiso kana chiitiko mu lsp. Naiyo yaunogona kutumira kunze zvinyorwa kubva ku. uye kuti zvinyorwa zvinotumirwa kunze hazvina kusarudzwa kana zvisingandibvumidze kuti ndizvisarudze kakawanda pazvinenge zvichidikanwa.
Ndine chiitiko ichi
(defun C: TXTOUT (/ vv vc vd vf vg vg); V1.0
; By Scott Hull, 11-20-86
; SAH Mechanical Design (415) 343-4015
; Kutengeserana kwemashoko ASCII mavaraira.
(defun *error* (st) (prompt (strcat “error:” st “07\n”)))
(setq inoenda (getstring "Zita reASCII faira kugadzira:") vb (kuvhura kunoenda "r")
(kana (/ = vb nil) (tsvumira (svitsa vb) (setq vc (ascii (strcase (getstring
“Faira rine zita iri ratovepo.\nUrikuda kuritsiva here? ")))))
(setq vc 89))
(kana (= vc 89) (taura
(setq vb (vhura va “w”) vd (ssget) ve (sslength vd) vf 0)
(panguva (
Handizivi kiyi, munyori akadzivirira. Asi hazvikudziviri kuti urege kutora masero
Kuzokwanisa kunyora nekunyora korona yedata kubva paspredishiti izvi zvinondiudza kuti masero anodzivirirwa, uye handizivi kuti chii chinoshandiswa kugadzirisa dambudziko iri, kana uchiziva kuti ndichaonga
Mhoro shamwari, kuti ugone kuishandisa muhofisi 2007 iwe unofanirwa kungoishandura kuita iyo vhezheni, mu icon pane yekumusoro kuruboshwe ndiyo sarudzo, CLICK ALLI. Wobva waipa kuti igamuchire. Kana ikabvunza sarudzo yekuvhara nekuvhura bhuku, tinya HUNGU. Iyo inokuyambira kuti shanduko dzisina kuchengetedzwa dzicharasika, izvo hazvina basa, zvinongogamuchirwa uye ikozvino (Kana iyi sarudzo ISINGAONEKE, zvirinani). Usati washandisa macro unofanirwa kucherechedza pazasi mebhawa remenyu KUCHENJESWA KWENYAYA: Zvimwe zvirimo zvirimo zvadzimwa, enda KUSARUDZO UYE BONESA Bvumira iyi yezvinhu uye voila…. UNOGONA KUSHANDISA IYE Hofisi 2007.
KUKUNDA KUVANHU !!!!! (Usataurira kuti kusarudzwa kweMACRO KUNOFANIRA KUTI KUVE KUNYORWA NOKUDZIDZA)
Kana iwe uchida kupfuudza zviri mukati, sarudza mavara mu Excel, kopi, uye zvakare kuAccCAD, pata
Zvakanaka sokuti vose vanotarisa mubvunzo wangu ndeyekutevera kupfuudza fucking zvakanakisisa, kumotokari asi mumagwaro?
Ndine faira yakaisvonaka Kwazisai mukomana akasiya iyi faira, kuti aone kana zvipo zvizhinji zvakasunungurwa.
haufaniri kuishandura, ingopinda data.
Icho chinoshandiswa chinodzivirirwa nephasiwedi, munyori akaita
Mhoro, ini handigone kuchinja zvandinosarudza zvandinokumbira kuti ndipe password yaunokwanisa kuita munyaya iyi
g! kana munhu ndiri kushanda mifananidzo ine mugwagwa, dzinenge nguva dzose kuita ane zvachose chiteshi asi zvino zvamandisvitsa motokari Data uye pamwero (muchinjikwa-Zvikamu) Pane munhu azive kuti exchange umboo iyi UTM? Ndine chinyorwa chakatsanangurwa uye kuverengwa kwezvikamu zvikamu zvakasara zvakakwirira mukati + kana-, -pamusoro-kati, marefu kusvika kwakakwirira mu + kana-... kana mumwe munhu akandibatsira jcpescotosb@hotmail.com
Ichi chikuru chakakosha zvikuru kuvaya vose vanoita izvi zvichiitika.
Reply with quote
hello ndiri kutsvaga nzira yekuumba polygon uye kuigadzirisa asi muArcgis.
Chekutanga pane zvese, tenda togographer Juancho nezve macro uye zvekare murume mukuru! yekuiwana uye kutsikisa ... wakadii mupiro mukuru !!!!!
iyo faira inouumba mu c:
kwaunoita dxf file
Si funciona
WORKS IN OFFICE 2007 nguva ME ME OUT ERROR oti ekisipoti kuti forodha musi CY hapana chinobuda I kuwana hwindo kuti PERUTRAR UYE kundiudza zvokuita SDE
Ndine urombo, handizivi kuti chii chichava
Ndinokutendai nekupindura kwenyu nokukurumidza, galvarezhn. Zvinosuruvarisa kuti haina kushanda.
iko kukanganisa kwekutarisa, zvinoita kwandiri kuti zvinogona kunge zviri nekuda kwekugadziriswa kwedunhu, kuti iyo yekuparadzanisa zviuru nezviuru (semicolons) zvashandurwa, tarisa ...
zvinotaridzika zvinonakidza, nokuti zviri paIndaneti; Ini ndichaona kana ndikazoongorora rimwe zuva reizvi
thanks for the info
Ndakawana shanduro yakasununguka yewebhu yekutumira kune dxf kutendeuka
PASS TEXT X, Y, ZA DXF (TOPOGRAPHY)
http://www.konstruir.com/topografia/
Kana imwe nguva kuvimba kwema macro kwakagadziriswa, spreadsheet zvakadaro zvichiri kuratidza mhosho yemashoko kune yechipiri tab (PREVIEW).
Kunyangwe iwe uchiramba uchitumira zvinyorwa kune dxf, ndinoda kubvumira zvakakwana kushanda kwepaspiritsi ino yemazuva ano.
Congratulations,
kugadzirisa chivimbo chezinga
unoenda kune bhatani reexcel, iro rinotanga kumusoro kuruboshwe, uye sarudza bhatani re "excel options",
wobva wasarudza "trust center"
uye ipapo iwe unosarudza "gadzirisa trust centre"
wobva wasarudza "macro settings"
uye ipapo unosarudza "gonesa macros ese"
Ikoko pandinoisa chivimbo chepamusoro mu 2007 kupfuura
Ndinokukwazisa uye ndinokuudza kuti inoshanda zvakanaka muExxel 2007 chete kuti iwe unofanirwa kugadzirisa yekare kune imwe yehutariro uye yakagadzirira
NAOICICCE 2007 HAIYE KUSHANDISA, KANA KUTI PANE PENYENONI SOMWE IYE YAKAITA KUDZIDZISWA NEZVINHU ZVAKAITIKA. THANK YOU
kune zvakanaka, zvino enda kuenda kuchinja shanduko yekugadzirira kumashini ako
kutanga / kudzora jeri / mahara ekugadzirisa
ipapo iwe unosarudza nyika yako mune zvekusarudzwa kwenharaunda
ipapo ita shuwa kuti zviuru zvinoparadzanisa zvinogadzikwa nechiratidzo "comma" uye madhisimali ane "dot"
ipapo iwe unoenda kunopfuura uye unofanirwa kushanda
Inoshanda isina madimikira …… asi ipapo iwo maratidziro aisazove chaiwo mundege… .. hundi, unondipa zano rei ???
edza kupinda muhutano hwakapoteredza, izvo zvisina kumira kuti zvione kana zvisiri dambudziko rekugadzirisa kwemuganhu (kuti makasasi ari ezvuru zvekuparadzanisa uye chikonzero chekuparadzaniswa kwezvakawanda).
Ndiri kuwana mhosho,
Ini ndinopinda nhaurirano nortes neeses nechidimbu asi haiti kuita previsualizacion
iyo inoshiya kukanganisa
Nguva yekumhanya; '1004,:
haikwanise kuwana chati chartObjects yemukirasi worsheet
Zvakanaka, inofanira kushanda pasina matambudziko
2002 inopfuura
Ko ini ndichashayikwa chimwe chinhu here?
hi shaka, chii chakanakisisa chaunacho?
iyo macro haishandi kwandiri, unogona kundibatsira ???
iyo yose boloqueda uye inenge isina hubilete kuitira kuti kuchengetedzwa kwema macro ishoma seg g! comment, it does not work for me !!!!! ndibatsire meeee
Hi Marcos, iyo inogadzira mharidzo yekuti haugone kuchinja shanduko, asi kana iwe uchigamuchira. Mune mamwe mazwi, unogona kuchinja zita refaira uye ukuru hwemashoko, uye kana iwe uchimhanya inoita chigumisiro.
Kana uine mamwe matambudziko, usashandise hukuru hwemashoko kana zita refaira, hazvidiwi. Ukuru hwemashoko kunogona kugadziridzwa mu autocad.
Hello good'm kuedza kushandisa chirongwa ichi kuti tipedze duku kumukira Exchange pa angu vachivapa havandibvumiri kuchinja chero yaibvira jira wechitatu, uyu angava yakafanira aq? Thanks pachine.
Miguel: iyo macro haishande neExcel 2007
Joaquín: macros inofanira kusimbiswa, izvi zvinoitwa muzvishandisi / macro / kuchengeteka uye inoita kuti huve nekuchengeteka pakaderera.
wenyu Excel jira rakanaka chaizvo asi macro riwanikwe spreadsheet asingashandi zvichaita chokukuvadza ndinogona kuita kuti kushanda zvakanaka
Icho chinhu chakakosha chaizvo chandakanga ndave ndichichishandisa kwenguva yakareba asi ndine dambudziko guru:
Haiti kushanda nehofisi 2007.
Ndinogona kuonga chero sarudzo yedambudziko iri.
Ndinozviwana zvichifadza zvikuru kunyanya kwete mabasa makuru kwazvo ini ndichaenda kuzoona kuti akadaro
Sawa Jordi, ini zvechokwadi handina kuedza ku2007 kupfuura, kuona kana mumwe munhu akazviedza ipapo uye anosimbisa kana ichipa zvinetso
kukwazisa
galvrezhn, kutanga, feliciarte kuunganidza iwe waita kupinda ichi, uye Ukuwo (saka unoona pane muropa zvikuru kuna xyz-DXF, hehe) aida kupindura kana mumwe munhu, kana iwe, vakaravira makro Excel 2007, 5 nekuti ndaifanira kushandisa nayo-6 makore mushanduro Excel dzapfuura, uye handizivi sei, asi haina kumhanya (ndine macro kwakaita, nezvose).
Thanks!