Hloov XML rau XLS


Kev teev cov ntaub ntawv yog feem faib ntawm Microsoft Office tawm tswv yim - XLS thiab XLSX. Txawm li cas los xij, qee qhov teeb meem hauv cov ntaub ntawv hauv daim ntawv XML nplooj ntawv. Qhov no tsis yog ib txwm yooj yim, thiab ntau cov ntxhuav Excel mas ze dua thiab paub zoo dua. Txhawm rau tshem ntawm inconvenience, cov lus ceeb toom los yog cov khoom yuav raug hloov los ntawm XML rau XLS. Yuav ua li cas - nyeem hauv qab no.

Hloov XML rau XLS

Nws yog tsim nyog sau cia tias kev hloov cov ntaub ntawv no rau hauv Excel lub rooj tsis yog ib qho yooj yim ua hauj lwm: cov qauv no txawv dhau. XML nplooj ntawv yog cov ntawv nyeem raws li cov syntax ntawm cov lus, thiab XLS lub rooj yog yuav luag ib daim ntawv teev npe tag nrho. Txawm li cas los xij, nrog kev pabcuam tshwjxeeb losyog khoom siv ua haujlwm, qhov kev hloov dua siab tshiab ua tau.

Method 1: Advanced XML Converter

Yooj yim rau kev tswj cov khoom siv sib hloov. Muab faib rau cov nqi, tiam sis muaj ib qho kev sib tw sim. Muaj ib hom lus Lavxias.

Download tau Advanced XML Converter

  1. Qhib lub program, ces siv "Cov Ntaub Ntawv"-"Saib XML".
  2. Nyob rau hauv lub qhov rais "Explorer" mus rau cov directory nrog cov ntaub ntawv koj xav hloov, xaiv nws thiab nyem "Qhib".
  3. Thaum sau daim ntawv no, siv cov zaub mov dua. "Cov Ntaub Ntawv", xaiv lub sijhawm no "Export table ...".
  4. Interface conversion chaw yuav tshwm. Hauv kev nqis zaub mov "Hom" xaiv yam khoom "xls".

    Tom qab ntawd, xa mus rau qhov chaw nyob ntawm qhov interface no, los yog tawm txhua yam raws li nws thiab nias "Hloov siab".
  5. Thaum kawg ntawm kev hloov txheej txheem, cov ntaub ntawv tiav yuav raug qhib rau hauv ib qho kev pab tsim (piv txwv, Microsoft Excel).

    Them rau lub xub ntiag ntawm daim ntawv sau npe ntawm qhov demo version.

Qhov kev pab cuam tsis zoo, tab sis cov kev txwv ntawm lub demo version thiab cov teeb meem ntawm kev yuav tag nrho version yuav ua rau ntau mus nrhiav lwm cov kua.

Txoj kev 2: XML Converter yooj yim

Ib ntsis ntau tshaj version ntawm qhov kev pab cuam rau hloov XML nplooj ntawv hauv XLS cov rooj. Kuj yog ib qho nyiaj them, tus Lavxias teb sab yog ploj lawm.

Download tau software XML Converter yooj yim

  1. Qhib daim ntawv thov. Hauv ib sab ntawm lub qhov rais, nrhiav lub pob "Tshiab" thiab nias nws.
  2. Lub interface yuav qhib. "Explorer"qhov twg koj yuav tsum xaiv qhov chaw ua ntaub ntawv thov. Mus rau hauv daim nplaub tshev nrog koj daim ntawv, xaiv nws thiab qhib nws los ntawm txhaj rau qhov khawm tsim nyog.
  3. Lub cuab yeej hloov dua tshiab yuav pib. Ua ntej tshaj plaws, xyuas seb lub checkboxes kos rau ntawm cov ntawv ntawm daim ntawv koj xav hloov, thiab mam li nyem rau ntawm lub pob nyem liab "Hloov tshiab" hauv qab laug.
  4. Cov kauj ruam tom ntej yog ntsuam xyuas cov ntaub ntawv tawm cov ntawv tawm: hauv qab ntawm nqe lus "Cov ntaub ntawv tawm zis", yuav tsum tau kuaj xyuas "Excel".

    Tom qab ntawd nco ntsoov nias ntawm khawm. "Tej chaw"nyob ze.

    Hauv khij qhov me me lub thawv "Excel 2003 (* xls)"ces nias "OK".
  5. Rov qab mus rau qhov kev hloov dua siab tshiab, nias lub khawm. "Hloov siab".

    Qhov kev zov me nyuam hais kom koj xaiv ib phau ntawv thiab lub npe ntawm daim ntawv hloov tshiab. Ua qhov no thiab nias. "Txuag".
  6. Ua tiav - cov ntaub ntawv hloov tshiab yuav tshwm nyob rau hauv cov ntawv nplais.

Qhov kev pab cuam no twb muaj cumbersome thiab tsawg tus phooj ywg rau cov neeg tshiab. Nws qhia raws nraim tib lub functionality li cov converter hais nyob rau hauv txoj kev 1 nrog raws nraim tib yam kev txwv, txawm tias yooj yim XML Converter muaj ntau interface tshiab.

