Isidingo sokuguqula ithebula ngezandiso ze-HTML kumafomethi e-Excel zingenzeka ezimweni ezehlukene. Kungadingeka ukuguqula lawa makhasi wewebhu kusuka kuma-intanethi noma kumafayela e-HTML asetshenziselwa endaweni yangakini nezinye izidingo ngezinhlelo ezikhethekile. Ngokuvamile benza ukuguqulwa kokuthutha. Okusho ukuthi, baqala ukuguqula itafula kusuka ku-HTML kuya ku-XLS noma i-XLSX, bese uyiyilungisa noma uyihlele, bese uyiguqulela efayeleni ngokukhuliswa okufanayo futhi ukwenza umsebenzi wayo wokuqala. Lokhu kungenxa yokuthi kulula kakhulu ukusebenza namatafula ku-Excel. Ake sithole indlela yokuhumusha itafula kusuka ku-HTML kuya ku-Excel.
Bheka futhi: Indlela yokuhumusha i-HTML eZwini
I-HTML eya ku-Excel Inqubo Yokuguqulwa
Ifomethi ye-HTML ingulimi lwe-markup hypertext. Izinto ezinalesi sandiso zivame ukusetshenziselwa ku-Intanethi njengamakhasi e-static web. Kodwa kaningi futhi angasetshenziselwa izidingo zendawo, isibonelo, njengemibhalo yokusiza yezinhlelo ezihlukahlukene.
Uma lo mbuzo uvela ekuguquleni idatha kusuka kumafomu we-HTML kuya ku-Excel, okuyi-XLS, XLSX, XLSB noma i-XLSM, khona-ke umsebenzisi ongenalwazi angathatha ikhanda lakhe. Kodwa empeleni, akukho lutho olwesabekayo alukho lapha. Ukuguqula ezinguqulweni zanamuhla ze-Excel namathuluzi akhiwe ngaphakathi kohlelo kulula futhi ezimweni eziningi zilungile. Ngaphezu kwalokho, singasho ukuthi inqubo ngokwayo inembile. Kodwa-ke, ezimweni ezinzima, ungasebenzisa izinsiza zomuntu wesithathu ukuguqulwa. Ake sibheke izinketho ezahlukene zokuguqula i-HTML ku-Excel.
Indlela 1: sebenzisa izinhlelo zenkampani yangaphandle
Masinyane sigxile ekusetshenzisweni kwezinhlelo zezinkampani zangaphandle ukudlulisa amafayela kusuka ku-HTML kuya ku-Excel. Izinzuzo zalolu khetho yizo zesevisi ezikhethekile ezikwazi ukubhekana nokuguqula izinto eziyinkimbinkimbi kakhulu. Okungalungile ukuthi iningi lawo likhokhwa. Ngaphezu kwalokho, okwamanje cishe zonke izinketho ezifanelekayo zikhuluma isiNgisi ngaphandle kweRussia. Ake sicabangele i-algorithm yomsebenzi kwelinye lezinhlelo ezilula kakhulu zokwenza isiqondiso saphezulu sokuguqulwa - Abex HTML ku-Excel Converter.
Landa i-Abex HTML ku-Excel Converter
- Ngemuva kokuba i-Abex HTML kuya ku-Excel Converter isifaki ilayishwe, yiqalise ngokuchofoza kabili ngenkinobho yegundane lesokunxele. Isifaki sokwamukela isikrini sivula. Chofoza inkinobho "Okulandelayo" ("Okulandelayo").
- Ngemva kwalokhu, iwindi ivula isivumelwano selayisense. Ukuze uvumelane naye, kufanele ubeke inkinobho endaweni "Ngiyamukela isivumelwano" bese uchofoza inkinobho "Okulandelayo".
- Emva kwalokho, iwindi livuleka lapho likhombisa khona ukuthi lolu hlelo luzofakwa kuphi. Yebo, uma ufisa, ungashintsha isiqondisi, kodwa akunconywa ukwenza lokhu ngaphandle kwesidingo esikhethekile. Ngakho chofoza nje inkinobho. "Okulandelayo".
- Iwindi elilandelayo libonisa igama lohlelo oluboniswe kwimenyu yokuqala. Napha futhi, ungakwazi ukumane uchofoze inkinobho ethi "Okulandelayo".
- Iwindi elilandelayo liphakamisa ukusetha isithonjana sosizo kudeskithophu (inikwe amandla ngokuzenzakalelayo) nakwebhu yokuqalisa esheshayo ngokuhlola amabhokisi okuhlola. Sabeka lezi zilungiselelo ngokuvumelana nezintandokazi zethu bese uchofoza inkinobho. "Okulandelayo".
- Ngemuva kwalokho, ifasitela iqaliswa, efingqa yonke imininingwane mayelana nazo zonke lezo zilungiselelo zokufaka uhlelo lomsebenzisi ezenziwe ngaphambilini. Uma umsebenzisi enganelisekanga ngento ethile, angachofoza inkinobho. "Emuva" futhi wenze izilungiselelo ezifanele zokuhlela. Uma evumelana nakho konke, bese uqala ukufakwa, chofoza inkinobho "Faka".
- Kukhona inqubo yokufaka insiza.
- Ngemva kokuqedela, iwindi liqaliswe lapho libikwa khona. Uma umsebenzisi efuna ukuqala ngokuzenzakalelayo uhlelo ngokuzenzakalelayo, kufanele aqinisekise ukuthi "Qala i-Abex HTML ku-Excel Converter" uphawu lubekwe. Uma kungenjalo, udinga ukususa. Ukuze uphume iwindi lokufaka, chofoza inkinobho. "Qedela".
- Kubalulekile ukwazi ukuthi ngaphambi kokuthi uqalise i-Abex HTML ku-Excel Converter yesevisi, kungakhathaliseki ukuthi kwenziwa kanjani ngesandla noma ngokushesha ngemuva kokufaka isicelo, kufanele uvale futhi uvale zonke izinhlelo ze-Microsoft Office suite. Uma ungenzi lokhu, khona-ke uma uzama ukuvula i-Abex HTML ku-Excel Converter, iwindi izovuleka, ikutshele ukuthi udinga ukwenza le nqubo. Ukuya ukusebenza ne-Umbuso, kuzomele uchofoze kule nkinobho kule window. "Yebo". Uma ngesikhathi esifanayo amahhovisi ehhovisi evulekile, khona-ke umsebenzi kuzo kuzophothulwa ngokuqinile, futhi yonke idatha engalondoloziwe ilahlekile.
- Khona-ke iwindi lokubhalisa lizoqaliswa. Uma uthola ukhiye wokubhalisa, khona-ke ezinkambeni ezihambelanayo udinga ukungena inombolo kanye negama lakho (ungasebenzisa i-alias), bese ucindezela inkinobho "Bhalisa". Uma ungakathengi ukhiye okwamanje futhi ufuna ukuzama inguqulo yokusika yesicelo, bese kulesi cala uchofoze inkinobho kuphela "Ngikhumbuze kamuva".
- Ngemuva kokusebenzisa izinyathelo ezingenhla, iwindi le-Abex HTML kuya ku-Excel Converter iqala ngokuqondile. Ukwengeza ifayela le-HTML lokuguqulwa, chofoza inkinobho. "Engeza amafayela".
- Emva kwalokho, iwindi lefayili engeza livula. Kuyo kufanele uhambe esigabeni lapho izinto ezihloselwe ukuguqulwa zitholakala. Bese udinga ukuwakhetha. Inzuzo yale ndlela ngaphezu kokuguqulwa kwe-HTML evamile kuya ku-Excel ukuthi ungakhetha futhi uguqule izinto eziningana ngesikhathi esisodwa. Ngemuva kokuthi amafayela akhethiwe, chofoza inkinobho "Vula".
- Izinto ezikhethiwe zizoboniswa efasiteleni elikhulu losizo. Ngemuva kwalokho, chofoza inkambu engezansi kwesokunxele ukuze ukhethe eyodwa yamafomethi amathathu e-Excel ongayishintsha ifayela:
- I-Xls (okuzenzakalelayo);
- Xlsx;
- I-XLSM (enokusekelwa kwe-macro).
Ukwenza ukukhetha.
- Emva kwalokho iya ezilungiselelweni zokuvimba "Ukuhlelwa kokukhipha" ("Ukusethwa kokukhipha"). Lapha kufanele ucacise ngqo lapho izinto eziguquliwe zizogcinwa khona. Uma ufaka inkinobho endaweni "Londoloza amafayela noma amafayela atholakala kufolda yomthombo", khona-ke itafula lizogcinwa kusiqondisi esifanayo lapho umthombo usefomethi ye-HTML. Uma ufuna ukulondoloza amafayela kwifolda ehlukile, ngakho-ke kufanele uhambise inkinobho endaweni "Yenza ngokwezifiso". Kulokhu, ngokuzenzakalelayo, izinto zizogcinwa kufolda "Umkhiqizo"okuyinto futhi itholakala esiqondisweni somsuka wediski C.
Uma ufuna ukucacisa indawo ukugcina into, kufanele uchofoze inkinobho ekhona ngakwesokudla kwendawo yekheli.
- Ngemuva kwalokho, ifasitela ivula ngokubukezwa kwamafolda. Udinga ukuhambisa kwisiqondisi ofuna ukukwabela indawo yokulondoloza. Bese uchofoza inkinobho. "Kulungile".
- Ngemuva kwalokho, ungaqhubeka ngqo nenqubo yokuguqulwa. Ukuze wenze lokhu, chofoza inkinobho ephaneli eliphezulu. "Guqula".
- Khona-ke inqubo yokuguqulwa iyokwenziwa. Ngemva kokuqedela, iwindi elincane lizovuleka, likukwazise ngalokhu, futhi liqalise ngokuzenzakalelayo I-Windows Explorer ku-directory lapho amafayela e-Excel aguquliwe atholakalayo. Manje ungenza noma yikuphi okunye ukusebenzisana nabo.
Kodwa sicela uqaphele ukuthi uma usebenzisa inguqulo yokuhlola yamahhala yosizo, ingxenye kuphela yedokhumenti izoguqulwa.
Indlela 2: Guqula ngokusebenzisa amathuluzi ajwayelekile we-Excel
Kulula futhi ukuguqula ifayela le-HTML kunoma iyiphi i-Excel ifomethi usebenzisa amathuluzi avamile yalolu hlelo lokusebenza.
- Run Excel bese uya kuthebhu "Ifayela".
- Ewindini evula, chofoza igama "Vula".
- Ngemva kwalokhu, iwindi lefayela elivulekile liqalisiwe. Udinga ukuya esiqondisweni lapho ifayela le-HTML likhona okufanele liguqulwe khona. Kulesi simo, enye yemingcele elandelayo kufanele isethwe kumkhakha wefomethi yefayili kule window:
- Wonke amafayela we-Excel;
- Wonke amafayela;
- Wonke amakhasi ewebhu.
Kule ndaba kuphela ifayela esiyidingayo lizobonakala efasiteleni. Khona-ke kudingeka ukhethe futhi uchofoze inkinobho. "Vula".
- Emva kwalokho, itafula ngefomethi ye-HTML izoboniswa efelini le-Excel. Kodwa akusikho konke. Sidinga ukulondoloza idokhumenti ngendlela efanele. Ukuze wenze lokhu, chofoza isithonjana ngesimo sediski ekhoneni eliphezulu elingakwesokunxele kwewindi.
- Iwindi evuleka lapho lithi khona idokhumenti ekhona ingase ibe nezici ezingahambelani nefomethi yekhasi lewebhu. Sicindezela inkinobho "Cha".
- Emva kwalokho, iwindi lefayela lokulondoloza livula. Yiya esiqondisweni lapho sifuna ukukubeka khona. Khona-ke, uma ufisa, shintsha igama lwedokhumenti ensimini "Igama lefayela", nakuba kungashiywa okwamanje. Okulandelayo, chofoza ensimini "Uhlobo lwefayela" bese ukhetha enye yamafayela wefayela le-Excel:
- Xlsx;
- I-Xls;
- Xlsb;
- Xlsm.
Uma zonke izilungiselelo ezingenhla seziqedile, chofoza inkinobho. "Gcina".
- Ngemuva kwalokho, ifayela lizogcinwa ngesandiso esikhethiwe.
Kukhona futhi elinye ithuba lokuya efasiteleni elondolozayo.
- Hambisa kuthebhu "Ifayela".
- Yiya ewindini elisha, chofoza entweni kwimenyu yokuma kwesokunxele "Londoloza".
- Emva kwalokho, iwindi lwedokhumenti elondolozayo liqalisiwe, futhi zonke izenzo ezengeziwe zenziwa ngendlela efanayo njengoba kuchazwe kunguqulo yangaphambilini.
Njengoba ubona, kulula kakhulu ukuguqula ifayela kusuka ku-HTML kuya kwelinye lamafomu e-Excel usebenzisa amathuluzi ajwayelekile alolu hlelo. Kodwa labo abasebenzisi abafisa ukuthola amathuba engeziwe, ngokwesibonelo, ukukhiqiza ukuguqulwa kwenqwaba yezinto esiqondisweni esicacisiwe, bangacelwa ukuthi bathenge enye yezinsiza ezikhokhelwayo ezikhethekile.