Waxaad u rogi kartaa faylka Excel faylka xogta XML ama si kale. Tani waxay u ogolaaneysaa in macluumaadka la isku dhaafsado codsiyada kala duwan. Si aad u bilowdo, fur tab Developer (Developer).
Waa kan xogta aan rabno inaan u beddelno faylka XML:
Marka hore, aynu abuurno schema ku salaysan xogta asalka ah ee XML. Nidaamku wuxuu qeexayaa qaabka faylka XML.
- Excel kuma habboona ujeedadan, markaa fur, tusaale ahaan, Notepad oo ku dheji khadadka soo socda:
Smith 16753 UK Qtr 3 Johnson 14808 USA Qtr 4
Fiiro gaar ah: Calaamadaha waxaa lagu magacaabaa magacyada tiirarka, laakiin waxaad siin kartaa magac kasta oo aad rabto. Tusaale ahaan, halkii - .
- Keydso faylka sida schema.xml.
- Fur buug-shaqeedka Excel.
- Guji source (source) tab Developer (Developer). Barta shaqada ee XML ayaa furmi doonta.
- Si aad ugu darto khariidadda XML, dhagsii badhanka Khariidadaha XML (Khariidado XML) .Sanduuqa wada hadalka ayaa soo bixi doona Khariidadaha XML (Khariidadaha XML).
- Press Add (ku dar).
- Dooro schema.xml oo laba jeer guji OK.
- Hadda kaliya jiid oo ku soo tuur 4 shay geedka ku yaal barta shaqada ee XML xaashida ( safka 1).
- -saxaafadeed dhoofinta (Dhoofinta) ee qaybta XML tab Developer (Developer).
- Kaydi faylka oo guji Ku qor.
Natiijo:
Tani waxay badbaadinaysaa waqti badan!
Fiiro gaar ah: Si aad u soo dejiso faylka XML, fur buug-shaqeedka maran. On tab Developer (Developer) guji Soo dejinta (Import) oo dooro faylka XML.