Ukuxazulula "Ukusebenza okufunayo kudinga ukukhushulwa" ku-Windows 10

Isidingo sokushintsha ikhodi yombhalo ngokuvamile kubhekene nabasebenzisi bephequluli abasebenzayo, abahleli bombhalo nabacubungula. Kodwa-ke, uma usebenza kwiprosesa ye-Excel spreadsheet, isidingo esinjalo singase siphakamise, ngoba lolu hlelo alusebenzi izinombolo kuphela, kodwa futhi lombhalo. Ake sibone ukuthi singashintsha kanjani ukufaka ikhodi ku-Excel.

Isifundo: I-Microsoft Word Encoding

Sebenza ngombhalo wokufaka ikhodi

Ukukhonjwa kombhalo yiqoqo lezinkulumo zezinombolo ze-elektroniki eziguqulwa zibe izinhlamvu zomsebenzisi. Kunezinhlobo eziningi ze-encoding, ngayinye yayo inezimiso zayo kanye nolwimi. Ikhono lenqubo yokubona ulimi oluthile futhi lihumushe libe yizinhlamvu eziqondakalayo kumuntu ovamile (izinhlamvu, izinombolo, ezinye izinhlamvu) inquma ukuthi uhlelo lokusebenza lungasebenza ngombhalo othize noma cha. Phakathi kwezikhombisi zemiyalezo ethandwayo kufanele ziqokomise lokhu okulandelayo:

• Windows-1251;
• I-KOI-8;
• ASCII;
• I-ANSI;
• I-UKS-2;
• I-UTF-8 (i-Unicode).

Igama lokugcina yilona elivame kakhulu phakathi kwama-encodings emhlabeni, njengoba kubhekwa njengendlela ejwayelekile yendawo yonke.

Ngokuvamile, lolu hlelo ngokwalo luyaqaphela ikhodi bese luyishintsha ngokuzenzakalelayo, kodwa kwezinye izimo umsebenzisi kudingeka akhombise ukuthi uhlelo lokusebenza lubukeka kanjani. Kuphela-ke kungasebenza kahle ngezinhlamvu ezifakiwe.

Inkinga enkulu kunazo zonke ekukhonjisweni kwe-encoding ye-Excel Uhlelo kwenzeka uma ezama ukuvula amafayela we-CSV noma amafayela we-txt okuthekelisa. Ngokuvamile, esikhundleni sezincwadi ezijwayelekile uma uvula lawa mafayela nge-Excel, singabona izimpawu ezingenakuqondakala, okuthiwa "ukuphahlazeka". Kulezi zimo, umsebenzisi udinga ukwenza okuthile ukuze uhlelo luqale ukubonisa idatha ngendlela efanele. Kunezindlela eziningana zokuxazulula le nkinga.

Indlela 1: Shintsha ikhodidi usebenzisa i-Notepad ++

Ngeshwa, i-Excel ayinalo ithuluzi eligcwele elizovumela ukushintsha ngokushesha ikhodidi kunoma yiluphi uhlobo lwombhalo. Ngakho-ke, kuyadingeka ukusebenzisa izixazululo eziningi zezinyathelo zalolu daba noma ukusebenzisa ukusebenzisa izinhlelo zokusebenza zangaphandle. Enye yezindlela ezinokwethenjelwa kakhulu ukusebenzisa i-Notepad ++ yomhleli wombhalo.

1. Qalisa i-Notepad ++ yesicelo. Chofoza entweni "Ifayela". Kusukela ohlwini oluvula, khetha into "Vula". Ngokunye, ungathayipha isinqamuleli sekhibhodi Ctrl + O.



2. Iwindi lefayela elivulekile liqala. Iya kusiqondisi lapho idokhumenti itholakala, engaboniswa ngendlela engafanele ku-Excel. Khetha bese uchofoza inkinobho. "Vula" phansi kwefasitela.



