Excel rau AutoCAD, cov ntsiab lus ntawm qhov zoo tshaj plaws
Zoo, Kuv yuav tsum lees tias nws tau kev lom zem tham txog cov ntawv no, yog li hauv no ncej kuv xav qhia qhov zoo tshaj plaws uas peb nrhiav tau.
- Peb pom tias Microstation muaj kev ua ke lub functionality mus import ntawm tus txt ntaub ntawv
- Peb kuj pom li cas ua nrog AutoCAD
- Peb pom li cas export ntawm AutoCAD o Microstation rau csv lossis txt
- Tom qab ntawd peb pom yuav ua li cas siv cov lus txib concatenate nyob rau hauv cov ntaub ntawv ntawm muaj bearings thiab ncua mus zoo
- Thiab peb pom ib qho VBA daim ntawv thov rau Microstation uas ua haujlwm ntawm ob qho tib si
Tab sis zoo tshaj plaws ntawm tag nrho cov yog kawm tau los ntawm ib tug neeg uas nyob rau hauv nws cov lus peb tham txog qhov cuab tam uas tso cai rau los ntawm ib tug Excel ntaub ntawv los ua kom muaj ib tug DXF ntaub ntawv, siv cov coordinates ntawm x, y, z, ib tug cim code thiab qhov twg peb xav kom nws kos duab.
Daim ntawv thov hu ua XYZ-DXF thiab koj tuaj yeem tau txais download nws ntawm no;
Cia peb kawm saib ua li cas nws ua hauj lwm:
1. Cov ntaub ntawv keeb kwm:
Daim ntawv thov no yog qhov tsim nyog rau cov ntaub ntawv rub tawm los ntawm gps lossis tag nrho cov chaw nres tsheb, ntev npaum li qhov sib koom tes yog UTM, nws txhais tau tias nws cov koog hauv Cartesian dav hlau yog hauv meters. Lub kem ntawm txoj cai yog tus cim ntawm qhov taw tes, tom qab ntawd x, y, z tswj thiab thaum kawg txheej uas peb xav kom lawv tau kos, cov no tuaj yeem yog, piv txwv li, txoj kab axis, ntoo, thaj tsam, polygonal lossis txhua tus yam ntxwv uas tom qab tso cai rau peb lim cov ntaub ntawv hauv AutoCAD lossis Microstation.
* Tag nrho cov ntsiab lus yuav tsum muaj chaws.
* Tag nrho cov ntsiab lus yuav tsum muab nkag rau ib qho tom qab sib, tsis tau tawm hauv seem ntawm kab.
Cov ntaub ntawv Visualization
Ua tsaug rau Juan Manuel Anguita, Topographer los ntawm Jaén, Spain uas tau siv zog los tsim cov macro no. Cov ntaub ntawv Excel muaj peb nplooj ntawv, ib qho ntawm lawv hu ua Saib Ua Ntej tso cai rau koj pom cov duab hauv kev npaj saib, thiab kev pom sab (ua rau Excel daim duab ntshiab!). Tsis tas li ntawd txhua tus ntawm 9 quadrants no tuaj yeem pom, thaum hloov cov ntaub ntawv hauv lub rooj siv "hloov tshiab views" khawm.
Configure data rau export
Qhov thib peb daim ntawv hu ua xaiv, teem seb cov ntaub ntawv koj yuav export yuav mus nyob rau ob los yog peb dimenciones, lub koos pis loj, me, yog hais tias peb xav elevations (heights) thiab lub npe ntawm tus DXF ntaub ntawv yog tso tawm kom pom.
Thaum khawm xim paj yeeb, nias .dxf ntawv tsim, uas tuaj yeem qhib nrog Microstation, Arcview, AutoCAD lossis yuav luag txhua lub CAD program. Hauv qhov no, txheej tau tsim rau txhua cov ntawv sib txawv pom hauv kab 'Txheej' (piv txwv: lev), qhov twg cov ntsiab lus yuav raug; Tseem yuav muaj lwm txheej ntxiv uas nws lub npe yuav yog cov ntawv ntawm kab 'Layer' + txt (ex: levtxt), qhov twg cov cim yuav nyob, thiab lwm qhov yuav raug tsim, qhov twg qhov ntev yuav, nrog lub npe 'ntawv ntawm kem 'Txheej' + qhov ntev (ex: levcotas). Ib qho ntaub ntawv zoo tshaj nrog tib lub npe thiab hauv tib lub hom phiaj yog tseem tsim.
Cov ntaub ntawv lo lus uas peb ua (dxf)
Nov yog cov piv txwv ntawm cov ntaub ntawv pom los ntawm AutoCAD. Tom qab ntawd koj tuaj yeem hloov cov xim ntawm cov khaubncaws sab nraud povtseg (hom ntawv / txheej) lossis hom qauv (qauv / hom qauv).
Nws tsuas yog qhov thov tau zoo heev, rau kev siv tau yooj yim thiab yooj yim nws yog los daws. Nws tsis kos kab, nws tsuas yog xa cov ntsiab lus.
Nrog AutoCAD tsuas, uas tsis tau.
Koj ua tau, yog tias koj tuaj yeem hloov lub rooj raws li database hauv AutoCAD versions xws li Civi3D.
Los sis yog tias koj ua ib qho lag luam nrog AutoLisp uas ua rau lub rooj.
Kuv txaus siab rau koj tuaj yeem pab kuv nrog kev tshawb nrhiav hauv autocad ntawm lub rooj zoo, nrhiav lawv thiab hloov xim, kuv vam tias koj tuaj yeem, txais tos.
Kev kawm zoo heev
Tsaug
TSIM NYOG !!!! THANKS ..
Kuv tau txais yuam kev 1004 thaum lub sijhawm khiav….
siab phem phem no macro tsis tiav vim siv tsis tau ob peb zaug, tsuas yog ib zaug xwb thiab qhov no ua rau nws nruab nrab lossis tej zaum nws siv tsis tau tab sis kuv tau sim tsim ntau cov ntaub ntawv tab sis nws hais tias cov ntaub ntawv raug siv los ntawm lwm qhov kev pab cuam ??? ?????
Nyob zoo Juan MaNuel
Kuv tau nrhiav cov ntaub ntawv los ua ib qhov project uas kuv muaj nyob rau hauv lub siab thiab kuv pom cov ntaub ntawv no.
Thiab kuv tsis yog tus kws tshaj lij hauv kev ua haujlwm, tab sis kuv muaj lub tswv yim ntawm craer lub automation ntawm cov duab tsim ntawm txoj kev los ntawm cov kev paub txog kev sau ntawv ntawm kev tshaj tawm.
Lub hom phiaj yog los laij cov ntsiab lus geometric ntawm cov nkhaus sib txawv thiab cov txiaj ntsig uas kuv tau txais li xls, hloov lawv mus rau ascii hom los ua rau lawv ntawm cad thiab microstation platform.
Thiab qhov no yog qhov uas kuv mus tsis tau ntxiv, Kuv tsis paub yuav ua li cas. Los ntawm kuv pom koj muaj ntau lub tswv yim thiab tej zaum koj tuaj yeem pab kuv
Kuv kuj xav craer ib craer chaws los ntawm qhov uas koj tuaj yeem pom tau qhov kev nkhaus hauv kev ua qauv excel ua ntej xa cov ntaub ntawv mus rau qhov sib txawv platforms.
Rau koj paub, ua tsaug rau koj.
Koj yuav tsum siv daim ntawv qhia kev AutoCAD lossis Civil 3D rau qhov no.
Yog tias koj tsis muaj nws, siv qhov kev pabcuam rau kev kawm xws li QGis lossis gvSIG
Nyob zoo
Kuv paub tias nws tsis tau ua raws nraim nrog lub ntsiab lus no, tab sis yog hais tias ib tug neeg tuaj yeem coj kuv li cas kuv tuaj yeem export cov ntaub ntawv autocad rau KML thiab muab cov duab kos rau ntawm gmaps.
Tsaug thiab regards
nws tsis ua haujlwm, nws qhia kuv tias kuv yuav tsum tau debug
UA TSAUG KOJ RAU TUS KHOOM TAB SIS ib zaug XWB sau ZOO LI UA LI CAS Podro reusable seb puas los yog 2003 2007 EXCEL kuv thiab muaj ib co tswv yim EXCEL Autocad TSIS A ntshiv
Pab
ib tug neeg tuaj yeem pab kuv
Pab zoo heev !! Kuv tsuas yog xav kom koj nyeem ntau dua 1000 cov ntsiab lus, Kuv pom tias nws muaj kev tiv thaiv ... Kuv tau tswj kom muab cov ntsiab lus mus txog 950, txawm li cas los xij kuv muaj kev tswj hwm ntawm ntau dua 5000 cov ntsiab lus ... hmoov tsis nws qhia kuv tiv thaiv nrog tus password .. Tab sis zoo heev pab! Kuv vam tias tus sau pom qhov no thiab tuaj yeem nce tus lej ntawm lub ntsiab lus kom tuaj yeem nkag mus ..
Txais tos rau txhua tus !!
Ua tsaug ntau ntau rau kev muab daim ntawv zoo li no. Kuv tau ua haujlwm heev, qhov lus nug: Nws puas tuaj yeem koom nrog ntawm txhua qhov taw qhia ib ntu, piv txwv li lub voj voog? Yog li ntawd, koj puas kam qhia kuv txoj kev.
Ua tsaug ntau ntau
Patricio
zoo heev zoo, qhov no functionality ntawm lub Excel ntawv, lo lus nug raws li cov kev ntsuam xyuas kuv twb ua li no tas tus xov tooj ntawm cov ntsiab lus yuav tsum tau graphed, nyob rau hauv kuv cov ntaub ntawv kuv yuav tsum tau ua los txog 4000 cov ntsiab lus raws li kuv yuav ua li cas hloov no Excel PivotTable li nws yuav siv sij hawm ntev heev yuav tsum tau plotting seccionadamente.
heev xav thov ua tsaug
Kuv xa kuv sincere nrog koj zoo siab rau sau, nws yog ib tug zoo kev pab rau surveyors, cia siab tias yuav tau txais tej KEV AIDS los tsim kuv tus kheej nyob rau hauv ib tug ntau kev txoj kev nyob rau hauv lub neej yav tom ntej.
Douglas ... nyob rau hauv AutoCAD koj tsuas yog yuav tsum muab cov ntaub ntawv qhib,
hauv filetype selleccionas dxf
Xaiv cov ntaub ntawv uas tau tshwm sim hauv C thiab
Npaj txhij !!!!!
Yog tias nws ua hauj lwm hauv 2007, thaum qhib cov ntaub ntawv nws qhia txog kev ceeb toom kev ruaj ntseg, koj yuav tsum xaiv
Xaiv ...
Pab kom cov ntsiab lus no thiab
txais
Yog tias koj xa mus rau Excel cov ntaub ntawv qhia hauv qhov piv txwv, thaum koj tau nkag mus rau hauv kev tswj hwm, nias lub pob liab liab nrog cov ntawv daj: "nias los tsim dxf"
Kuv xav paub yuav ua li cas coj cov ntaub ntawv los ntawm lub rooj rau excel rau autocad, dab tsi yog qhov lus txib kom siv.
Kuv xav kom koj pab kuv ... Kuv sim nrhiav ib daim ntawv thov lossis ib txwm ua hauv lsp. Nrog rau qhov uas koj tuaj yeem xa cov ntawv los ntawm .dwg mus rau .xls tsuas ntawv uas koj xaiv nrog tus nas thiab tib lub sijhawm tuaj yeem nkag mus rau cov ntaub ntawv nrog cov keyboard yog tias tsis muaj ntawv nyob hauv kos duab. thiab tias cov ntawv luam tawm tsis raug xaiv yog tias nws tsis pub kuv xaiv nws ntau zaus raws li qhov tsim nyog.
Kuv muaj qhov no
(ntsiab lus C: TXTAWV (/ va vb vd vd vg); V1.0
Ntawm Scott Hull, 11-20-86
; SAH Mechanical Tsim (415) 343-4015
; Hloov ASCII ntawv nyeem.
(defun *error* (st) (them (strcat “yuam kev:” st “07\n”)))
(setq mus (getstring "Lub npe ntawm ASCII cov ntaub ntawv los tsim: ") vb (qhib mus "r"))
(yog (/ = vb nil) (progn (kaw (vb) (setq vc (ascii (strcase (getstring
“Ib daim ntawv nrog lub npe no twb muaj lawm.\nKoj puas xav hloov nws? “))))))
(setq vc 89))
(yog tias (= vc 89) (progn
(setq vb (qhib mus “w”) vd (ssget) ve (sslength vd) vf 0)
(thaum lub sijhawm
Kuv tsis paub tus password, nws tau tiv thaiv los ntawm tus sau. Tab sis nws tsis tiv thaiv koj los ntawm kev luam cov hlwb
Kom muaj peev xwm luam thiab muab cov ntaub ntawv los ntawm daim ntawv khom nqi rau qhov no qhia kuv tias lub hlwb raug tiv thaiv, thiab kuv tsis paub dab tsi yog tus yuam sij rau kev daws tau qhov teeb meem no, yog tias koj paub tias kuv yuav muaj kev ris txiaj heev
Nyob zoo cov phooj ywg, kom siv tau rau hauv chaw ua haujlwm 2007 koj tsuas yog yuav tsum hloov nws mus rau version, hauv lub cim ntawm sab laug sab saum toj yog qhov kev xaiv, NYEM ALLI. Tom qab ntawv koj muab nws los lees. Thaum nug kom muaj kev xaiv kaw thiab qhib phau ntawv, nyem YOG. Nws ceeb toom rau koj tias qhov kev hloov pauv tsis tau txais yuav ploj, uas tsis muaj teeb meem, nws tsuas yog lees txais thiab tam sim no (Yog tias qhov kev xaiv no TSIS PUB LEEJ TWG, zoo dua). Ua ntej siv cov macro koj yuav tsum tau saib hauv qab ntawm cov ntawv qhia zaub mov TXOJ KEV CEEB TOOM: Qee cov ntsiab lus tseem ceeb tau raug xiam oob khab, MUS RAU TXOJ CAI thiab NYEM RAU Pab kom cov ntsiab lus no thiab voila…. KOJ TUAJ YEEM HWJ YWM SIV IN OFFIC 2007.
LUCK RAU TXHUA HNUB !!!!! (TSIS TXAUS SIAB MACROS XAIV YUAV TSUM UA NTEJ THIAB TXAWV)
Yog hais tias koj txhais hais tias kom dhau cov ntsiab lus, xaiv cov ntawv nyeem hauv Excel, luam, thiab tom qab ntawd ces hauv AutoCAD, muab tshuaj
zoo li lawv txhua tus saib kuv lo lus nug yog cov nram qab no kom dhau lub fucking excel, mus pib cad tab sis nyob rau hauv ib phau ntawv?
Cov ntaub ntawv zoo heev. Ua tsaug rau cov phooj ywg uas tau tso cov ntaub ntawv no tseg, kom pom tias muaj kev koom tes ntau ntxiv.
koj tsis tas yuav hloov nws, cia li nkag mus rau cov ntaub ntawv.
Daim ntawv thov no yog kev tiv thaiv (password), nws puas yog tus sau
Nyob zoo, Kuv tsis tuaj yeem hloov kho cov kev xaiv, nws nug kuv txog tus password uas tsis muaj kev tiv thaiv, Kuv tuaj yeem ua li cas rau qhov no?
g! los yog ib tug neeg, kuv tabtom ua haujlwm ntawm txoj kev ntawm txoj kev, yuav luag txhua zaus ua nrog qhov chaw nres tsheb tiam sis tam sim no kuv tau coj cov ntaub ntawv txog tsheb thiab theem (Cross sections) puas muaj leej twg paub hloov hloov cov ntaub ntawv no mus rau UTM? Kuv muaj txhais axis thiab qhov nyeem ntawm qhov seem yog ncua qhov siab ntxiv rau hauv + lossis -, kab hauv nruab nrab, ncua qhov siab qhov siab hauv + lossis - - yog tias ib tug neeg pab kuv jcpescotosb@hotmail.com
Qhov no macro yog zoo heev rau tag nrho cov neeg uas ua cov tsim tau.
regards
Kuv tuaj los kuv tab tom nrhiav ib txoj kev los tsim ib lub polygon thiab kho nws tab sis nyob rau hauv Arcgis.
Ua ntej tshaj plaws ua tsaug rau tog tog Juancho rau lub macro thiab tseem ua rau tus txiv neej laus! rau kev nrhiav nws thiab tshaj tawm ... dab tsi yog txoj kev koom tes !!!!!
cov ntaub ntawv tsim nws hauv c:
qhov twg koj tsim cov ntaub ntawv dxf
yog tias nws ua haujlwm
WORKS HAUV CHAW UA HAUJ LWM 2007 PHEEJ KUV KUV TAWM YUAM KEV THIAB HAIS export mus rau ib tug nplaub tshev rau Cy tsis muaj dab tsi los tawm kuv tau ib lub qhov rais uas PERUTRAR THIAB TSIS QHIA KUV DAB TSI UA LI CAS SDE
Thov txim, Kuv tsis paub nws yuav zoo li cas
Ua tsaug rau koj cov lus teb ceev, Galvarezhn. Hmoov tsis nws tsis ua haujlwm.
qhov kev ua yuam kev saib ua ntej, nws zoo li rau kuv tias nws yuav yog vim lub cheeb tsam kev teeb tsa, tias lub separator ntau txhiab thiab kaum (semicolons) tau hloov pauv, tshawb xyuas ...
Nws zoo nkaus li nthuav, vim nws yog hauv online; Kuv mam li saib yog tias kuv rov tuaj xyuas dua ib hnub ntawm qhov no
tsaug rau cov info
Kuv nrhiav tau ib daim ntawv thov xa kev dawb rau kev hloov cov ntawv nyeem rau dxf
TEXT PASS X, Y, ZA DXF (TOPOGRAPHY)
http://www.konstruir.com/topografia/
tom qab teeb tsa theem kev ntseeg siab rau lub macro, daim ntawv khom nqi tseem tseem tuaj yeem tso saib ib qho lus yuam kev rau tus thib ob (PREVISUAL) tab.
Txawm hais tias kuv tseem yuav xa cov ntsiab lus rau dxf, Kuv xav kom siab pab cov functionality ntawm qhov kev pab cuam no zoo heev.
Pab kev zoo siab,
los tsa txoj kev ntseeg siab
koj mus rau lub pob excel, ib qho uas yog thawj zaug ntawm sab laug sab laug, thiab xaiv "excel xaiv" khawm,
ces xaiv "Trust Center"
thiab nyob ntawd koj xaiv "configure trust center"
ces xaiv "macro settings"
thiab nyob ntawd koj xaiv "pab kom tag nrho macros"
Qhov twg kuv teeb tsa kev ntseeg siab nyob rau hauv excel 2007
Kuv zoo siab rau koj thiab kuv qhia rau koj tias nws ua haujlwm zoo heev hauv ecxel 2007 tsuas yog hais tias koj yuav tsum configure tus exel nyob rau hauv txoj kev ntseeg siab thiab npaj txhij
OFICCE 2007 NROG TSIS MUAJ HAUJ LWM, yog tias pom tau MUAJ TEJ phenomenon uas tsim lub daim ntawv thov thiab kho tshiab. THANKS
mus rau qhov zoo, ces mus thiab hloov lub cheeb tsam kev teeb tsa rau koj lub tshuab
tsev / tswj vaj huam sib luag / cheeb tsam hauv cheeb tsam
tom qab ntawd xaiv koj lub teb chaws hauv cov kev xaiv hauv lub regional
muaj kom paub tseeb tias ntau txhiab tus cais tau tsim nrog lub cim "comma" thiab cov zauv nrog "dot"
ces koj nkag mus zoo thiab yuav tsum ua haujlwm
Nws ua haujlwm yam tsis muaj lej …… tab sis muaj ib lub sib xyaw yuav tsis muaj tseeb hauv lub dav hlau… .. npliag, koj qhia kuv li cas ???
Sim sau cov kev sib koom ua ke, uas yog tsis muaj decimals, kom pom tias nws tsis yog qhov teeb meem ntawm qhov kev teeb tsa lub regional (tias cov hnub caiv yog rau kev cais ntawm cov txhiab thiab cov cim taw qhia).
Kuv tabtom tawm ib qho yuam kev
Kuv ntaus sab qaum teb thiab cov no nrog cov quota tab sis nws tsis ua qhov kev saib ua ntej
muag yuam kev
Khiav-sijhawm; '1004,:
tsis tuaj yeem tau txais daim ntawv cuabyeej daim ntawv cuabyeej no ntawm lub hoob kawm hnyav
ces kuv yuav tsum khiav koj smoothly
zoo 2002
Puas yog nws ploj lawm?
Kuv tuaj los shaka, koj tuaj dab tsi zoo dua?
tus macro tsis ua hauj lwm rau kuv, koj pab tau kuv ???
qhov no yog tag nrho hauv kev kawm thiab tam sim no nug rau kev ruaj ntseg ntawm lub macro yog qhov tsawg kawg nkaus xws li g! Comments, nws tsis ua haujlwm !!!!! pabcuam meee
Nyob zoo Marcos, lub kaw lus tsim cov lus uas koj tsis tuaj yeem hloov kho cov kev hloov pauv, tab sis koj tuaj yeem lees txais lawv. Ntawd yog, koj tuaj yeem hloov lub npe ntawm cov ntaub ntawv thiab qhov loj ntawm cov ntawv nyeem, thiab thaum koj ua tiav nws, nws tsim qhov tshwm sim.
Yog tias koj muaj teeb meem ntau dua, tsis txhob hloov qhov loj ntawm cov ntawv nyeem lossis lub npe ntawm cov ntaub ntawv, nws tsis tsim nyog. Cov ntawv loj tuaj yeem hloov kho hauv autocad.
Kuv tuaj los, kuv sim siv qhov kev pab cuam no kom dhau tau ib qho kev txhim kho CAD ntxiv rau hauv kuv qhov kev zoo siab tsis pub kuv hloov ib qho ntawm cov khoom siv ntawm nplooj ntawv thib peb, qhov no tej zaum yuav yog vim? Ua tsaug ua ntej.
Michael: Macro tsis ua haujlwm nrog Excel 2007
Joaquin: Macros yuav tsum tau enabled, qhov no yog ua tiav hauv cov cuab yeej / macro / kev ruaj ntseg thiab pab kev ruaj ntseg ntawm ib qib qis.
koj daim ntawv excel zoo heev, tiam sis cov kev tshaj tawm uas cov ntawv khom nqi tsis ua hauj lwm yuav yog neeg xiam oob qhab uas kuv ua tau los ua kom lawv ua hauj lwm zoo
Nws yog ib qho chaw ua haujlwm zoo heev uas kuv tau siv nws ntev ntev tab sis kuv pom ib qho teeb meem loj:
Nws tsis ua haujlwm nrog 2007 qhov chaw ua haujlwm.
Kuv yuav zoo siab rau qhov kev daws qhov teeb meem no.
Kuv pom nws nthuav heev tshwj xeeb tshaj yog rau cov hauj lwm tsis loj heev Kuv mam sim pom tias cov ncuav muffins
Nyob zoo Jordi, Kuv ncaj ncees tsis tau sim nws hauv 2007 excel, kom pom tau tias ib tug neeg tau sim nws muaj thiab lees tias nws muab teeb meem
txais tos
galvrezhn, thawj, feliciarte tus sau koj twb ua nyob rau hauv no nkag teb chaws, thiab nyob rau lwm yam tes (yog li ntawd koj pom muaj ib tug addict ntxiv rau XYZ-DXF, hehe) xav tawm tswv yim, yog hais tias ib tug neeg, los yog koj tus kheej, tau tsis tau lub macro Excel 2007, 5 vim hais tias kuv yuav tsum tau siv nws-6 xyoo nyob rau hauv ua ntej lawm versions ntawm Excel, thiab tsis paub yog vim li cas, tab sis nws tsis khiav (kuv muaj macros enabled, thiab txhua yam uas).
txais tos