Yadda za a canza XML don Excel

XML yana ɗaya daga cikin abubuwan da suka fi dacewa don adana bayanai da musayar su tsakanin aikace-aikace daban-daban. Microsoft Excel kuma yana aiki tare da bayanai, don haka tambayar sauya fayiloli daga XML Standard don Ingantaccen tsari yana da matukar dacewa. Gano yadda ake yin wannan hanyar ta hanyoyi daban-daban.

Canza tsari

An rubuta fayilolin XML a cikin yare na musamman tare da wani abu mai kama da shafukan yanar gizo na HTML. Saboda haka, waɗannan nau'ikan suna da tsari mai kama da juna. A lokaci guda, Excel shine wani shiri na farko wanda yana da nau'ikan "na asali". Mafi mashahuri daga gare su: Littafin Excel (xlsx) da Excel 97 - Littafin 2003 (XLs). Mun gano mahimman fayilolin don sauya fayilolin XML zuwa waɗannan nau'ikan.

Hanyar 1: Ayyukan Exeldedededededededededededededed

Areight shirin yana aiki mai girma tare da fayilolin tsarin XML. Zai iya buɗe su, canji, ƙirƙira, Ajiye. Sabili da haka, mafi sauƙin zaɓi don ɗalibinmu shine buɗe wannan abun kuma adana shi ta hanyar dubawa ta aikace-aikacen XLSX ko XLS takardu.

1. Gudu Excel. A cikin "Fayil", je zuwa "Buɗe".



2. An kunna taga bude. Je zuwa directory inda aka adana daka XML da kake buƙata, muna nuna shi kuma danna maɓallin "Buɗe".



3. Bayan an buɗe takaddar ta hanyar keɓaɓɓen keɓancewa, je zuwa shafin "fayil".



4. Je zuwa wannan shafin, danna "Ajiye azaman ...".



5. Taggawa yana buɗe kama da taga taga, amma tare da wasu bambance-bambance. Yanzu muna buƙatar ajiye fayil ɗin. Yin amfani da kayan aikin kewayawa, je zuwa directory inda za'a adana takaddar canjin. Kodayake zaka iya barin shi a babban fayil na yanzu. A cikin "Sunan fayil" filin, idan kuna so, zaku iya sake shi, amma wannan ma ba lallai ba ne. Don aikinmu, mai zuwa shine filin mai zuwa - "nau'in fayil". Danna wannan filin.

   

   Daga zaɓin da aka gabatar, zaɓi littafin Excel ko littafin Excel 97-2003. Na farko shine sabo, na biyu an riga an ɗan tsufa.



6. Bayan an yi zaɓin, danna maɓallin "Ajiye".

A kan wannan, tsarin canza fayil ɗin XML a cikin tsari mai kyau ta hanyar binciken dubawa ya ƙare.

Hanyar 2: shigo da kaya

Hanyar da aka bayyana ta dace da fayilolin XML kawai tare da mafi sauki. Forarin tebur masu rikitarwa lokacin juyawa ta wannan hanyar ana iya fassara ba daidai ba. Amma akwai wani kayan aiki na Exelded mai kyau wanda zai taimaka sosai shigo da bayanai. Yana cikin menu na mai haɓakawa, wanda aka kashe ta tsohuwa. Saboda haka, da farko, yana buƙatar kunnawa.

1. Je zuwa "Fayil", danna maballin "sigogi".



2. A cikin sakin layi taga, je zuwa "kintinkiri saitin". A gefen dama na taga, mun sanya kaska game da kayan mai haɓakawa. Latsa maɓallin "Ok". Yanzu an kunna aikin da ake so, shafin mai dacewa ya bayyana akan tef.



3. Je zuwa shafin mai haɓakawa. A kan tef a cikin "XML" toshe kayan aiki muna danna kan maɓallin "shigo da".



4. Da shigo da ke buɗe. Je zuwa directory inda takaddar da kake buƙata take. Zaɓi kuma danna maɓallin "shigo da".



5. Na gaba, za a iya buɗe akwatin maganganu, wanda ya faɗi cewa fayil ɗin da aka zaɓa baya nufin tsarin. Za a sa shi ya kirkiri tsarin shirin da kansa. A wannan yanayin, mun yarda kuma danna maɓallin "Ok".



6. Na gaba yana buɗe akwatin maganganu masu zuwa. Ana gayyata don yanke shawara don buɗe tebur a cikin littafin yanzu ko a cikin sabon. Tunda mun ƙaddamar da wani shiri ba tare da buɗe fayil ba, zamu iya barin wannan tsararren tsoho kuma ci gaba da aiki tare da littafin yanzu. Bugu da kari, taga iri daya yana ba da shawarar tantance masu tsara shi a kan takardar a cikin takardar tebur. Kuna iya shigar da adireshin da hannu, amma yana da sauƙi kuma mafi dacewa kuma mafi dacewa don kawai danna tantanin a kan takarda wanda zai zama ƙarshen ɓangaren tebur. Bayan an shigar da adireshin a cikin akwatin tattaunawa, danna maɓallin "Ok".



7. Bayan waɗannan ayyukan, za a saka teburin XML a cikin taga shirin. Domin adana fayil ɗin Excel mai cikakken tsari tare da alamar flick a cikin hanyar faifan floppy a saman kusurwar hagu na taga.



8. Ajiye Window yana buɗewa cikin abin da kuke buƙata don sanin directory inda za'a adana takaddun. Tsarin fayil ɗin wannan lokacin za a adana XLSX, amma idan kuna so, zaku iya bayyana filin "Fayil" kuma shigar da wani kyakkyawan tsari - XLS. Bayan an saita saitunan adana, kodayake a wannan yanayin ana iya barin ta tsohuwa, danna maɓallin "Ajiye".

Don haka, juyawa a cikin hanyar da ake buƙata don mu za a yi tare da matsakaicin juyi daidai.

Hanyar 3: Canji kan layi

Waɗannan masu amfani da wasu dalilai waɗanda ba a shigar da wani dalili a kwamfutar da Excelpt shirin daga XML don Excel, zaku iya amfani da ɗayan yawancin sabis na musamman don juyawa. Daya daga cikin rukunin yanar gizo masu dacewa na wannan nau'in shine Repase.

Mai Saudi na Overpoo

1. Je zuwa wannan hanyar yanar gizo tare da kowane mai bincike. Kuna iya zaɓar hanyoyi 5 don saukar da fayil mai canzawa:
   • Tare da diski mai wuya na kwamfutar;
   • Daga sauke saitin kan layi;
   • Daga kantin kan layi na Google Drive;
   • Dangane da hanyar haɗi daga Intanet.

   Tunda a lamarinmu, an sanya takaddun a PC, danna maɓallin "daga maɓallin kwamfuta".



2. Gudun taga yana gudana. Je zuwa directory inda aka sanya shi. Danna kan fayil ɗin kuma danna maɓallin "Open".

   

   Akwai kuma madadin don ƙara fayil zuwa sabis. Don yin wannan, kawai ja sunan sa tare da Windows Explorer.

3. Kamar yadda kake gani, an ƙara fayil ɗin zuwa sabis ɗin kuma yana cikin yanayin "tattalin". Yanzu kuna buƙatar zaɓar tsarin da kuke buƙatar juyawa. Danna kan taga kusa da harafin "b". Jerin rukunin fayil suna buɗewa. Zabar "takaddar". Na gaba yana buɗe jerin abubuwa. Zaɓi "XLS" ko "XLSX".



4. Bayan sunan fadada aka kara zuwa ga taga, danna maɓallin Red "Mai Sauya" maɓallin. Bayan haka, za a canza takaddun kuma ana samun sa don saukarwa akan wannan hanya.

Wannan zabin na iya zama kyakkyawan tsari mai aminci idan akwai rashin tsaro na samun dama ga daidaitattun kayan aikin don sake fasalin ta wannan hanyar.

Kamar yadda kake gani, akwai kayan aikin da aka gina a cikin yaduwa da kanta don sauya fayil na XML ga ɗayan '' 'yan asalin "na wannan shirin. Za'a iya canza misalin sauƙaƙe ta hanyar "Adana azaman ..." aiki. Don takardu tare da ƙarin hadaddun tsari, akwai tsari daban-daban ta hanyar shigo da kaya. Wadancan masu amfani da kowane irin aiki ba za su iya amfani da waɗannan kayan aikin suna da ikon aiki ta amfani da sabis na musamman don canza fayiloli ba.