Canza Microsoft Excel Formats zuwa XML

XML tsari ne na duniya don aiki tare da bayanai. Akwai tallafi da yawa daga shirye-shirye, gami da daga DBMS Sphere. Sabili da haka, sauya bayanai zuwa XML yana da mahimmanci daidai daga ra'ayi na ma'amala da musayar bayanai tsakanin aikace-aikace daban-daban. Excel ɗaya ne daga cikin shirye-shiryen da suke aiki tare da tebur, kuma suna iya sarrafa bayanai. Bari mu ga yadda za a sauya fayilolin Excel zuwa XML.

Tsarin juyawa

Canza bayanai zuwa tsarin XML ba irin wannan tsari mai sauƙi bane, tunda dole ne a ƙirƙiri tsari na musamman (schema.xml) a hanyarta. Koyaya, don sauya bayanai zuwa mafi sauƙi fayil ɗin wannan tsari, ya isa a sami kayan aikin yau da kullun don adanawa a cikin Excel a hannu, amma don ƙirƙirar sashin tsari mai kyau, zaku sami tsinkaye sosai tare da zana zane da kuma haɗinsa da takaddar.

Hanyar 1: adana sauƙi

A cikin Excel, zaka iya ajiye bayanai a cikin tsarin XML kawai ta amfani da menu "Ajiye As ...". Gaskiya ne, babu wani tabbacin cewa to duk shirye-shiryen zasu yi aiki daidai tare da fayil wanda aka ƙirƙira ta wannan hanyar. Kuma ba a kowane yanayi ba, wannan hanyar tana aiki.

1. Mun fara shirin Excel. Don buɗe abin da za a canza, je zuwa shafin Fayiloli. Bayan haka, danna kan kayan "Bude".



2. Fayil bude taga yana farawa. Je zuwa wurin shugabanci inda fayil ɗin da muke buƙata ya ƙunshi. Dole ne ya kasance cikin ɗayan fasalin Excel - XLS ko XLSX. Zaɓi shi kuma danna maballin. "Bude"wanda yake a gindin taga.



3. Kamar yadda kake gani, an bude fayil din, kuma an nuna bayanan sa akan takardar ta yanzu. Je zuwa shafin sake Fayiloli.



4. Bayan haka, je zuwa "Ajiye As ...".



5. Wurin ajiyewa yana buɗewa. Mun je kan directory ɗin da muke son adana fayil ɗin da aka canza. Koyaya, zaku iya barin tsohuwar directory, wato, wanda shirin ya gabatar da kansa. A wannan taga, in kana so, zaka iya canja sunan fayil. Amma babban hankalin yana buƙatar biyan kuɗi zuwa filin Nau'in fayil. Mun buɗe jerin ta danna kan wannan filin.

   

   Daga cikin zaɓuɓɓukan don ceton da muke nema Tebur XML 2003 ko XML bayanai. Zaɓi ɗayan waɗannan abubuwan.



6. Bayan haka, danna maɓallin Ajiye.

Don haka, sauya fayil ɗin daga Excel zuwa tsarin XML za a kammala.

Hanyar 2: Kayan Kayayyakin haɓaka

Kuna iya sauya fasalin Excel zuwa XML ta amfani da kayan aikin haɓakawa akan shafin shirin. A lokaci guda, idan mai amfani ya yi komai daidai, to fitowar za ta kasance, sabanin hanyar da ta gabata, fayil ɗin XML mai cikakken tsari wanda za a gane shi ta hanyar aikace-aikacen ɓangare na uku. Amma dole ne in faɗi yanzunnan cewa ba kowane mai fara ba zai iya samun isasshen ilimi da ƙwarewa don koya koya yadda ake sauya bayanai ta wannan hanyar.

1. Ta hanyar tsoho, an kashe toolbar kayan aiki Sabili da haka, da farko, kuna buƙatar kunna shi. Je zuwa shafin Fayiloli kuma danna abun "Zaɓuɓɓuka".



2. A cikin sigogi na taga wanda zai buɗe, matsa zuwa sashin yanki Saitin Ribbon. A cikin ɓangaren dama na taga, duba akwatin kusa da ƙimar "Mai Haɓakawa". Bayan haka, danna maɓallin "Ok"wanda yake a gindin taga. Yanzu an kunna kayan aikin mai amfani



3. Na gaba, bude babbar falle a cikin shirin a kowane hanya mai dacewa.



4. A kan tushenta, dole ne mu ƙirƙiri tsarin da aka kafa a kowane editan rubutu. Don waɗannan dalilai, zaku iya amfani da Windows Notepad na yau da kullun, amma mafi kyawun amfani da takamaiman aikace-aikacen don shirye-shirye da aiki tare da yaruka masu lura da rubutu + Notepad ++. Mun ƙaddamar da wannan shirin. A ciki muke ƙirƙirar da'ira. A cikin misalinmu, zai yi kama da kallon allo a kasa yana nuna windowpad ++.

   

   Kamar yadda kake gani, alamar buɗewa da rufewa don takaddar gaba ɗaya ce "Tsarin bayanai". A cikin rawar guda, don kowane layi, alamar "Yi rikodin". Don tsari, zai isa idan muka ɗauki layuka biyu na tebur kawai, kuma kada ku fassara shi da hannu cikin XML. Sunan bude shafin rufewa da rufewa yana iya zama mai sabani, amma a wannan yanayin, don dacewa, mun fi so kawai fassara sunayen masu amfani da harshen Rashanci zuwa Turanci. Bayan an shigar da bayanai, kawai muna adana shi ta hanyar aikin edita rubutu a ko'ina akan rumbun kwamfutarka a cikin tsarin XML da ake kira "tsari".

5. Hakanan, tafi shirin Excel tare da teburin da aka rigaya an buɗe. Matsa zuwa shafin "Mai Haɓakawa". A kan kintinkiri a cikin akwatin kayan aiki XML danna maballin "Mai tushe". A filin da yake buɗewa, a gefen hagu na taga, danna maballin "Taswirorin XML ...".



6. A cikin taga da yake buɗe, danna maballin "...Ara ...".



7. Wurin zaɓi taga yana farawa. Zamu je inda aka tsara tsarin makirci da aka tattara a baya, zaɓi shi kuma danna maɓallin "Bude".



8. Bayan abubuwan da makircin ya fito a cikin taga, ja su ta amfani da siginan kwamfuta a cikin daidai jerin sunayen sunayen tebur.



9. Mun dama-danna kan tebur sakamakon. A cikin menu na mahallin, tafi cikin abubuwan XML da "Fitar da ...". Bayan haka, ajiye fayil ɗin a cikin kowane jagora.

Kamar yadda kake gani, akwai manyan hanyoyi guda biyu da zaka canza fayilolin XLS da XLSX zuwa Tsarin XML ta amfani da Microsoft Excel. Na farkon su yana da sauƙi sosai kuma yana ƙunshe da tsarin adana hanyar farko tare da ƙarin lokaci ta hanyar aiki "Ajiye As ...". Sauki da kwatancin wannan zabin babu shakka suna da fa'ida. Amma yana da aibi sosai. Ana yin jujjuyawar ba tare da yin la'akari da wasu ƙa'idodi ba, sabili da haka fayil ɗin da aka canza ta wannan hanyar ta aikace-aikacen ɓangare na uku ba za'a iya gane shi ba. Zabi na biyu ya hada da taskance XML. Ba kamar hanyar farko ba, teburin da aka canza bisa ga wannan tsarin zai bi duk ƙa'idodin ingancin XML. Amma, da rashin alheri, ba kowane mai amfani ba ne zai iya gano yanayin wannan hanzari.