Txoj kev 3: LibreOffice

Qhov nrov dawb office suite LibreOffice muaj xws li ntawv tshaj tawm software, LibreOffice Calc, uas yuav pab peb daws cov haujlwm tshiab.

  1. Qhib LibreOffice Calc. Siv cov ntawv qhia zaub mov "Cov Ntaub Ntawv"ces "Qhib ...".
  2. Nyob rau hauv lub qhov rais "Explorer" mus rau lub nplaub tshev nrog koj cov ntaub ntawv xml. Xaiv nws nrog ib qho nias thiab nias. "Qhib".
  3. Lub voj voos teb yuav tshwm sim.

    Alas, qhov no yog qhov tseem ceeb tshaj plaws hauv kev hloov ua siv LibreOffice Calc: cov ntaub ntawv los ntawm cov ntawv XML yog txawv tshwj xeeb hauv cov ntawv nyeem thiab xav tau kev ua ntxiv. Nyob rau hauv lub qhov rais qhia hauv lub screenshot, hloov cov kev hloov koj xav tau, ces nias "OK".
  4. Cov ntaub ntawv yuav qhib rau hauv thaj chaw ua haujlwm ntawm qhov kev zov me nyuam qhov rais.

    Rov qab siv dua "Cov Ntaub Ntawv", twb xaiv ib yam khoom "Txuag Raws Li ...".
  5. Nyob rau hauv cov ntaub ntawv txuag interface nyob rau hauv daim ntawv teev npe-down-down "Cov Ntaub Ntawv Siv" teeb "Microsoft Excel 97-2003 (* .xls) ".

    Mam li hloov cov ntaub ntawv raws li kev xav thiab nias "Txuag".
  6. Ib qho kev ceeb toom txog cov qauv tsis raug cai yuav tshwm sim. Nias "Siv Microsoft Excel 97-2003 hom".
  7. Ib tug version nyob rau hauv XLS hom yuav tshwm nyob rau hauv daim nplaub tshev ntawm tus thawj cov ntaub ntawv, npaj txhij rau ntxiv manipulation.

Ntxiv nrog rau cov ntawv nyeem ntawm cov kev hloov, hom no muaj suab tsis muaj teeb meem - tej zaum nrog cov nplooj ntawv loj nrog cov lus sib txawv syntax siv xaiv tej zaum muaj teeb meem.

Txoj kev 4: Microsoft Excel

Qhov feem ntau zoo-paub ntawm cov kev pab rau kev ua hauj lwm nrog cov ntaub ntawv tabular, Excel los ntawm Microsoft (versions 2007 thiab newer), kuj muaj lub functionality los daws qhov teeb meem ntawm hloov XML rau XLS.

  1. Qhib Excel. Xaiv "Qhib lwm cov ntawv".

    Tom qab ntawd, lawv cov - "Khoos phib tawj" thiab "Xauj".
  2. Hauv "Explorer" mus rau qhov chaw ntawm daim ntawv rau kev hloov dua siab tshiab. Tshav nws thiab nias "Qhib".
  3. Hauv cov qhov tso saib me me, ua tib zoo nco ntsoov tias qhov khoom ntawd ua haujlwm. XML Cov Lus thiab nias "OK".
  4. Thaum cov nplooj ntawv qhib hauv kev tshawb xyuas Microsoft Microsoft, siv cov tab "Cov Ntaub Ntawv".

    Nyob rau hauv nws, xaiv "Txuag Raws Li ..."ces khoom "Txheeb xyuas"nyob rau hauv uas nrhiav tus nplaub tshev tsim rau txuag.
  5. Nyob rau hauv lub npe sau interface "Cov Ntaub Ntawv Siv" xaiv "Excel 97-2003 workbook (* .xls)".

    Mam li hloov cov ntaub ntawv yog tias koj xav tau, thiab nias "Txuag".
  6. Ua li cas - daim ntawv qhib hauv lub chaw ua haujlwm yuav tau txais hom ntawv XLS, thiab cov ntaub ntawv xwb yuav tshwm nyob rau hauv cov phau ntawv xaiv yav dhau los, npaj rau kev ua ntxiv.

Excel muaj tsuas yog ib qho tsis muaj teeb meem - nws muab faib raws li ib feem ntawm Microsoft Office pob rau ib qhov nqi.

Nyeem ntxiv: Hloov cov ntaub ntawv XML rau Excel Cov Qauv

Ua kom tiav, peb nco ntsoov tias qhov ua kom tiav ntawm XML cov nplooj ntawv hauv XLS cov qauv tsis yog vim tsis yog vim qhov sib txawv ntawm cov qauv. Txhua yam ntawm cov kev daws teeb meem no yuav yog nyob rau qee txoj kev. Txawm tias cov kev pab hauv online yuav tsis pab - txawm tias nws yooj yim, cov kev daws teeb meem no feem ntau tseem phem dua li ib tug neeg software.