Indlela ukutshintsha encoding e-Excel: 3 iindlela ezilula

Kunye nesidingo encoding utshintsho itekisi, abasebenzisi browsers umsebenzi, abahleli okubhaliweyo iziqhubekisi badla nazo. Noko ke, xa besebenza kwi-Table Excel iprosesa, imfuneko onjalo kwakhona zenzeka, ngenxa yokuba le nkqubo kwiinkqubo kuphela amanani, kodwa kwisicatshulwa. figure Masithethe ngaso ukutshintsha indlela enkhowudingi in Excele.

Isifundo: Ujiko eLizwini Microsoft

Sebenza umbhalo encoding

Usebenziso ngekhowudi Text - Le iseti amabinzana elektroniki digital ukuba zitshintshele kwabo uqondakale abalinganiswa umsebenzisi. Kukho iintlobo ezininzi ze encoding efana neyesicaka, nganye eneyazo imithetho yayo kunye nolwimi. Wobuchule yenkqubo ukuqaphela ulwimi oluthile nesiguqulela labo kuyaqondakala ukuba iimpawu umntu oqhelekileyo (oonobumba, amanani, abanye abalinganiswa) simisela ukuba esi sicelo uya kubanako na ukusebenza kunye itekisi ethile okanye hayi. Phakathi enkhowudingi umbhalo ethandwayo kufuneka kwabiwa ngolu hlobo lulandelayo:

• Windows-1251;
• Koi-8;
• ASCII;
• I-ANI;
• UKS-2;
• UTF-8 (Unicode).

Igama lokugqibela ngu eqhelekileyo kakhulu phakathi enkhowudingi ehlabathini, njengoko kuthathwa uhlobo standard jikelele.

Amaninzi, inkqubo ngokwayo kunakana encoding kwaye ngokuzenzekelayo sokuyivula kuyo, kodwa kwezinye iimeko umsebenzisi kufuneka ukhankanye inkangeleko yayo. kuphela ke isebenze ngokuchanekileyo kunye neesimboli iibhakhowudi.

Excel unenani inkulu ikhowudi iingxaki kunye neprogram ye-Excel xa uzama CSV evulekileyo okanye iifayile kumazwe TXT. Ngokufuthi, endaweni oonobumba yesiqhelo xa uvula ezi fayile nge Excel, sinako ukubona abalinganiswa ongaqondakaliyo, ebizwa njalo-"Crakozyabry". Kule meko, umsebenzisi kufuneka enze zazo ezithile ukwenzela ukuba inkqubo ukuqala ngokuchanekileyo ukubonisa data. Zininzi iindlela zokusombulula le ngxaki.

Indlela 1: Guqula kwi khowudi usebenzisa lokubhalela ++

Ngelishwa, isixhobo yinxalenye eya uvumele wena ukhethe ngokukhawuleza utshintshe i enkhowudingi kule naluphi na uhlobo iitekisi ezivela Excel. Ngoko ke, kuyimfuneko ukuba asebenzise izisombululo multi-benyathelo ezi njongo okanye asebenzise wesithathu-party uncedo na. Enye yeendlela enokuthenjwa ukusebenzisa yokubhala ++ umhleli wokubhaliweyo.

1. Baleka i yokubhala ++ isicelo. Cofa kwifayile "yefayile". Ukususela uluhlu yokuvula, khetha i "Open" umba. Njengoko enye indlela, uyakwazi ukucofa CTRL + O ikhibhodi yezitshixo.



2. Ifayile evulekileyo yefayile iqala. Yiya weefayili apho sibekwe uxwebhu, nto leyo siboniswe ngokungachanekanga Excele. We yiqaqambise uze nqakraza kwi "Open" iqhosha ngezantsi kwe window.