3. Ifayela livula iwindi le-Notepad ++. Ngaphansi kwefasitela ngakwesokudla kwesigcawu sesimo yikhodi yamanje yamadokhumenti. Njengoba i-Excel ibonisa ngokungalungile, udinga ukwenza izinguquko. Siyiphayipha inhlanganisela yokhiye Ctrl + A kwikhibhodi ukhethe wonke umbhalo. Chofoza kwimenyu yemenyu "Izinkomba". Kulolu hlu oluvula, khetha into "Guqulela ku-UTF-8". Lokhu kuyi-encoding ye-Unicode ne-Excel isebenza nayo ngendlela efanele ngangokunokwenzeka.



4. Emva kwalokho, ukuze ulondoloze izinguquko efayeleni, chofoza inkinobho kubha yamathuluzi ngendlela ye-floppy disk. Vala i-Notepad ++ ngokuchofoza inkinobho ngesimo sesiphambano esimhlophe esigcawini esifomvu ekhoneni elingenhla kwesokudla kwewindi.



5. Vula ifayela ngendlela ejwayelekile nge-Explorer noma usebenzisa noma iyiphi enye inketho ku-Excel. Njengoba ubona, bonke abalingiswa manje baboniswa ngendlela efanele.

Naphezu kokuthi le ndlela isekelwe ekusetshenzisweni kwesofthiwe yangaphandle, kungenye yezindlela ezilula zokulungisa okuqukethwe kwamafayela ngaphansi kwe-Excel.

Indlela 2: Sebenzisa i-Wizard Text

Ngaphezu kwalokho, ungenza ukuguqulwa usebenzisa amathuluzi akhiwe ngaphakathi kohlelo, okuyi-Text Wizard. Ngokumangalisayo, ukusetshenziswa kwalolu thuluzi kunzima kakhulu kunokuba kusetshenziswe uhlelo lwesithathu oluchazwe ngendlela eyedlule.

1. Qalisa uhlelo lwe-Excel. Udinga ukucupha uhlelo lokusebenza ngokwayo, futhi ungavuli idokhumenti ngalo. Okungukuthi, ngaphambi kokuthi ubonakale ushicilelwe lutho. Iya kuthebhu "Idatha". Chofoza inkinobho ku-tape "Kusukela embhalweni"efakwe ebhodini lamathuluzi "Ukuthola Idatha Yangaphandle".



2. Iwindi lefayela lokungenisa ifayela livula. Isekela ukuvula amafomethi alandelayo:
   • I-Txt;
   • CSV;
   • I-PRN.

   Yiya endaweni yefayela elifakiwe, ukhethe bese uchofoza inkinobho "Ngenisa".



3. I-Text Wizard ivulwa. Njengoba ubona, kumkhakha wokubuka kuqala, izinhlamvu zikhonjiswa ngokungalungile. Ensimini "Ifomethi yefayela" sivula uhlu lokudonsa phansi futhi sishintsha ikhodi kukho kuso "Unicode (UTF-8)".

   

   Uma idatha isaboniswa ngokungalungile, sizama ukuzama ukusebenzisa ezinye izikhombisi, kuze kube yilapho umbhalo ku-field preview ufundeka. Ngemuva kokuthi umphumela ukwanelise, chofoza inkinobho. "Okulandelayo".



4. Iwindi yombhalo wizard elandelayo ivula. Lapha ungashintsha uhlamvu lomhlukanisi, kodwa kunconywa ukuba ushiye izilungiselelo ezizenzakalelayo (ithebhu). Sicindezela inkinobho "Okulandelayo".



5. Ewindini lokugcina kungenzeka ukushintsha ifomethi yedatha yekholomu:
   • Okuvamile;
   • Umbhalo;
   • Usuku;
   • Yeqa ikholomu.

   Lapha izilungiselelo kufanele zisethwe, kunikezwe uhlobo lokuqukethwe okucutshungulwayo. Emva kwalokho, chofoza inkinobho "Yenzelwe".



6. Ewindini elilandelayo, sibonisa izixhumanisi zeseli eliphezulu elingakwesokunxele ebangeni eshadini lapho idatha izofakwa khona. Lokhu kungenziwa ngokuthayipha ikheli ngesandla esimweni esifanele noma ngokukhetha iseli elifunayo kushidi. Ngemuva kokuthi izixhumanisi zengeziwe, chofoza inkinobho emkhakheni wewindi "Kulungile".



7. Emva kwalokho, umbhalo uzoboniswa eshidi ku-encoding oyifunayo. Isele ukuyifometha noma ukubuyisela isakhiwo setafula, uma bekuyimininingwane yamathebhu, njengoba ibhujiswa lapho ishintsha kabusha.

Indlela ye-3: londoloza ifayela ku-encoding ethile

Kukhona nesimo esivumelanayo uma ifayela kufanele lingavulwa ngokuboniswa kwedatha efanele, kodwa kulondolozwe ku-encoding yesethi. Ku-Excel, ungenza lo msebenzi.

1. Iya kuthebhu "Ifayela". Chofoza entweni "Londoloza".



2. Iwindi yedokhumenti yokulondoloza ivula. Ukusebenzisa i-interface ye-Explorer, sichaza isiqondisi lapho ifayela lizogcinwa khona. Bese sibeka uhlobo lwefayili uma sifuna ukulondoloza le ncwadi ngesakhiwo ngaphandle kwefomethi ejwayelekile ye-Excel (xlsx). Bese uchofoza kupharamitha "Isevisi" futhi ohlwini oluvula, khetha into "Izilungiselelo Zedokhumenti Yewebhu".



3. Ewindini evula, iya kuthebhu "Ukubhala ngekhodi". Ensimini "Londoloza Idokhumenti Njengoba" vula uhlu lokudonsa phansi bese usethe ohlwini oluthile uhlobo lokufaka ikhodi esiyibheka kuyadingeka. Emva kwalokho, chofoza inkinobho "Kulungile".



4. Sibuyela ewindini "Londoloza Idokhumenti" bese uchofoza inkinobho "Gcina".

Le dokhumenti izolondolozwa kwi-disk eyinkimbinkimbi noma emithonjeni ekhishwayo ekukhokheni okuzichazile ngokwakho. Kodwa khumbula ukuthi manje yonke imibhalo egcinwe ku-Excel izogcinwa kule khodi. Ukuze ushintshe lokhu, kufanele uphinde uphume efasiteleni. "Izilungiselelo Zedokhumenti Yewebhu" futhi ushintshe izilungiselelo.

Kukhona enye indlela yokuguqula izilungiselelo zekhowudi yombhalo ogciniwe.

1. Ukuba ngaphakathi kuthebhu "Ifayela", chofoza entweni "Izinketho".



2. Iwindi ye-Excel ivula. Khetha i-sub "Okuthuthukisiwe" kusuka ohlwini olunehlangothini lwesobunxele lwewindi. Ingxenye eyinhloko yefasitela phenya phansi kuya kuzilungiselelo ze-block "Jikelele". Lapha sichofoza inkinobho "Izinketho Zekhasi Lewebhu".



3. Ifasitela esivele sijwayele kithi ivula. "Izilungiselelo Zedokhumenti Yewebhu"lapho senza khona zonke izenzo ezifanayo esizikhulume ngaphambili.



Manje noma iyiphi idokhumenti egcinwe ku-Excel izoba nekhodi ecacile oyifakile.

Njengoba ubona, i-Excel ayinayo ithuluzi elizokuvumela ukuba uguqule umbhalo ngokushelela futhi ngokushelelayo ngokukhipha ikhodi eyodwa kuya kwenye. I-wizard yombhalo inokusebenza okunamandla futhi inezici eziningi ezingadingekile kule nqubo. Ukusebenzisa, kufanele uhambe ngezinyathelo eziningana ezingathinti ngqo le nqubo, kodwa usebenzise ezinye izinjongo. Ngisho nokuguqulwa komhleli we-third party party Notepad ++ kubonakala kulula kulokhu. Ukulondoloza amafayela ekukhokheni okunikeziwe ku-Excel kuyinkimbinkimbi nokuthi njalo uma ufuna ukushintsha le parameter, kuzodingeka ushintshe izilungiselelo zomhlaba zohlelo.