Hloov XML Cov Ntaub Ntawv rau Excel Cov Qauv

XML yog ib hom kev tshaj tawm rau khaws cia thiab sib qhia cov ntaub ntawv sib txawv ntawm cov ntawv thov. Microsoft Excel ua hauj lwm nrog cov ntaub ntawv, yog li qhov teeb meem ntawm kev hloov ntaub ntawv los ntawm cov qauv XML rau Excel tawm tswv yim zoo heev. Tshawb xyuas seb yuav ua li cas ua txoj haujlwm no rau ntau txoj hau kev.

Kev hloov dua tshiab

XML cov ntaub ntawv raug sau ua lus tshwj xeeb rau cov cim lus nrog ib yam dab tsi zoo li HTML cov nplooj ntawv web. Vim li no, cov kev tawm tswv yim no muaj cov qauv zoo sib xws. Tib lub sij hawm, Excel yog, thawj zaug ntawm tag nrho cov, ib qhov kev zov me nyuam uas muaj ntau hom "hom ntawv". Cov npe nrov tshaj plaws yog: Workbookbook (XLSX) thiab Excel Workbook 97 - 2003 (XLS). Cia peb nrhiav kom paub txog txoj hauv kev los hloov cov ntaub ntawv XML rau hauv cov hom ntawv no.

Method 1: Excel built-in functionality

Excel ua haujlwm zoo nrog cov ntaub ntawv XML. Nws tuaj yeem qhib lawv, hloov, tsim, txuag tau. Yog li, qhov nyuaj ntawm cov neeg ua hauj lwm ua ntej peb yog qhib qhov khoom no thiab txuag nws ntawm daim ntawv thov hauv daim ntawv ntawm XLSX lossis XLS cov ntaub ntawv.

1. Tua tawm Excel. Hauv tab "Cov Ntaub Ntawv" mus rau yam khoom ntawd "Qhib".



2. Lub qhov rais qhib rau cov ntaub ntawv qhib yog qhib. Mus rau qhov chaw nyob hauv daim ntawv XML uas peb xav tau khaws, xaiv nws thiab nyem rau ntawm lub pob "Qhib".



3. Tom qab cov ntaub ntawv qhib los ntawm Excel interface, rov mus rau lub tab "Cov Ntaub Ntawv".



4. Mus rau ntawm no tab, nyem qhov khoom "Txuag Raws Li ...".



5. Lub qhov rais qhib uas zoo li lub qhov rais qhib, tab sis nrog qee qhov sib txawv. Tam sim no peb xav kom txuag tau cov ntaub ntawv. Siv cov cuab yeej navigation, mus rau ntawm qhov chaw uas cov ntawv pov thawj hloov tshiab yuav muab khaws cia. Txawm hais tias koj tuaj yeem tawm hauv nws daim nplaub tshev tam sim no. Hauv teb "Filename" yog tias koj xav tau, koj tuaj yeem hloov npe rau nws, tab sis qhov no kuj tsis tsim nyog. Lub ntsiab ntawm peb txoj hauj lwm yog cov nram qab no: "Cov Ntaub Ntawv Siv". Nias ntawm daim teb no.

   

   Los ntawm cov lus xaiv, xaiv lub Excel workbook lossis Excel workbook 97-2003. Thawj tus yog newer, tus thib ob yog ib qho me ntsis outdated.



6. Tom qab xaiv ua, nyem rau ntawm lub pob. "Txuag".

Qhov no ua tiav cov txheej txheem rau kev hloov cov ntaub ntawv XML rau Excel hom los ntawm qhov kev pab cuam interface.

Txoj kev 2: Import Cov Ntaub Ntawv

Cov qauv saum toj no tsuas yog tsim rau XML cov ntaub ntawv nrog cov qauv nyuaj. Ntau cov rooj ntxhuav thaum hloov dua siab tshiab hauv txoj kev no yuav raug txhais tsis raug. Tab sis, yog muaj lwm qhov built-in Excel uas yuav pab koj yog cov ntaub ntawv xa cov ntaub ntawv. Nws nyob hauv "Tus tsim tawm tshuab raj"uas yog neeg xiam oob qhab los ntawm lub neej. Yog li ntawd, ua ntej ntawm tag nrho cov, nws yuav tsum tau qhib kom ua.

1. Mus rau lub tab "Cov Ntaub Ntawv", nyem rau ntawm yam khoom "Kev xaiv".



2. Nyob rau hauv lub qhov tsis cov qhov rai mus rau qhov subsection Ribbon teeb. Nyob rau sab xis ntawm lub qhov rais, khij lub npov "Tsim tawm". Peb nias lub khawm "OK". Tam sim no qhov kev ua num tsim nyog yog qhib kom ua, thiab cov kev sib raug zoo tau tshwm sim rau daim kab xev.



3. Mus rau lub tab "Tsim tawm". Rau daim kab xev hauv lub nras cov cuab yeej "XML" nias lub khawm "Ntshuam".



4. Lub qhov ntshaus ntshiab qhib opens. Mus rau ntawm cov ntaub ntawv qhov chaw uas xav tau. Xaiv nws thiab nyem rau ntawm lub pob. "Ntshuam".



5. Lub thawv ntawv qhib ces qhib tau, uas hais tias cov ntaub ntawv uas xaiv tau tsis xa mus rau lub schema. Nws yuav tsum muaj los tsim ib qho kev pab rau qhov kev zov me nyuam nws tus kheej. Hauv qhov no, pom zoo thiab nyem rau ntawm lub pob "OK".



