Sinthani mafayilo a XML kukhala mitundu ya Excel

XML ndi imodzi mwanjira zomwe zimasungidwa kwambiri posungira deta ndikusinthana pakati pa mapulogalamu osiyanasiyana. Pulogalamu ya Microsoft Excel imagwiranso ntchito ndi deta, ndiye kuti nkhani yosintha mafayilo kuchokera ku mawonekedwe a XML kukhala mawonekedwe a Excel ndi yofunikira kwambiri. Tiona momwe tingachitire njirazi m'njira zosiyanasiyana.

Njira yotembenuza

Mafayilo a XML adalembedwa mchilankhulo chapadera chofanana ndi HTML yamasamba. Chifukwa chake, mawonekedwe awa ali ndi mawonekedwe ofanana. Nthawi yomweyo, Excel makamaka ndi pulogalamu yomwe ili ndi mitundu "yazikhalidwe" zingapo. Odziwika kwambiri a iwo ndi awa: Excel Book (XLSX) ndi Excel Book 97 - 2003 (XLS). Tiyeni tiwone njira zazikulu zosinthira mafayilo a XML kukhala amtunduwu.

Njira 1: magwiridwe antchito a Excel

Excel imagwira ntchito bwino ndi mafayilo a XML. Amatha kutsegula, kusintha, kupanga, kupulumutsa. Chifukwa chake, chosavuta chosankha chantchito yathu ndikutsegula chinthuchi ndikusunga kudzera mu mawonekedwe a pulogalamuyo mu mawonekedwe a XLSX kapena XLS.

1. Timayamba Excel. Pa tabu Fayilo pitani kuloza "Tsegulani".



2. Zenera lotsegula zikalata limagwira. Timapita kumalo osungira komwe XML yomwe timasungira imasungidwa, sankhani ndikudina batani "Tsegulani".



3. Chikalatacho chikutsegulidwa kudzera pa mawonekedwe a Excel, pitani ku tabu Fayilo.



4. Kupita ku tabu ili, dinani chinthucho. "Sungani Monga ...".



5. A zenera limatseguka lomwe limawoneka ngati zenera kutseguka, koma ndizosiyana. Tsopano tiyenera kusunga fayilo. Pogwiritsa ntchito zida zoyendera, timapita ku chikwatu chomwe chikasinthidwa chikasungidwa. Ngakhale mutha kuzisiyira mu foda yomwe ilipo. M'munda "Fayilo dzina" ngati mukufuna, mutha kusintha dzina, koma sizofunikanso. Gawo lalikulu la ntchito yathu ndi gawo lotsatirali - Mtundu wa Fayilo. Dinani pamunda uno.

   

   Kuchokera pazomwe mungasankhe, sankhani Excel Workbook kapena Excel Workbook 97-2003. Yoyamba ya izi ndi yatsopano, yachiwiri yatha kale.



6. Pambuyo kusankha kwapangidwa, dinani batani Sungani.

Izi zimamaliza njira yotembenuzira fayilo ya XML kukhala mawonekedwe a Excel kudzera pa mawonekedwe a pulogalamuyo.

Njira 2: kutumizira deta

Njira yomwe ili pamwambapa ndiyoyenera kwa mafayilo a XML okha ndi mawonekedwe osavuta. Matebulo ovuta kwambiri pakutembenuka motere sangathe kutanthauziridwa molondola. Koma, pali chida china chopangidwa mu Excel chomwe chingathandize kulowetsa bwino deta. Ili mu Menyu Yopangayomwe imalemedwa ndi kusakhulupirika. Chifukwa chake, choyambirira, chimayenera kukhazikitsidwa.

1. Kupita ku tabu Fayilodinani pachinthucho "Zosankha".



2. Muwindo la zosankha, pitani pagawo laling'ono Kukhazikika kwa Ribbon. Kumanja kwa zenera, yang'anani bokosi pafupi "Wopanga". Dinani batani "Zabwino". Tsopano ntchito yofunikayo imayendetsedwa, ndipo tabu yolumikizana imawonekera pa riboni.



3. Pitani ku tabu "Wopanga". Pa nthiti yomwe ili m'bokosi la chida XML dinani batani "Idyani".



4. Iwindo lotsogolera likutseguka. Timapita kumalo osungira komwe chikalata chomwe timafuna chikupezeka. Sankhani ndikudina batani. "Idyani".



5. Kenako bokosi la zokambirana lingatsegulidwe, lomwe likuti fayilo yomwe yasankhidwa sikutanthauza chiwembucho. Afunsidwa kuti mupange pulogalamuyo nokha. Poterepa, tikugwirizana ndikudina batani "Zabwino".