3. Ifayile ivulwa kwincwadana ye-Nottad ++ i-Emideri Window. Ezantsi kwefestile kwicala lasekunene lomtrikisi obonisileyo uxwebhu lwangoku. Ukusukela oko i-Excel ibonisa ngokungachanekanga, kuyafuneka ukwenza utshintsho. Siqalisa i-CTRL + umdibaniso ophambili kwikhibhodi ukuqaqambisa isicatshulwa sonke. Cofa kwindawo ethi "Chincong" yemenyu yemenyu. Kuluhlu oluvula, khetha i "Guqula kwi-UTF-8" into. Oku kukucocwa kuka-Unicode kunye ne-Excel yakhe kusebenza njengento echanekileyo kangangoko kunokwenzeka.



4. Emva koko, ukugcina utshintsho kwifayile ebonisa iqhosha kwibar yesixhobo ngendlela yediski yefloppy. Vala incwadana ++ Ngokucofa kwiqhosha njengomnqamlezo omhlophe kwisikwere esibomvu kwikona ephezulu yefestile.



5. Vula ifayile ngendlela eqhelekileyo ngomqhubi okanye usebenzisa naluphi na olunye ukhetho kwinkqubo ye-Excel. Njengoko ubona, bonke abalinganiswa ngoku babonisiwe ngokuchanekileyo.

Ngaphandle kwento yokuba le ndlela isekwe ekusebenziseni isoftware ye-par-quard, yenye yezona ndlela zilula zokuthengisa ezinokuthengiswa kweziqulatho zeefayile ze-Excel.

Indlela 2: Ukusetyenziswa kwe-Wizard yombhalo

Ukongeza, unokwenza uguqulo kwaye usebenzisa izixhobo ezakhelwe-kwiprogram, ezizezile i-Wizards yokubhaliweyo. Ngengaqhelekanga ngokwaneleyo, ukusetyenziswa kwesi sixhobo kunzima ngakumbi kunokusetyenziswa kwenkqubo yeqela lesithathu elichazwe kwiNdlela yangaphambili.

1. Qhuba inkqubo ye-Excel. Kuyimfuneko ukuvula isicelo ngokwaso, kwaye singavuli uxwebhu ngayo. Oko kukuthi, kuya kufuneka ubonakale iphepha elingenanto. Yiya kwi-"data" ithebhu. Cofa kwiqhosha kwi "ukusuka kwi-tepi" yetephu, ibekwe kwi-"ukufumana i-Tooling yedatha yangaphandle.



2. Ifestile yokungenisa ifayile ivula. Ixhasa ukuvulwa kwezi fom zilandelayo:
   • Txt;
   • Csv;
   • IPrn.

   Yiya kwisikhombisi sendawo yefayile engeniswayo, yikhethe kwaye ucofe iqhosha "lokungenisa".



3. Ifestile yombhalo i-Wizard ivuliwe. Njengoko sibona, kwicandelo lokujonga kwangaphambili, abalinganiswa baboniswe ngokungachanekanga. Kwi- "Ifomathi yeFayile", sibonisa uluhlu olusezantsi kwaye sitshintshe ikhowudi kwi "Unicode (i-UTF-8)" kuyo.

   

   Ukuba idatha ibonisiwe, kungachanekanga, emva koko zama ukuzama ukusebenzisa ezinye iikhowudi de kube le mbhalo kwicandelo lembonakalo yangaphambili ifundeka. Emva kokuba iziphumo ziyanelisa, cofa iqhosha "elilandelayo".



4. Le wizard yeWizard ilandelayo ivula. Apha unokutshintsha umqondiso wesahlulo, kodwa kuyacetyiswa ukuba ushiye useto olungagqibekanga (uphawu lwethebhu). Cofa kwiqhosha "elilandelayo".



5. Le window wokugqibela uyakwazi ukutshintsha ifomati kwikholam data:
   • Jikelele;
   • yobhalo;
   • Umhla;
   • Tsiba column.

   Apha izicwangciso kufuneka zimiselwe, banikwe uhlobo umxholo zigqithiswe. Emva koko, siya cinezela iqhosha "Gqiba".



6. Kwi window elilandelayo, ungakhankanya uququzelelo kwebanga ekhohlo eliphezulu uluhlu kwimakhishithi apho idatha ifakiwe. Oku kunokwenziwa uqhuba idilesi ngesandla endle efanelekileyo okanye bonisa nje iseli oyifunayo kwimakhishithi. Emva kokuba zika zongezwa, entsimini Window, klikha iqhosha "Kulungile".



7. Emva koko, okubhaliweyo iya kuvela iphepha ku nokhowudo esiyifunayo. Kuhleli zokufomatha okanye ukubuyisela isakhiwo itafile, ukuba oko data tabular, njengokuba kubhaliwe kutshabalala xa fomato kwakhona.

Indlela 3: Ukulondoloza i ifayile kwindawo ethile i enkhowudingi

Kukho kwakhona imeko reverse xa ifayile kufuneka aliyi kuvulwa kunye ukubonisa idatha echanekileyo, kwaye gcina i encoding efakiweyo. Ngo-Excel, uyakwazi ukwenza lo msebenzi.

1. Yiya kwi "Ifayile" yethebhu. Nqakraza kwi "Gcina Njenge".



2. Ifestile yokugcina uxwebhu ivuliwe. Ukusebenzisa esibonakalayo umqhubi, thina ezichaza weefayili apho ifayile iya kugcinwa. Emva koko wabeka uhlobo lwefayile ukuba sifuna ukugcina ncwadi ezahlukeneyo ifomathi standard fomathi ye-Excel (XLSX). Ndaza nqakraza kwi "Service" parameter kwaye kuluhlu ovula, khetha i "uxwebhu parameters Web" umba.



3. Kwi window evulayo, yiya kwi "ikhodi" tab. Kwi "Gcina Uxwebhu njenge" intsimi, vula i drop-phantsi uluhlu wabukhangelisa nohlobo ikhowudi ukusuka kuluhlu, esinokucinga kuyimfuneko. Emva koko, cofa kwiqhosha "Kulungile".
4. Ukubuyela i "Document Save" window silapha klikha kwiqhosha u- "Save".

Olu xwebhu uya kusindiswa kwi idiski eqinileyo okanye imidiya ayinakususwa kwindawo encoding sele umfumene. Kodwa kufuneka ucinge ukuba ngoku kusoloko amaxwebhu agcinwe Excel uya kusindiswa kule encoding. Ukuze kuyitshintsha le, kuya kufuneka uye kwi 'uxwebhu Web "window kwaye utshintshe useto.

Kukho nenye indlela ukutshintsha useto enkhowudingi okubhaliweyo basindiswe.

1. Ukuba i "Wefayile" tab, nqakraza kwi "Iparameters".



2. Ifestile ye-Excel Parameter ivula. Khetha ntsongo "Ngaphezu koko" kuluhlu ibekwe kwicala lasekhohlo lwe window. Inxalenye engundoqo ye window urholela phantsi kwi "Jikelele" Useto block. Apha klikha kwiqhosha "Web Page Izilungiselelo".



3. I 'Web Document Iparameters "window ivula, apho senza zonke iintshukumo ezifanayo ukuba babethetha ngaphambili.

Ngoku naluphi na uxwebhu olugcinwe kwi-Excel luya kuba ngqo kwikhowudi oyifakileyo.

Njengoko ubona, i-Excel ingenasixhobo esinokukuvumela ukuba uguqule ngokukhawuleza nangokufanelekileyo okubhaliweyo kwikhowudi enye ukuya kwenye. Inkosi yesicatshulwa inobungozi kakhulu kwaye inamathuba amaninzi okungafunekiyo kwinkqubo enjalo. Ukuyisebenzisa, kuyakufuneka uphumelele amanyathelo ambalwa, ethe ngqo kule nkqubo ayichaphazeli, kwaye ukhonze ezinye iinjongo. Nditsho nokuguqula inqaku lomhleli wesithathu lomhleli ++ kule meko ibonakala ilula. Ukugcina iifayile kwikhowudi enikiweyo kwisicelo se-Excel kuqhutywa yinto yokuba ngalo lonke ixesha unqwenela ukutshintsha le paraerter, kuya kufuneka utshintshe useto lwehlabathi lenkqubo.