Ungakwazi ukuguqula ifayela le-Excel libe ifayela ledatha le-XML noma ngokuphambene nalokho. Lokhu kuvumela ulwazi ukushintshaniswa phakathi kwezinhlelo zokusebenza ezahlukene. Ukuze uqalise, vula ithebhu Unjiniyela (Unjiniyela).
Nansi idatha esifuna ukuyiguqula ibe ifayela le-XML:
Okokuqala, ake sakhe i-schema esisekelwe kudatha ye-XML yasekuqaleni. I-schema ichaza ukwakheka kwefayela le-XML.
- I-Excel ayifanele le njongo, ngakho-ke vula, isibonelo, i-Notepad bese unamathisela imigqa elandelayo:
Smith 16753 UK Qtr 3 Johnson 14808 USA Qtr 4
Qaphela: Amathegi aqanjwe ngamagama amakholomu, kodwa ungawanikeza noma yiliphi igama olithandayo. Ngokwesibonelo, esikhundleni - .
- Gcina ifayili njenge i-schema.xml.
- Vula incwadi yokusebenzela ye-Excel.
- Chofoza Umthombo (umthombo) ithebhu Unjiniyela (Unjiniyela). Ibha yomsebenzi ye-XML izovuleka.
- Ukwengeza imephu ye-XML, chofoza inkinobho Amamephu we-XML (amamephu e-XML).Ibhokisi lengxoxo lizovela Amamephu we-XML (I-XML Maps).
- Cindezela Engeza (Engeza).
- Khetha i-schema.xml bese uchofoza kabili OK.
- Manje vele uhudule bese uphonsa izinto ezi-4 esihlahleni kubha yomsebenzi XML eshidini (umugqa 1).
- Chofoza inkinobho Thumela (Thekelisa) esigabeni XML ithebhu Unjiniyela (Unjiniyela).
- Londoloza ifayela bese uchofoza Faka.
Umphumela:
Lokhu konga isikhathi esiningi!
Qaphela: Ukungenisa ifayela le-XML, vula ibhuku lokusebenza elingenalutho. Kuthebhu Unjiniyela (Unjiniyela) chofoza Ngenisa (Ngenisa) bese ukhetha ifayela le-XML.