Yuav Ua Li Cas Txhais Cov Xml Kom Zoo

Cov txheej txheem:

Yuav Ua Li Cas Txhais Cov Xml Kom Zoo
Yuav Ua Li Cas Txhais Cov Xml Kom Zoo

Video: Yuav Ua Li Cas Txhais Cov Xml Kom Zoo

Video: Yuav Ua Li Cas Txhais Cov Xml Kom Zoo
Video: qhia txog kev ua neeg zoo yog ua li ca 2024, Plaub Hlis Ntuj
Anonim

XML yog suav hais tias yog ib tus qauv nrov tshaj plaws rau kev teeb tsa, khaws cov ntaub ntawv thiab hloov nws ntawm kev siv ntau yam. Excel ua haujlwm nrog cov ntaub ntawv no. Qhov no yog vim li cas hloov XML rau Excel yog qhov teeb meem tseem ceeb heev. Muaj ntau txoj kev xaiv los ua txoj haujlwm no.

Yuav ua li cas txhais cov xml kom zoo
Yuav ua li cas txhais cov xml kom zoo

XML yog suav hais tias yog ib tus qauv nrov tshaj plaws rau kev teeb tsa, khaws cov ntaub ntawv thiab hloov nws ntawm kev siv ntau yam. Excel ua haujlwm nrog cov ntaub ntawv no. Qhov no yog vim li cas hloov XML rau Excel yog qhov teeb meem tseem ceeb heev. Muaj ntau txoj kev xaiv los ua txoj haujlwm no.

Kev siv built-in Microsoft Excel functions

1. Pib Microsoft Excel.

2. Hauv seem "Cov Ntaub Ntawv" mus rau "Qhib" tab.

3. Hauv qhov rai uas qhib, nrhiav thiab xaiv XML ntawv uas yuav tsum muaj rau kev ua haujlwm.

4. Nyem rau "Qhib" khawm (hauv qab sab xis ntawm lub qhov rais).

5. Tom qab cov ntawv qhib tau qhib dua qhib "Cov Ntaub Ntawv" tab.

6. Khoom "Txuag raws li …".

7. Hauv seem uas qhib, xaiv qhov chaw rau khaws cov ntaub ntawv hloov pauv. Yog tias tsim nyog, koj tuaj yeem hloov lub npe ntawm cov ntawv (daim ntawv "File Name").

8. Nyem rau ntawm "Cov ntaub ntawv hom" teb thiab xaiv ib qho ntawm cov kev tshwm sim los cawm cov ntawv:

- Excel 97-2003 phau ntawv ua haujlwm;

- Excel phau ntawv ua haujlwm nrog kev txhawb nqa rau macros;

- lossis Excel Workbook).

9. Nyem rau ntawm "Txuag" yam khoom.

Ntshuam ntawm xml cov ntaub ntawv (tsuas yog rau cov ntaub ntawv nrog cov qauv yooj yim)

1. Pib Excel.

2. Qhib ntu "Cov Ntawv".

3. Ua kom ntu "ntu".

4. Nyob rau hauv lub qhov rai uas tshwm, mus rau "Ribbon nqis" tab, qhov twg nyem rau ntawm "OK".

5. Nyem rau ntawm "Tus tsim tawm" ntu.

6. Nyob rau txoj hlua khawm hauv lub cuab yeej, nyem rau ntawm "Ntshuam" khoom.

7. Nrhiav cov ntaub ntawv xav tau. Hauv qab txoj cai ces kaum, nyem khawm "Ntshuam".

8. Hauv kev qhib lub thawv qhib, hais kom muab los tsim ib qho Excel, nyem rau khawm "OK".

9. Xaiv lub cell ntawm daim ntawv, thiab hauv "Cov Ntawv Ntshuam" Lub thawv uas tshwm sim, nyem rau ntawm "OK". XML qhov rooj yuav tshwm rau ntawm lub qhov rai program. Txuag daim ntawv, nyem rau ntawm cov floppy disk icon nyob rau sab saud lawm ntawm kaum pob khoom.

10. Hauv "Txuag daim ntawv" qhov rai uas qhib, nyem rau ntawm "Txuag" khawm.

Hloov daim ntawv XML thaum Microsoft Excel tsis raug ntsia rau hauv lub computer Microsoft Excel

Hauv qhov no, nws raug nquahu kom siv cov khoom muaj txiaj ntsig rau kev hloov cov ntaub ntawv XML los ua kom zoo. Ib qho ntawm cov kev pabcuam nrov dua yog kev pub dawb hauv online Convertio.

1. Siv cov browser, mus rau Convertio lub vev xaib.

2. Xaiv ib txoj hauv kev los rub tawm cov ntawv:

- los ntawm disc siab phem;

- los ntawm kev khaws Dropbox lossis Google Drive;

- los ntawm qhov txuas los ntawm Is Taws Nem.

3. Yog cov ntaub ntawv khaws tseg rau hauv lub koos pij tawj, xaiv cov khoom "Los ntawm lub khoos phis tawm".

4. Nyob rau hauv lub qhov rai uas tshwm, pom cov ntawv xav tau, xaiv nws, nyem rau ntawm "Qhib" khawm (lossis rub nws nrog nas los ntawm Explorer).

5. Tom qab paub tseeb tias daim ntawv tau tshwm sim ntawm cov khoom siv (thaum nws nyob hauv "Npaj" hauv lub xeev), koj yuav tsum txiav txim siab hom ntawv hloov dua siab tshiab. Nyem rau sab laug nas khawm ntawm lub qhov rais ze ntawm "B" cim.

6. Hauv cov npe uas tshwm sim, nyem rau ntawm "Ntawv" khawm.

7. Nyem "Next".

8. Txiav txim siab rau hom ntawv ("XLS" lossis "XLSX").

9. Tom qab ua kom paub tseeb tias txuas ntxiv tau ntxiv rau lub qhov rai hloov, nyem rau ntawm "Hloov" cov khoom.

Nov yog peb txoj hauv kev yooj yim los txhais cov lus xml rau hauv kom zoo.

Pom zoo: