Yuav ua li cas ntshuam X, Y, Z Ua Haujlwm los ntawm Excel rau AutoCAD (Hauv Tsuas 10 Kauj Ruam)

Cov txheej txheem:

Yuav ua li cas ntshuam X, Y, Z Ua Haujlwm los ntawm Excel rau AutoCAD (Hauv Tsuas 10 Kauj Ruam)
Yuav ua li cas ntshuam X, Y, Z Ua Haujlwm los ntawm Excel rau AutoCAD (Hauv Tsuas 10 Kauj Ruam)

Video: Yuav ua li cas ntshuam X, Y, Z Ua Haujlwm los ntawm Excel rau AutoCAD (Hauv Tsuas 10 Kauj Ruam)

Video: Yuav ua li cas ntshuam X, Y, Z Ua Haujlwm los ntawm Excel rau AutoCAD (Hauv Tsuas 10 Kauj Ruam)
Video: Qhia yam ntxwv qua tsev Zoo thiab kev zas kob li cas thiaj raug looj mem || Loojmem Tsevyaj EP6 2024, Plaub Hlis Ntuj
Anonim

Koj puas muaj cov ntsiab lus hauv cov ntaub ntawv Excel uas koj xav tau xa mus rau AutoCAD? Qhov wikiHow yuav qhia koj yuav ua li cas ntshuam X, Y, Z los ntawm Excel rau AutoCAD siv cov ntawv sau. Ua ntej, koj yuav xav tau daim ntawv Excel daim ntawv nthuav qhia.

Cov kauj ruam

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 1
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 1

Kauj Ruam 1. Qhib koj qhov haujlwm hauv Excel

Koj tuaj yeem qhib qhov haujlwm los ntawm Start menu hauv Windows lossis hauv Applications hauv Finder ntawm Mac; ces nyem File> Qhib. Koj tseem tuaj yeem qhib koj cov ntaub ntawv los ntawm koj tus thawj tswj ntaub ntawv los ntawm txoj cai-nyem nws thiab xaiv Qhib nrog> Excel.

Koj yuav tsim cov ntawv sau los ntawm cov ntaub ntawv Excel

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 2
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 2

Kauj ruam 2. Xaiv thiab luam koj cov ntaub ntawv

Tsuas yog nyem los xaiv thawj lub xov tooj ntawm tes nrog cov ntaub ntawv thiab rub thiab tso koj tus cursor mus rau lub cell kawg uas muaj cov ntaub ntawv. Yuav luam, nias Ctrl + C. (Windows) lub Cmd + C. (Mac OS).

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 3
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 3

Kauj Ruam 3. Muab cov ntawv theej theej rau hauv Notepad lossis TextEdit file

Koj yuav pom Notepad hauv Start menu ntawm Windows thiab TextEdit hauv Cov Ntawv Thov nplaub tshev hauv Finder rau Mac.

Txhawm rau muab tshuaj txhuam, nias Ctrl + V. (Windows) lub Cmd + V. (Mac OS). Cov ntaub ntawv yuav tshwm nyob rau hauv koj cov ntawv ua ke nrog rau qhov chaw kom zoo li lub hauv paus qub.

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 4
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 4

Kauj Ruam 4. Siv "Nrhiav thiab Hloov" cov cuab yeej kom tshem tau cov chaw

Xaiv (luag thiab poob) qhov chaw, tom qab ntawd mus rau Kho kom raug> Hloov tom qab ntawd koj yuav tsum pom qhov chaw nyob hauv kab ntawv "Nrhiav dab tsi" (Mac cov neeg siv yuav xav tau xaiv "Siv xaiv rau Nrhiav"). Sau tus lej cim hauv "Hloov nrog" daim teb thiab nyem Hloov Txhua.

Thaum koj hloov tag nrho cov cim, koj yuav pom koj cov ntaub ntawv teeb tsa yam tsis muaj qhov chaw, tab sis hloov nrog tus lej

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 5
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 5

Kauj Ruam 5. Ntxiv "_MULTIPLE _POINT" rau saum cov npe

AutoCAD lees paub lub cim cim ua cim raws li cov lus txib thiab qhov chaw thaum nkag mus, yog li nws yuav khiav "MULTIPLE" thiab "POINT" cov lus txib cais.

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 6
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 6

Kauj Ruam 6. Txuag cov ntawv ua SCR cov ntaub ntawv

Mus rau File> Txuag As tom qab ntawd hloov qhov "Txuag raws li hom" nco-down thiab xaiv "Txhua Cov Ntaub Ntawv." Rau Mac, tuav lub Xaiv qhov tseem ceeb thaum koj nyem Cov ntaub ntawv kom tau txais "Txuag As."

Npe lub npe ntawv ntxiv ".scr" mus rau qhov kawg thiab nyem rau Txuag.

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 7
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 7

Kauj Ruam 7. Qhib AutoCAD

Koj tuaj yeem tso tawm daim ntawv thov no los ntawm koj li Start menu hauv Windows lossis Daim Ntawv Thov nplaub tshev hauv Finder ntawm Mac.

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 8
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 8

Kauj Ruam 8. Ntaus "SCR" thiab nias Enter los yog Rov qab los.

Koj yuav pom SCRIPT cov lus txib tshwm sim saum cov kab hais kom ua hauv qab ntawm koj lub vijtsam thaum koj ntaus thiab koj tus thawj tswj ntaub ntawv yuav qhib thaum koj nias lub pob Nkag mus/Rov Qab tus yuam sij

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 9
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 9

Kauj ruam 9. Nkag mus rau thiab nyem ob zaug koj cov ntaub ntawv SCR

Thaum koj nyem ob zaug los xaiv nws, AutoCAD yuav nyeem cov lus txib ntawm thawj kab ntawm daim ntawv thiab cia li ntshuam X, Y, Z cov haujlwm.

Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 10
Ntshuam Xyz Ua Haujlwm los ntawm Excel rau AutoCAD Kauj Ruam 10

Kauj Ruam 10. Nias Esc thiab ob-nias koj tus nas hauv thaj chaw kos duab

Nias Esc kaw qhov lus txib kawg (uas yog POINT hais kom ua) thiab ob-nias yuav nthuav tawm kom koj tuaj yeem pom txhua qhov kev sib koom tes uas koj tau txais.

Pom zoo: