Landa bese ufaka abashayeli be-HP Deskjet 1510 MFP

I-XML ifomethi yendawo yonke yokusebenza nedatha. Isekelwa izinhlelo eziningi, kuhlanganise nalabo abavela kumkhakha we-DBMS. Ngakho-ke, ukuguqulwa kolwazi ku-XML kubalulekile ngokunembile ngokusebenzisana nokushintshaniswa kwedatha phakathi kwezicelo ezahlukene. I-Excel ingenye yezinhlelo zokusebenza ezisebenzisana namatafula, futhi zingenza ngisho nokwenziwa kwemininingwane yedatha. Ake sibone indlela yokuguqula amafayela e-Excel ku-XML.

Inqubo yokuguqulwa

Ukuguqula idatha kwifomathi ye-XML akuyona inqubo elula, kusukela ku-course yayo i-schema ekhethekile (schema.xml) kumele idalwe. Kodwa-ke, ukuguqula imininingwane efayeleni elula yale fomethi, kwanele ukuba namathuluzi okugcina evamile ku-Excel esiseduze, kepha ukwakha into ehlelekile kuzodingeka uhlolisise ngokudweba umdwebo bese uxhuma kulo mbhalo.

Indlela 1: Gcina okulula

Ku-Excel, ungagcina idatha kwifomethi ye-XML ngokumane usebenzisa imenyu "Londoloza njengo ...". Iqiniso, ayikho isiqinisekiso sokuthi ngokuhamba kwesikhathi zonke izinhlelo zizosebenza kahle nefayela eladalwa ngale ndlela. Futhi hhayi kuzo zonke izimo, le ndlela isebenza.

1. Qalisa uhlelo lwe-Excel. Ukuze uvule into okuzoguqulwa iya kuthebhu "Ifayela". Okulandelayo, chofoza entweni "Vula".



2. Ivula iwindi lokuvula ifayela. Iya esiqondisweni esiqukethe ifayela esiyidingayo. Kumelwe kube kwesinye sezifomethi ze-Excel - i-XLS noma i-XLSX. Khetha bese uchofoza inkinobho. "Vula"etholakala phansi kwefasitela.



3. Njengoba ubona, ifayela lavuleka, futhi idatha yayo iboniswe eshadini samanje. Iya kuthebhu futhi "Ifayela".



4. Emva kwalokho hamba into "Londoloza njengo ...".



5. Iwindi lokugcina livula. Iya kusiqondisi esifisa ukugcina ifayela eliguquliwe. Noma kunjalo, ungashiya isiqondisi esizenzakalelayo, okungukuthi, esinikezwa wuhlelo ngokwayo. Ewindini elifanayo, uma kukhona isifiso, ungashintsha igama lefayela. Kodwa ukugxila kufanele kube ensimini. "Uhlobo lwefayela". Sivula uhlu ngokuchofoza kule nkambu.

   

   Phakathi kwezinketho zokulondolozwa zifuna igama "I-XML 2003 ithebula" noma "Idatha ye-XML". Khetha eyodwa yalezi zinto.



6. Emva kwalokho, chofoza inkinobho "Gcina".

Ngakho, ukuguqulwa kwefayela kusuka kufomethi ye-Excel kuya ku-XML kuzoqedwa.

Indlela 2: Amathuluzi Womthuthukisi

Ungaguqula i-Excel kuya ku-XML usebenzisa amathuluzi wonjiniyela kuthebhu yesistimu. Ngesikhathi esifanayo, uma umsebenzisi enza konke ngokufanele, khona-ke ekuphumeni azothola, ngokungafani nendlela eyedlule, ifayela le-XML eligcwele, elizoqondiswa kahle yizinhlelo zokusebenza zangaphandle. Kodwa kufanele ngithi masinyane ukuthi akuwona wonke umuntu omusha ongathola ulwazi nolwazi olwanele ukuze afunde ngokushesha ukuthi angashintsha kanjani idatha ngale ndlela.

1. Ngokuzenzakalelayo, ithebhu yamathuluzi yonjiniyela ikhutshaziwe. Ngakho-ke, okokuqala, udinga ukuyiqalisa. Iya kuthebhu "Ifayela" bese uchofoza into "Izinketho".



2. Kuwindi yemingcele evulwayo, hamba esigatshaneni Ukusethwa kweRibhoni. Endaweni efanele yefasitela usethe uphawu eduze nenani "Unjiniyela". Emva kwalokho, chofoza inkinobho "Kulungile"efakwe ngaphansi kwefasitela. Ithebhu yamathuluzi yonjiniyela manje inikwe amandla.



3. Okulandelayo, vula ithebula le-Excel ohlelweni nganoma iyiphi indlela elula.



4. Ngokusekelwe kulo, kufanele senze uhlelo olwakhiwe kunoma yimuphi umhleli wombhalo. Ngale njongo, ungasebenzisa i-Windows Notepad evamile, kodwa kungcono ukusebenzisa uhlelo lokusebenza olukhethekile lokuhlela nokusebenza ngezilimi ze-Notepad ++ ze-markup. Qalisa lolu hlelo. Kulo sakha uhlelo. Esikhathini sethu, sizobukeka njengoba kuboniswe ngezansi ku-skrini yewindi le-Notepad ++.

   

   Njengoba ungabona, amathegi wokuvula nokuvala alo mbhalo ayasebenza "isethi-setha". Indima efanayo emgqeni ngamunye ibonakala ithegi "irekhodi". Ngalolu hlelo kuyoba ngokwanele uma sithatha imigqa emibili etafuleni, futhi ngeke sihumushe ngokuzenzakalelayo ku-XML. Igama lamathegi wokuvulwa nokuvala kwekholomu kungabhekana, kodwa kulokhu, ukuze kube lula, sikhethe ukuhumusha amagama ekholomu olimi lwesiRashiya ngesiNgisi. Ngemuva kwedatha efakiwe, mane nje ulondoloze ngokusebenza komhleli wombhalo noma kuphi kwidiski yakho ephathekayo kwifomethi ye-XML ebizwa ngokuthi "i-schema".

5. Futhi, hamba ohlelweni lwe-Excel ngetafula evulekile kakade. Hambisa kuthebhu "Unjiniyela". On the tape ebhodini amathuluzi "XML" chofoza inkinobho "Umthombo". Ensimini evuliwe ngakwesokunxele kwefasitela chofoza inkinobho "Amamephu we-XML ...".



6. Ewindini evula, chofoza inkinobho "Engeza ...".



7. Iwindi lokukhetha umthombo iqala. Yiya ekuhlelweni kokuqondiswa kweskimu okuhlanganisiwe ngaphambili, ukhethe bese uchofoza inkinobho "Vula".



8. Ngemuva kokuthi izakhi ze-schema zivele efasiteleni, zihudula nge-cursor kumaseli ahambelana namagama ekholomu etafula.



9. Sichofoza ngakwesokudla kuthebula elilandelwe. Emenyu yomongo, isinyathelo ngesinyathelo "XML" futhi "Thekelisa ...". Ngemuva kwalokho, londoloza ifayela kunoma yiluphi uhla lwemibhalo.

Njengoba ubona, kunezindlela ezimbili eziyinhloko zokuguqula amafayela e-XLS ne-XLSX kufomethi ye-XML yi-Microsoft Excel. Okokuqala kulula kakhulu futhi kuqukethe inqubo eyisisekelo yokulondoloza ngesandiso esinikeziwe ngomsebenzi "Londoloza njengo ...". Ukulula nokucacile kwalolu khetho akusizi ngalutho izinzuzo. Kodwa unephutha elilodwa elikhulu kakhulu. Ukuguqulwa kwenziwa ngaphandle kokucabangela amazinga athile, ngakho-ke ifayela eliguqulwa ngale ndlela yizinhlelo zokusebenza zangaphandle zingase zingabonakali. Inketho yesibili ukudala imephu ye-XML. Ngokungafani nendlela yokuqala, itafula eliguqulwe ngokuvumelana nalolu hlelo lizohlangabezana nazo zonke izindinganiso zekhwalithi ze-XML. Kodwa, ngeshwa, akuwona wonke umsebenzisi oyokwazi ukuqonda ngokushesha ama-nuances ale nqubo.