6. Kenako, bokosi lotsatirana lotsatirali limatsegulidwa. Ikupangana kuti athe kusankha kutsegula tebulo m'buku latsopanoli kapena yatsopano. Popeza tinayambitsa pulogalamuyi osatsegula fayilo, titha kusiya zosankha izi ndikupitiliza kugwira ntchito ndi buku lomwe lilipo. Kuphatikiza apo, zenera lomwelo limapereka kuti liwone zolumikizana pa pepalalo pomwe tebulo lidzatengedwe. Mutha kulowa adilesi pamanja, koma ndi yosavuta komanso yosavuta kungodinanso pafoniyo, yomwe idzakhale gawo lamanzere patebulo. Pambuyo adilesi adalowa mu gawo la bokosi la zokambirana, dinani batani "Zabwino".



7. Pambuyo pa izi, tebulo la XML lidzayikidwa pazenera la pulogalamu. Kuti musunge fayilo mu mtundu wa Excel, dinani pazizindikiro mu mawonekedwe a diskette pakona yakumanzere kwa zenera.



8. Iwindo lotsegula limatsegulamo momwe muyenera kudziwa komwe chikusungiracho chikusungidwa. Mtundu wa fayilo nthawi ino udzakhazikitsidwa ndi XLSX, koma mutha kukulitsa mundawo ngati mukufuna Mtundu wa Fayilo ndikukhazikitsa mtundu wina wa Excel - XLS. Zikhazikiko zakusungidwa zikakhazikitsidwa, ngakhale izi zitha kusiyidwa ndikusintha, dinani batani Sungani.

Chifukwa chake, kutembenuka komwe tikufuna kudzatsirizidwa ndikutembenuka kolondola kwambiri.

Njira 3: Otembenuka pa intaneti

Ogwiritsa ntchito omwe pazifukwa zina alibe Excel yomwe idayikidwa pakompyuta, koma amafunika kutembenuka mwachangu pa fayilo kuchokera pa mtundu wa XML kupita ku EXCEL, mutha kugwiritsa ntchito imodzi mwazomwe mwapeza pa intaneti. Imodzi mwamasamba abwino kwambiri amtunduwu ndi Convertio.

Convertio pa intaneti

1. Pitani ku nkhokwe iyi pogwiritsa ntchito msakatuli aliyense. Pa iwo mutha kusankha njira zisanu zotsitsira fayilo yosinthika:
   • Kuchokera pa kompyuta hard drive;
   • Kuchokera ku Dropbox pa intaneti;
   • Kuchokera posungira pa intaneti ya Google
   • Ndi ulalo wochokera pa intaneti.

   Popeza kwa ife chikalatacho chimayikidwa pa PC, ndiye dinani batani "Kuchokera pamakompyuta".



2. Chikalata chotsegulira zenera chikuyamba. Pitani ku chikwatu komwe kuli. Dinani pa fayilo ndikudina batani. "Tsegulani".

   

   Palinso njira ina yowonjezerera fayilo muutumiki. Kuti muchite izi, ingokokerani dzina lake ndi mbewa kuchokera pa Windows Explorer.

3. Monga mukuwonera, fayiloyo yawonjezedwa pantchitoyo ndipo ili m'malo "Takonzedwa". Tsopano muyenera kusankha mawonekedwe omwe tikufuna kuti tisinthe. Dinani pabokosi pafupi ndi kalatayo "B". Mndandanda wamitundu yamafayilo umatsegulidwa. Sankhani "Chikalata". Kenako, mndandanda wamndandanda umatsegulidwa. Sankhani "Xls" kapena "Xlsx".



4. Pambuyo pomwe dzina lowonjezera likuwonjezeredwa pazenera, dinani batani lalikulu lofiira Sinthani. Pambuyo pake, chikalatacho chidzasinthidwa ndikupezeka kuti chitha kutsitsidwa pamtunduwu.

Izi zitha kukhala ngati ukonde wabwino ngati simungakwanitse kugwiritsa ntchito zida zatsopano zowongolera.

Monga mukuwonera, ku Excel pali zida zopangidwira zomwe zimakupatsani mwayi kuti muthe kusintha fayilo ya XML kuti ikhale imodzi mwamafomu "obadwa nawo" a pulogalamuyi. Zochitika zosavuta kwambiri zimatha kusinthidwa mosavuta kudzera pazomwe zimachitika "Sungani Monga ...". Kwa zikalata zomwe zili ndi mtundu wophatikizika, pali njira yosinthira yosiyanayo kudzera kunja. Ogwiritsa ntchito omwe pazifukwa zina sangathe kugwiritsa ntchito zida izi ali ndi mwayi wotsiriza ntchito pogwiritsa ntchito ntchito zapadera za intaneti pakusintha mafayilo.