Kuna iya canza fayil ɗin Excel zuwa fayil ɗin bayanan XML ko akasin haka. Wannan yana ba da damar musayar bayanai tsakanin aikace-aikace daban-daban. Don farawa, buɗe shafin developer (Developer).
Anan ga bayanan da muke so mu canza zuwa fayil na XML:
Da farko, bari mu ƙirƙiri tsari bisa ainihin bayanan XML. Tsarin yana bayyana tsarin fayil ɗin XML.
- Excel bai dace da wannan dalili ba, don haka buɗe, alal misali, Notepad kuma liƙa layin masu zuwa:
Smith 16753 UK Qtr 3 Johnson 14808 USA Qtr 4
lura: Ana ba wa alamun sunaye da sunan ginshiƙi, amma kuna iya ba su kowane suna da kuke so. Misali, maimakon - .
- Adana fayil ɗin azaman tsarin.xml.
- Bude littafin aikin Excel.
- Click a kan source (source) tab developer (Developer). Za'a buɗe ma'ajin aikin XML.
- Don ƙara taswirar XML, danna maɓallin XML Maps (taswirorin XML) .akwatin maganganu zai bayyana XML Maps (Taswirar XML).
- latsa Add (Ƙara).
- zabi tsarin.xml kuma danna sau biyu OK.
- Yanzu kawai ja da sauke abubuwa 4 daga bishiyar a cikin taskbar XML akan takardar (jere na 1).
- latsa Export (Export) a cikin sashin XML tab developer (Developer).
- Ajiye fayil ɗin kuma danna Shigar.
Sakamako:
Wannan yana adana lokaci mai yawa!
lura: Don shigo da fayil XML, buɗe littafin aiki mara komai. A kan shafin developer (Developer) danna Import (Shigo da) kuma zaɓi fayil ɗin XML.