Yuav Hloov XML rau Excel (Nrog Duab)

Cov txheej txheem:

Yuav Hloov XML rau Excel (Nrog Duab)
Yuav Hloov XML rau Excel (Nrog Duab)

Video: Yuav Hloov XML rau Excel (Nrog Duab)

Video: Yuav Hloov XML rau Excel (Nrog Duab)
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Lub peb hlis ntuj
Anonim

Kab lus no yuav qhia koj yuav ua li cas import cov ntaub ntawv XML rau hauv Microsoft Excel phau ntawv siv lub Windows lossis Mac computer.

cov kauj ruam

Txoj Kev 1 ntawm 2: Windows

Hloov XML rau Excel Kauj Ruam 1
Hloov XML rau Excel Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel Koj tuaj yeem pom nws hauv "Microsoft Office" pab pawg hauv Txhua qhov chaw hauv "Windows" ntawv qhia zaub mov

Hloov XML rau Excel Kauj Ruam 2
Hloov XML rau Excel Kauj Ruam 2

Kauj Ruam 2. Nyem Cov Ntaub Ntawv nyob rau sab saud sab laug ntawm lub qhov rais

Hauv Excel 2007, nyem khawm puag ncig nrog lub logo Office

Hloov XML rau Excel Kauj Ruam 3
Hloov XML rau Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Qhib … kom qhib "File Explorer"

Hloov XML rau Excel Kauj Ruam 4
Hloov XML rau Excel Kauj Ruam 4

Kauj ruam 4. Nyem ob npaug rau ntawm XML cov ntaub ntawv

Nyob ntawm daim ntawv hom ntawv, yuav tsum muaj qee cov kauj ruam ntxiv.

  • Yog tias koj pom "Ntshuam XML" cov lus sib tham, cov ntaub ntawv hais txog tsawg kawg ib qho XSLT cov ntawv. nyem rau hauv Qhib cov ntawv yam tsis siv daim ntawv teev npe los xaiv lub neej ntawd hom, lossis hauv Qhib cov ntawv nrog cov ntawv teev tseg hauv qab no los ua cov ntaub ntawv raws li cov ntawv style.
  • Yog tias koj pom "Qhib XML" kev sib tham, xaiv Raws li phau ntawv nyeem nkaus xwb.
Hloov XML rau Excel Kauj Ruam 5
Hloov XML rau Excel Kauj Ruam 5

Kauj Ruam 5. Nyem rau ntawm File menu menu item

Hloov XML rau Excel Kauj Ruam 6
Hloov XML rau Excel Kauj Ruam 6

Kauj Ruam 6. Nyem Txuag Raws Li…

Hloov XML rau Excel Kauj Ruam 7
Hloov XML rau Excel Kauj Ruam 7

Kauj Ruam 7. Nkag mus nruab nrab ntawm cov ntawv uas koj xav khaws cov ntawv

Hloov XML rau Excel Kauj Ruam 8
Hloov XML rau Excel Kauj Ruam 8

Kauj Ruam 8. Xaiv Excel Workbook los ntawm "Txuag raws li hom" cov ntawv qhia zaub mov nco-down

Hloov XML rau Excel Kauj Ruam 9
Hloov XML rau Excel Kauj Ruam 9

Kauj Ruam 9. Nyem Txuag

Tom qab ntawd cov ntaub ntawv XML yuav raug khaws tseg rau hauv Excel cov ntaub ntawv.

Method 2 ntawm 2: Mac OS

Kauj Ruam 1. Qhib Microsoft Excel Koj tuaj yeem pom nws hauv "Applications" folder

Excel rau macOS tsis ntshuam XML cov ntaub ntawv los ntawm lwm qhov chaw, tab sis nws tso cai qhib XML cov ntawv nthuav tawm

Kauj Ruam 2. Nyem rau ntawm File menu nyob rau sab saum toj ntawm lub vijtsam

Kauj Ruam 3. Nyem Qhib

Tom qab ntawd lub qhov rai "Finder" yuav qhib.

Kauj Ruam 4. Xaiv cov ntawv XML

Txhawm rau ua qhov no, mus rau lub nplaub tshev uas cov ntaub ntawv tau txais kev cawmdim thiab nyem rau ntawm nws.

Kauj Ruam 5. Nyem OK

Tam sim no koj yuav pom cov ntsiab lus ntawm cov ntaub ntawv XML.

Kauj Ruam 6. Nyem rau ntawm File menu

Kauj Ruam 7. Nyem Txuag Li

Kauj Ruam 8. Sau lub npe rau daim ntawv

Kauj Ruam 9. Xaiv CSV los ntawm cov "File Type" drop-down menu

Kauj ruam 10. Nyem Txuag

Tom qab ntawd cov ntaub ntawv XML yuav raug khaws tseg ua CSV ntawm Mac.

Pom zoo: