Guqula amafayela we-XML abe amafomethi we-Excel

I-XML ingenye yezindlela ezijwayelekile kakhulu zokugcina idatha nokushintshanisa idatha phakathi kwezicelo ezihlukile. Uhlelo lweMicrosoft Excel luphinde lusebenze nedatha, ngakho-ke udaba lokuguqula amafayela asuka kumafomethi we-XML ajwayelekile abe amafomethi e-Excel afanele kakhulu. Sizobona ukuthi ungayenza kanjani le nqubo ngezindlela ezahlukahlukene.

Inqubo yokuguqulwa

Amafayili we-XML abhalwe ngolimi olukhethekile olufana nolwe-HTML lwamakhasi e-web. Ngakho-ke, lezi zinhlaka zinesakhiwo esifanayo. Ngasikhathi sinye, i-Excel ngokuyinhloko uhlelo olunezindlela eziningana "zomdabu". Abadume kakhulu kubo yilaba: i-Excel Book (XLSX) ne-Excel Book 97 - 2003 (XLS). Ake sithole izindlela eziphambili zokuguqula amafayela we-XML kulezi zinhlobo.

Indlela yoku-1: ukusebenza kwe-Excel okwakhelwe ngaphakathi

I-Excel isebenza kahle ngamafayela we-XML. Angawavula, ashintshe, adale, alondoloze. Ngakho-ke, inketho elula yomsebenzi wethu ukuvula le nto bese uyigcina ngokusebenzisa isikhombimsebenzisi sohlelo ngesimo semibhalo ye-XLSX noma ye-XLS.

1. Siqala i-Excel. Kuthebhu Ifayela hamba uyokhomba "Vula".



2. Iwindi lemibhalo yokuvula liyasebenza. Siya kwisikhombisi lapho kugcinwa khona idokhumenti ye-XML, siyikhethe bese sichofoza inkinobho "Vula".



3. Ngemuva kokuthi idokhumenti ivuliwe ngokusebenzisa isikhombimsebenzisi se-Excel, uphinde uye kuthebhu Ifayela.



4. Ukuya kule thebhu, chofoza entweni. "Gcina Njengo ...".



5. Kuvulwa iwindi elifana newindows ukuvula, kepha umehluko othile. Manje sidinga ukugcina ifayili. Sisebenzisa amathuluzi wokuhambisa, siya kwisikhombi lapho kuzogcinwa khona idokhumenti eguquliwe. Noma ungayishiya kufolda yamanje. Ensimini "Igama lefayela" uma ufisa, ungayiqamba kabusha, kodwa futhi lokhu akudingekile. Inkambu enkulu yomsebenzi wethu yinkambu elandelayo - Uhlobo lwefayela. Chofoza kule nkambu.

   

   Ezinhlotsheni ezihlongozwayo, khetha i-Excel Workbook noma i-Excel Workbook 97-2003. Okokuqala kwalokhu okusha, okwesibili sekuphelelwe yisikhathi.



6. Ngemuva kokuthi ukwenziwa kwenziwe, chofoza inkinobho Gcina.

Lokhu kuqeda inqubo yokuguqula ifayela le-XML libe yifomethi ye-Excel ngokusebenzisa isikhombimsebenzisi sohlelo.

Indlela 2: idatha yokungenisa

Indlela engenhla ilungele kuphela amafayela we-XML anesakhiwo esilula kakhulu. Amathebula ayinkimbinkimbi ngaphezulu ngesikhathi sokuguqulwa ngale ndlela kungenzeka angahunyushwa kahle. Kepha, kukhona elinye ithuluzi le-Excel elakhelwe ngaphakathi elizosiza ukungenisa idatha ngokufanele. Itholakala ngaphakathi Imenyu Yonjiniyelaekhutshazwe ngokuzenzakalela. Ngakho-ke, okokuqala, idinga ukwenziwa ukuthi isebenze.

1. Iya kuthebhu Ifayelachofoza entweni "Izinketho".



2. Ewindini lokukhethwa kukho, iya esigatshaneni esingezansi Ukusethwa kweRibbon. Ngakwesokunene sewindi, hlola ibhokisi eliseduze "Unjiniyela". Chofoza inkinobho "Kulungile". Manje umsebenzi owuthandayo uyasebenza, bese kuthi ithebhu ehambisanayo ivele ku iribhoni.



3. Iya kuthebhu "Unjiniyela". Kubambo olubekwe ebhokisini lamathuluzi I-XML chofoza inkinobho "Ngenisa".



4. Iwindi lokungenisa liyavula. Siya kumkhombandlela lapho idokhumenti esidingayo itholakala. Khetha bese uchofoza inkinobho. "Ngenisa".



5. Ngemuva kwalokho kuvulwa ibhokisi lengxoxo, elisho ukuthi ifayela elikhethiwe alisho uhlelo. Kuzohlongozwa ukuthi uzenzele uhlelo lohlelo ngokwakho. Kulokhu, siyavuma futhi sichofoza inkinobho "Kulungile".



6. Okulandelayo, ibhokisi lengxoxo elilandelayo liyavula. Iphakamisa ukunquma ukuthi ivule itafula encwadini yamanje noma entsha. Njengoba sethula uhlelo ngaphandle kokuvula ifayela, singashiya lokhu kulungiselelwa okuzenzakalelayo bese siqhubeka nokusebenza ngebhuku yamanje. Ngaphezu kwalokho, iwindows elifanayo linikezela ukunquma izixhumanisi ekhasini lapho ithebula lizongeniswa khona. Ungafaka ikheli ngesandla, kepha kulula kakhulu futhi kulula kakhulu ukumane uchofoze iseli eshidini, elizoba yinto ephezulu kwesobunxele yetafula. Ngemuva kokuthi ikheli selifakiwe emkhakheni webhokisi lengxoxo, chofoza inkinobho "Kulungile".



7. Ngemuva kwalezi zinyathelo, itafula le-XML lizofakwa efasiteleni lohlelo. Ukuze ugcine ifayela ngefomethi ye-Excel, chofoza isithonjana esesimweni sediski ekhoneni eliphezulu kwesokunxele lewindi.



8. Kuvulwa iwindi lokonga lapho udinga khona ukuthola isqondisi lapho idokhumenti izogcinwa khona. Uhlobo lwefayela ngalesi sikhathi luzofakwa kuqala nge-XLSX, kepha ungayandisa insimu uma ufisa Uhlobo lwefayela bese ufaka enye ifomethi ye-Excel - XLS. Ngemuva kokuthi amasethingi wokonga asethelwe, yize kulokhu angashiywa ngokuzenzakalelayo, chofoza inkinobho Gcina.

Ngakho-ke, ukuguqulwa kokuqondisa esikudingayo kuzoqedwa ngokuguqulwa kwedatha okulungile kakhulu.

Indlela 3: isiguquli se-inthanethi

Kulabo basebenzisi, ngasizathu simbe, abangenayo i-Excel efakwe ekhompyutheni yabo, kepha badinga ukuguqulwa okuphuthumayo kwefayela kusuka kufomethi ye-XML kuya ku-EXCEL, ungasebenzisa enye yezinsizakalo eziningi ezikhethekile eziku-inthanethi zokuguqula. Enye yamasayithi alula kakhulu alolu hlobo yiConvertio.

Isiguquli esiguqulwa ku-inthanethi

1. Iya kulomthombo wewebhu usebenzisa noma yisiphi isiphequluli. Kuyo ungakhetha izindlela ezi-5 zokulanda ifayela eliguquliwe:
   • Kusuka kwikhompyutha hard drive;
   • Kusuka kwisitoreji esise-Dropbox online;
   • Kusuka kwisitoreji esiku-inthanethi seGoogle Drayivu
   • Ngesixhumanisi esivela ku-Inthanethi.

   Njengoba kithi icala lifakwa kwi-PC, bese uchofoza inkinobho "Kusuka kukhompyutha".



2. Kuqala idokhumenti elivulekile. Iya kumkhombandlela lapho kutholakala khona. Chofoza kufayela bese uchofoza inkinobho. "Vula".

   

   Futhi ikhona enye indlela yokwengeza ifayili kusevisi. Ukuze wenze lokhu, mane uhudule igama layo negundane kusuka ku-Windows Explorer.

3. Njengoba ukwazi ukubona, ifayela lingeziwe kusevisi futhi lisesimweni "Ilungiselelwe". Manje udinga ukukhetha ifomethi esidinga ukuguqulwa. Chofoza ebhokisini eliseduze nencwadi "B". Uhlu lwamaqembu wefayela luyavula. Khetha "Idokhumenti". Okulandelayo, uhlu lwezakhiwo luyavula. Khetha "Xls" noma "IXlsx".



4. Ngemuva kokuthi igama lesengezo olifunayo lifakiwe efasiteleni, chofoza inkinobho ebomvu enkulu Guqula. Ngemuva kwalokho, idokhumenti izoguqulwa futhi itholakale ukuze ilandwe kulo mthombo.

Le nketho ingasebenza njengetha elihle lokuphepha uma kwenzeka kungatholakali amathuluzi ajwayelekile wokuguqula kabusha kule ndlela.

Njengoba ukwazi ukubona, e-Excel kunamathuluzi akhelwe ngaphakathi akuvumela ukuthi uguqule ifayela le-XML libe linye lefomethi "yendabuko" yalolu hlelo. Izimo ezilula kakhulu zingaguqulwa kalula ngomsebenzi ojwayelekile "Gcina Njengo ...". Kumadokhumenti anesakhiwo esiyinkimbinkimbi ngokwengeziwe, kunenqubo yokuguqula ehlukile ngokungenisa. Labo basebenzisi okungenasizathu esithile abakwazi ukusebenzisa la mathuluzi banethuba lokuqedela umsebenzi besebenzisa izinsizakalo ezikhethekile ze-inthanethi zokuguqula amafayela.