6. Tom ntej no, tom qab qhib lub thawv qhib tham. Nws npaj siab los txiav txim siab qhib lub rooj hauv phau ntawv tam sim no los yog hauv ib lub tshiab. Vim peb pib qhov kev pab cuam yam tsis tau qhib cov ntaub ntawv, peb tuaj yeem tawm ntawm qhov chaw no thiab tseem ua hauj lwm nrog phau ntawv tam sim no. Tsis tas li ntawd, tib lub qhov rais tuaj yeem los txiav txim siab txog cov hauj lwm nyob rau hauv daim ntawv uas lub rooj yuav xa tawm. Koj tuaj yeem nkag mus rau qhov chaw nyob ntawm koj tus kheej, tab sis nws yooj yim dua thiab yooj yim dua rau koj nias ntawm ib lub xovtooj ntawm daim ntawv uas yuav ua rau sab saum toj ntawm lub rooj. Tom qab qhov chaw nyob nkag rau hauv lub thawv dialog, nias ntawm lub pob "OK".



7. Tom qab cov kauj ruam no, cov lus XML yuav muab tso rau hauv qhov kev pab cuam qhov rai. Yuav kom txuag tau cov ntaub ntawv hauv Excel hom, nias ntawm daim duab nyob rau hauv daim ntawv ntawm lub tshuab floppy nyob rau sab qaum sab laug ntawm lub qhov rais.



8. Ib qho kev txuag lub qhov rais qhib rau hauv qhov koj xav tau los txiav txim seb cov npe qhov twg yuav khaws cia. Cov ntaub ntawv hom ntawv no lub sij hawm no yuav tau ua ntej-XLSX, tab sis yog tias koj xav, koj tuaj yeem qhib rau daim teb "Cov Ntaub Ntawv Siv" thiab nruab dua lwm hom XL-XLS. Tom qab txuag cov teeb tsa raug teev, tab sis nyob rau hauv cov ntaub ntawv no lawv tuaj yeem sab laug vim yog, nyem rau ntawm lub pob "Txuag".

Yog li, qhov kev hloov dua siab tshiab nyob rau hauv txoj kev yog rau peb yuav ua tiav nrog cov ntaub ntawv tshaj tawm tseeb.

Txoj kev 3: Online Converter

Cov neeg siv vim qee yam tsis muaj lub Excel program tso rau hauv lawv lub computer, tiam sis yuav tsum tau hloov kho cov ntaub ntawv los ntawm XML hom rau EXCEL siv tau ib qho ntawm ntau qhov kev pabcuam hauv online rau kev hloov dua siab tshiab. Ib qho ntawm feem ntau yooj yim qhov chaw ntawm no hom yog Convertio.

Online Converter Hloov tshiab

1. Mus saib xyuas qhov Web site no siv txhua qhov browser. Rau nws, koj tuaj yeem xaiv 5 txoj kev mus download tau ib daim ntawv thov convertible:
   • Ntawm qhov nyuaj disk ntawm lub computer;
   • Los ntawm Dropbox online cia;
   • Los ntawm Google Drive hauv online cia;
   • Nyob hauv qhov txuas hauv Internet.

   Txij li thaum nyob rau hauv peb cov ntaub ntawv daim ntawv tso rau hauv PC, ces nias lub khawm "Los ntawm lub computer".



2. Lub qhov rais qhib ib daim ntawv yog pib. Mus rau ntawm qhov chaw nws nyob. Nyem ntawm cov ntaub ntawv thiab nyem rau ntawm lub pob. "Qhib".

   

   Kuj tseem muaj lwm txoj hau kev xaiv ntxiv cov ntaub ntawv rau qhov kev pabcuam. Ua li no, cia li rub tus nas tawm ntawm Windows Explorer.

3. Raws li koj tau pom, cov ntaub ntawv ntxiv rau qhov kev pab thiab nyob hauv lub xeev "Npaj". Tam sim no peb yuav tsum xaiv lub hom phiaj peb xav tau rau kev hloov dua siab tshiab. Nyem ntawm lub qhov rais ntawm tsab ntawv ntawm ib sab "Hauv". Ib daim ntawv teev cov npe pawg opens. Xaiv "Cov ntaub ntawv". Tom ntej no, ib daim ntawv teev hom tawm qhib. Xaiv "XLS" los yog "XLSX".



4. Tom qab lub npe ntawm qhov Desired Extensions ntxiv rau lub qhov rais, nyem rau ntawm lub pob liab liab loj "Hloov siab". Tom qab ntawd, cov ntaub ntawv yuav raug hloov dua siab tshiab thiab muaj rau download ntawm qhov chaw no.

Qhov kev xaiv no tuaj yeem ua haujlwm kom muaj kev ruaj ntseg zoo dua yog tias tsis muaj kev siv cov cuab yeej kho dua tshiab nyob hauv cheeb tsam no.

Raws li koj tau pom, hauv Excel nws tus kheej muaj cov cuab yeej built-in uas tso cai rau koj los hloov cov ntaub ntawv XML rau hauv ib qho ntawm "homphiaj" ntawm qhov kev qhia no. Qhov yooj yim tshaj plaws tau yooj yim dua los ntawm cov niaj hnub "Txuag Raws Li ..." muaj nuj nqi. Rau cov ntaub ntawv uas muaj ntau txoj hauv kev, nws muaj ib txoj kev hloov dua tshiab los ntawm kev tuaj yeem. Cov neeg siv vim qee yam tsis tuaj yeem siv cov cuab yeej no muaj lub sijhawm los ua txoj hauj lwm uas siv cov kev pab tshwj xeeb hauv online rau cov ntaub ntawv hloov dua siab tshiab.