XML yana daya daga cikin siffofin da aka fi kowa don adanawa da rarraba bayanai tsakanin aikace-aikace daban-daban. Microsoft Excel yana aiki tare da bayanan, don haka batun batun canza fayilolin daga daidaitattun XML zuwa siffofin Excel yana da matukar dacewa. Nemo yadda ake yin wannan hanya ta hanyoyi daban-daban.
Tsarin Juyawa
Ana rubuta fayilolin XML a cikin harshen da aka yi amfani da shi tare da wani abu kamar shafin yanar gizon HTML. Saboda haka, waɗannan matakan suna da tsari irin wannan. Bugu da ƙari, Excel shine, na farko, shirin da ke da siffofin "'yan ƙasa" da yawa. Mafi shahararrun su shine: Littafin Ayyuka na Excel (XLSX) da kuma Ayyuka na Excel 97 - 2003 (XLS). Bari mu gano hanyoyin da za a sauya fayiloli XML cikin wadannan takardun.
Hanyar hanyar 1: Ayyukan ginin aikin Excel
Excel yayi aiki tare da fayilolin XML. Ta iya bude su, canji, ƙirƙiri, ajiye. Sabili da haka, mafi sauƙi daga cikin aikin da aka saita a gabanmu shine bude wannan abu kuma ya adana ta hanyar aikace-aikacen aikace-aikacen a cikin hanyar XLSX ko XLS.
- Kaddamar da Excel. A cikin shafin "Fayil" tafi abu "Bude".
- An bude taga don buɗe takardun. Je zuwa shugabanci inda aka adana kayan aikin XML da ake bukata, zaɓi shi kuma danna maballin "Bude".
- Bayan an bude takardun ta hanyar Intera ɗin na Excel, sake koma shafin "Fayil".
- Tafi wannan shafin, danna kan abu "Ajiye Kamar yadda ...".
- A taga yana buɗewa kamar taga don bude, amma tare da wasu bambance-bambance. Yanzu muna buƙatar ajiye fayil din. Amfani da kayan aiki masu tafiya, je zuwa jagorar inda za'a ajiye adreshin da aka canja. Kodayake zaka iya barin shi a cikin babban fayil na yanzu. A cikin filin "Filename" idan kuna so, za ku iya sake suna, amma wannan ma bai zama dole ba. Babban filin don aikinmu shine filin da ke gaba: "Nau'in fayil". Danna kan wannan filin.
Daga zaɓuɓɓukan da aka ba da shawara, zaɓa littafin littafin Excel ko littafin littafin na Excel 97-2003. Na farko shine sabon saiti, na biyu ya riga ya riga ya ƙare.
- Bayan an zaɓa, danna kan maballin. "Ajiye".
Wannan ya kammala hanya don canza hanyar XML zuwa Tsarin Excel ta hanyar shirin.
Hanyar 2: Shigo da Bayanai
Hanyar da ke sama ita ce kawai ta dace da fayiloli XML tare da tsari mafi sauki. Ƙarin mahimman tsari lokacin da aka canza ta wannan hanya za a iya fassara shi kuskure. Amma, akwai wani kayan aiki na Excel wanda ya gina shi wanda ke taimaka maka ka shigo da bayanai daidai. An located in "Developer menu"wanda aka lalace ta hanyar tsoho. Saboda haka, da farko, yana bukatar a kunna.
- Je zuwa shafin "Fayil", danna abu "Zabuka".
- A cikin matakan sigogi je zuwa sashi Ribbon Saita. A gefen dama na taga, duba akwatin "Developer". Muna danna maɓallin "Ok". Yanzu aikin da ake buƙata ya kunna, kuma shafin da ya dace ya bayyana akan tef.
- Jeka shafin "Developer". A tef a cikin asalin kayan aiki "XML" danna maballin "Shigo da".
- Gilashin shigarwa yana buɗe. Je zuwa shugabanci inda aka buƙata takardun da aka so. Zaɓi shi kuma danna maballin. "Shigo da".
- Bayanan maganganu zai iya budewa, wanda ya nuna cewa fayil ɗin da aka zaba ba ya koma zuwa tsarin. Za a miƙa shi don ƙirƙirar shirin don shirin kanta. A wannan yanayin, yarda kuma danna maballin "Ok".
- Kashe na gaba, akwatin zane na gaba zai buɗe. An ba da shawara don yanke shawarar bude tebur a cikin littafin yanzu ko a sabon saiti. Tun da muka kaddamar da shirin ba tare da bude fayil ɗin ba, za mu iya barin wannan tsohowar wuri kuma ci gaba da aiki tare da littafin yanzu. Bugu da ƙari, wannan taga yana bada don sanin ƙayyadaddun akan takardar da za a shigo da tebur. Zaka iya shigar da adireshin da hannunka, amma yana da sauƙin kuma mafi dacewa don danna kan dan tantanin halitta akan takardar da zai zama babban hagu na hagu na teburin. Bayan an shigar da adireshin a cikin akwatin maganganu, danna maballin "Ok".
- Bayan waɗannan matakai, za a saka ma'anin XML a cikin shirin. Domin ajiye fayil ɗin a cikin fassarar Excel, danna kan gunkin a cikin nau'in faifai a cikin kusurwar hagu na taga.
- An ajiye taga sai ya buɗe inda kake buƙatar ƙayyade wurin da za a adana kayan. Tsarin fayil ɗin wannan lokaci za a shigar da XLSX, amma idan kuna so, za ku iya bude filin "Nau'in fayil" da kuma shigar da wani tsarin Excel-XLS. Bayan an saita saitunan adana, ko da yake a wannan yanayin za a iya barin su ta hanyar tsoho, danna kan maballin "Ajiye".
Saboda haka, za ayi sabon tuba a gare mu tare da fasalin bayanai mafi kyau.
Hanyar 3: Juyin Intanet
Wadannan masu amfani waɗanda saboda wasu dalilai ba su da wani shirin Excel da aka sanya a kan kwamfutar su amma suna buƙatar sauya fayil ɗin daga hanyar XML zuwa EXCEL iya amfani da ɗaya daga cikin ayyukan da ke kan layi na musamman don fassarar. Ɗaya daga cikin shafukan yanar gizo mafi dacewa irin wannan shine Juyawa.
Mai karfin Intanet mai sauyawa
- Je zuwa wannan shafin yanar gizon ta amfani da duk wani bincike. A kanta, zaka iya zaɓar hanyoyin 5 don sauke fayil mai canzawa:
- Daga rumbun kwamfutar;
- Daga Dropbox ajiya kan layi;
- Daga Google Drive ajiyar layi;
- A karkashin mahada daga Intanit.
Tunda a cikin shari'armu an sanya takardun a kan PC, sannan danna maballin "Daga kwamfutar".
- An kaddamar da taga don buɗe daftarin aiki. Je zuwa shugabanci inda aka samo shi. Danna kan fayil kuma danna maballin. "Bude".
Akwai kuma zaɓi madadin don ƙara fayil zuwa sabis ɗin. Don yin wannan, kawai ja shi tare da linzamin kwamfuta daga Windows Explorer.
- Kamar yadda kake gani, an ƙara fayiloli zuwa sabis kuma yana cikin jihar "An shirya". Yanzu muna bukatar mu zabi tsarin da muke buƙatar tuba. Danna kan taga kusa da wasika "A". Jerin kungiyoyin kungiyoyi sun buɗe. Zaɓi "Takardun". Kusa, jerin jerin takardun suna buɗewa. Zaɓi "XLS" ko "XLSX".
- Bayan an ƙara sunan tsawo da ake so a taga, danna kan babban maɓallin ja "Sanya". Bayan haka, za a sauko daftarin aiki don samowa akan wannan hanya.
Wannan zaɓin zai iya kasancewa mai kyau mai tsaro lafiya idan ba ta da damar yin amfani da kayan aikin sake fasalin wannan yanki.
Kamar yadda kake gani, Excel kanta na da kayan aikin ginawa waɗanda ke ba ka damar canza fayil na XML zuwa ɗaya daga cikin samfurori na wannan tsarin. Sauran yanayi mafi sauƙi za a iya sauya sauƙin ta hanyar aikin "Ajiye As ...". Don takardun da ke da tsari mai mahimmanci, akwai hanyar yin hira ta hanyar shigarwa. Wadannan masu amfani da wasu dalilai baza su iya amfani da waɗannan kayan aiki sun sami zarafin yin aikin ta amfani da sabis na kan layi na musamman don fassarar fayil ba.
