XML ɗayan manyan dabarun tsari ne don adana bayanai da musayar bayanai tsakanin aikace-aikace daban-daban. Har ila yau, aikin Microsoft Excel yana aiki tare da bayanai, don haka batun sauya fayiloli daga ma'aunin XML zuwa tsarin Excel yana da matukar dacewa. Zamu gano yadda ake aiwatar da wannan hanyar ta hanyoyi daban-daban.
Tsarin juyawa
Fayilolin XML an rubuta su cikin harshe na musamman na bada farashi kwatankwacin HTML na shafukan yanar gizo. Saboda haka, wadannan nau'ikan tsari suna da tsari mai kama daya mai kama. A lokaci guda, Excel babban shirin ne wanda ke da tsarukan "yan ƙasa" da yawa. Wadanda suka fi shahara a cikinsu sune: Excel Book (XLSX) da Excel Book 97 - 2003 (XLS). Bari mu gano mahimman hanyoyin canza fayilolin XML zuwa waɗannan tsarukan.
Hanyar 1: Babban aikin ginannun ayyukan haɓaka
Excel yana aiki mai girma tare da fayilolin XML. Tana iya buɗe su, canzawa, ƙirƙira, adanawa. Sabili da haka, mafi kyawun zaɓi don aikinmu shine buɗe wannan abun kuma adana shi ta hanyar aikace-aikacen aikace-aikacen a cikin hanyar takardunLLSX ko XLS.
- Mun fara kyau. A cikin shafin Fayiloli je maki "Bude".
- Ana kunna taga don buɗe takardu. Mun je kan shugabanci inda aka adana takaddun XML da muke buƙata, zaɓi shi kuma danna maballin "Bude".
- Bayan an buɗe takaddun ta hanyar keɓaɓɓiyar dubawa, sake komawa zuwa shafin Fayiloli.
- Je zuwa wannan shafin, danna kan kayan. "Ajiye As ...".
- Wani taga yana buɗewa wanda yake kama da taga zai buɗe, amma tare da wasu bambance-bambance. Yanzu muna buƙatar ajiye fayil ɗin. Ta amfani da kayan aikin kewaya, za mu je ga inda za a adana takaddar da aka tanada. Dukda cewa zaku iya barin sa a babban fayil na yanzu. A fagen "Sunan fayil" idan ana so, zaku iya sake sunan ta, amma wannan ma ba lallai bane. Babban filin aikin mu shine filin mai zuwa - Nau'in fayil. Danna wannan filin.
Daga zaɓuɓɓukan da aka gabatar, zaɓi Workajin Aikin KYAUTA ko Excel Workbook 97-2003. Na farkon waɗannan sabo ne, na biyu tuni ya ɗan ɗanɗana.
- Bayan an yi zaɓi, danna maballin Ajiye.
Wannan ya kammala hanya don sauya fayil ɗin XML zuwa Tsarin Excel ta hanyar ma'anar shirin.
Hanyar 2: shigo da bayanai
Hanyar da ke sama ta dace ne kawai don fayilolin XML tare da tsari mafi sauƙi. Morearin rikitattun tebur yayin jujjuya ta wannan hanyar bazai iya fassara su daidai. Amma, akwai wani kayan aiki mai inganci na Excel wanda zai taimaka wajen shigo da bayanai daidai. Yana is located in Menu na Haɓakawanda aka kunna ta tsohuwa. Saboda haka, da farko, yana buƙatar kunnawa.
- Je zuwa shafin Fayilolidanna kan kayan "Zaɓuɓɓuka".
- A cikin zaɓuɓɓukan window, je zuwa sashin hoojin Saitin Ribbon. A gefen dama na taga, duba akwatin kusa da "Mai Haɓakawa". Latsa maballin "Ok". Yanzu ana kunna aikin da ake so, kuma shafin yana bayyana akan kintinkiri.
- Je zuwa shafin "Mai Haɓakawa". A kan kintinkiri a cikin akwatin kayan aiki XML danna maballin "Shigo".
- Wurin shigo da kaya yana buɗewa. Mun je ga inda littafin da muke bukata yake. Zaɓi shi kuma danna maballin. "Shigo".
- Sannan akwatin magana na iya buɗewa, wanda ke cewa fayil ɗin da aka zaɓa baya nufin makircin. Za a ba da shawara don ƙirƙirar tsarin shirin kanku. A wannan yanayin, mun yarda kuma danna maballin "Ok".
- Gaba, akwatin tattaunawar da ke gaba yana buɗe. Ya ba da shawara don yanke shawara ko buɗe teburin a cikin littafin na yanzu ko a cikin sabon. Tunda mun ƙaddamar da shirin ba tare da buɗe fayil ɗin ba, zamu iya barin wannan tsohuwar tsarin kuma ci gaba da aiki tare da littafin yanzu. Bugu da kari, wannan taga yana bayar da shawarar ne domin daidaitawa a takarda inda za'a shigo da teburin. Kuna iya shigar da adireshin da hannu, amma ya fi sauƙi kuma ya fi dacewa don danna kawai akan sel akan takardar, wanda zai zama babban hagu na teburin. Bayan an shigar da adireshin a filin akwatin tattaunawa, danna maballin "Ok".
- Bayan waɗannan matakan, za'a shigar da tebur XML a cikin taga shirin. Don adana fayil ɗin a cikin babbar hanyar Excel, danna kan gunkin a cikin nau'in diskette a saman kusurwar hagu na taga.
- Wani tsari taga yana buɗewa wanda kake buƙatar tantance shugabanci inda za'a adana takaddar. Tsarin fayil ɗin a wannan lokacin za a fara shigar da XLSX, amma zaku iya fadada filin idan kuna so Nau'in fayil kuma shigar da wani tsari na Excel - XLS. Bayan an saita saitin ajiyewa, kodayake a wannan yanayin ana iya barin su ta tsohuwa, danna maɓallin Ajiye.
Don haka, juyawa a cikin hanyar da muke buƙata za a kammala tare da mafi kyawun sauyawar bayanai.
Hanyar 3: mai sauyawa akan layi
Ga waɗancan masu amfani waɗanda, saboda wasu dalilai, ba su da Excel shigar da kwamfutarsu, amma suna buƙatar sauya fayil ɗin gaggawa daga tsarin XML zuwa EXCEL, zaka iya amfani da ɗayan sabis na musamman na kan layi don juyawa. Daya daga cikin wuraren da suka fi dacewa da wannan nau'in ita ce Convertio.
Mai sauya layi akan layi
- Je zuwa wannan hanyar yanar gizon ta amfani da kowane mai bincike. A kanta zaku iya zaɓar hanyoyi 5 don sauke fayil ɗin da aka canza:
- Daga rumbun kwamfutarka;
- Daga akwatin ajiya na kan layi;
- Daga Google Drive kan layi
- Ta hanyar hanyar yanar gizo.
Tunda a yanayinmu ana sanya takaddun akan PC, sannan danna kan maɓallin "Daga komputa".
- Ana buɗe takaddar bude takarda. Je zuwa inda shugabanin yake. Danna kan fayil ɗin kuma danna maballin. "Bude".
Akwai kuma wata hanyar da za a bi don ƙara fayil a sabis. Don yin wannan, kawai jan sunanta tare da linzamin kwamfuta daga Windows Explorer.
- Kamar yadda kake gani, an kara fayil ɗin zuwa sabis ɗin kuma yana cikin jihar "An shirya". Yanzu kuna buƙatar zaɓar tsarin da muke buƙatar juyawa. Danna kan akwatin kusa da harafin "B". Lissafin rukuni na fayil ya buɗe. Zaba "Rubutun takardu". Bayan haka, jerin hanyoyin suna buɗewa. Zaba "Xls" ko "Xlsx".
- Bayan an ƙara sunan wanda ake so tsawo a cikin taga, danna maɓallin babban ja Canza. Bayan haka, za a juya takaddun kuma za a samu don saukewa akan wannan kayan aikin.
Wannan zabin na iya kasancewa a zaman cibiyar tsaro mai kyau idan aka samu damar samun ingantattun kayan aikin gyara a wannan hanyar.
Kamar yadda kake gani, a cikin Excel akwai kayan aikin ginannun kayan haɓaka waɗanda zasu ba ka damar canza fayil ɗin XML zuwa ɗayan tsarin "'yan ƙasa" na wannan shirin. Ana iya canza saurin mafi sauƙin sauƙin ta hanyar aikin da aka saba "Ajiye As ...". Don takaddun da ke da tsayayyen tsari, akwai keɓaɓɓen tsari ta hanyar shigo da kaya. Wadancan masu amfani waɗanda saboda wasu dalilai ba za su iya amfani da waɗannan kayan aikin ba suna da damar kammala aikin ta amfani da sabis na kan layi na musamman don sauya fayiloli.
