Qhov yuav tsum tau hloov qhov encoding ntawm cov ntawv nyeem yog feem ntau ntsib cov neeg siv haujlwm browsers, text editors thiab processors. Txawm li cas los xij, thaum ua hauj lwm hauv ib qho Excel spreadsheet processor, cov kev xav tau kuj tuaj yeem tshwm sim tau, vim tias qhov kev pab cuam no tsuas tsis yog cov naj npawb, tab sis kuj yog cov ntawv nyeem. Cia peb xam seb yuav hloov cov encoding hauv Excel.
Tshooj: Microsoft lo lus Encoding
Ua haujlwm nrog cov ntawv nyeem encoding
Cov ntawv sau tawm yog ib phau ntawm cov zauv hauv lej uas hloov dua siab tshiab rau hauv tus neeg siv cov cim. Muaj ntau hom kev encoding, txhua yam uas muaj nws cov cai thiab cov lus. Lub peev xwm ntawm qhov kev zov me nyuam kom pom ib hom lus thiab txhais nws ua cov cim to taub zoo rau tus neeg zoo tib yam (ntawv, zauv, lwm tus cim) txiav txim siab seb tus ntawv thov ua haujlwm nrog cov ntawv nyeem lossis tsis tau. Ntawm qhov nrov ntawv encodings yuav tsum tau nthuav cov hauv qab no:
- Windows-1251;
- KOI-8;
- ASCII;
- ANSI;
- UKS-2;
- UTF-8 (Unicode).
Lub tom kawg lub npe yog qhov tshaj plaws ntawm cov cim npe nyob hauv lub ntiaj teb, raws li nws raug xam tias yog ib yam ntawm tus txheej txheem universal.
Feem ntau, qhov kev zov me nyuam nws tus kheej paub txog qhov kev tso cai thiab kev siv tau rau nws, tab sis qee tus neeg siv yuav tsum tau qhia rau daim ntawv thov nws qhov tsos. Tsuas yog tom qab ntawd nws tuaj yeem ua haujlwm nrog cov cim cim.
Qhov loj tshaj ntawm cov teeb meem nrog kev daws teeb meem ntawm qhov kev pab cuam ntawm Excel tshwm sim thaum sim qhib CSV cov ntaub ntawv los sis xa cov ntaub ntawv txt tawm. Feem ntau, tsis yog cov ntawv sau li ib txwm thaum qhib cov ntaub ntawv no los ntawm Excel, peb tuaj yeem soj ntsuam cov lus cim tsis pom kev, yog li ntawd hu ua "cracks". Nyob rau cov teebmeem no, tus neeg siv yuav tsum tau ua qee cov kev tswjhwm hauv kev txiav txim rau qhov kev zov me nyuam kom pib tso cov ntaub ntawv kom raug. Muaj ntau txoj hauv kev los daws qhov teeb meem no.
Txoj kev cai 1: Hloov qhov kev siv cov Lus Ceeb Toom siv Ceeb Toom
Hmoov tsis, Excel tsis muaj lub cuab tam puv ntoob uas yuav tso cai rau hloov qhov encoding rau txhua hom ntawv. Yog li ntawd, nws yuav tsum siv cov kev daws teeb meem ntau rau lub hom phiaj no los yog mus rau qhov chaw siv los siv cov ntawv tso npe thib peb. Ib qho ntawm feem kev txhim khu kev qha yog siv cov ntawv luam editor Notepad ++.
- Khiav daim ntawv thov Notepad ++. Nias ntawm yam khoom "Cov Ntaub Ntawv". Ntawm daim ntawv qhib, xaiv qhov khoom "Qhib". Raws li ua lwm yam, koj tuaj yeem ntaus cov keyboard shortcut Ctrl + O.
- Lub pib qhib qhov rai pib. Mus rau ntawm qhov chaw uas cov ntaub ntawv nyob, uas yog incorrectly tso tawm hauv Excel. Xaiv nws thiab nyem rau ntawm lub pob. "Qhib" nyob hauv qab ntawm qhov rais.
- Cov ntaub ntawv yuav qhib rau hauv Notepad ++ editor qhov rai. Nyob hauv qab ntawm lub qhov rais ntawm sab xis ntawm tus txheej xwm bar yog tam sim no encoding ntawm daim ntawv. Vim tias Excel qhia nws tsis yog, koj yuav tsum hloov. Peb ntaus lub ntsiab ua ke Ctrl + A ntawm cov keyboard los xaiv tag nrho cov ntawv nyeem. Nias rau ntawm daim ntawv qhia zaub mov "Encodings". Nyob rau hauv cov npe uas tau qhib, xaiv qhov khoom "Hloov mus rau UTF-8". Qhov no yog Unicode encoding thiab Excel ua hauj lwm nrog nws raws li thwj li sai tau.
- Tom qab ntawd, txhawm rau txuag cov kev hloov hauv cov ntaub ntawv, nias ntawm lub pob ntawm qhov toolbar nyob hauv daim ntawv ntawm lub tshuab floppy. Xoom Notepad + nias rau ntawm lub khawm hauv daim ntawv ntawm tus ntoo khaub lig dawb hauv lub koog liab liab nyob rau sab pem hauv ntej ntawm lub qhov rais.
- Qhib cov ntaub ntawv hauv txoj kev txheem ntawm Explorer lossis siv lwm txoj kev xaiv hauv Excel. Raws li koj tau pom, tag nrho cov cim tam sim no tso tawm kom pom.
Dua li ntawm qhov tseeb tias hom no yog ua raws li kev siv qhov kev pabcuam thib peb, nws yog ib qho kev yooj yim rau recoding tus txheem ntawm cov ntaub ntawv hauv Excel.
Txoj kev 2: Siv cov ntawv Wizard
Tsis tas li ntawd, koj tuaj yeem ua qhov hloov dua siab tshiab uas siv cov cuab yeej built-in ntawm qhov kev pabcuam, uas yog cov Ntawv Teev Suab. Oddly txaus, kev siv ntawm qhov cuab yeej no yog me ntsis nyuab tshaj qhov siv qhov kev pabcuam thib peb uas tau hais tseg hauv cov qauv yav dhau los.
- Khiav qhov kev pab cuam Excel. Koj yuav tsum qhib daim ntawv thov nws tus kheej, thiab tsis qhib ib daim ntawv nrog nws. Ntawd yog, ua ntej koj yuav tsum tau sau daim ntawv dawb. Mus rau lub tab "Cov ntaub ntawv". Nias rau lub pob ntawm daim kab xev "Los ntawm cov ntawv nyeem"muab tso rau hauv ib lub block ntawm cov cuab yeej "Qhia lwm cov ntaub ntawv".
- Cov ntawv luam tawm cov ntaub ntawv ntshuam window opens. Nws txhawb nqa qhib cov hom nram qab no:
- Txt;
- CSV;
- PRN.
Mus rau qhov chaw ntawm cov ntaub ntawv xa tuaj, xaiv nws thiab nyem rau ntawm lub pob "Ntshuam".
- Cov ntawv Wizard opens. Raws li koj tau pom, hauv daim teb saib ua ntej, cov cim sau qhia yuam kev. Hauv teb "Ua Ntawv Thov" peb qhib lub npe sau tseg thiab hloov cov cim npe rau hauv "Unicode (UTF-8)".
Yog hais tias cov ntaub ntawv tseem tso tawm incorrectly, ces peb sim mus xyaum ua tej yam kev siv lwm cov encodings, kom txog rau thaum cov ntawv nyeem nyob rau hauv lub teb saib ua ntej yuav tshwmsim. Tom qab cov txiaj ntsig kom txaus rau koj, nias ntawm lub pob. "Tom ntej".
- Cov ntaub ntawv nram qab no wizard opens. Ntawm no koj tuaj yeem hloov qhov cim ua cim separator, tab sis nws pom zoo kom tawm hauv qhov chaw tso tawm (tab). Peb nias lub khawm "Tom ntej".
- Nyob rau hauv lub qhov rais kawg nws yog tau hloov cov hom ntawv ntawm cov ntaub ntawv sau qhia txog:
- Ntau hom;
- Cov ntawv nyeem;
- Hnub tim;
- Hla mus rau sab.
Ntawm no yuav tsum tau teeb tsa, muab qhov xwm txheej ntawm cov txheej txheem ua tiav. Tom qab ntawd, nyem rau ntawm lub pob "Ua li cas".
- Hauv qhov rais nram qab no, peb pom tias cov chaw khiav hauj lwm ntawm phab laug sab sauv ntawm qhov ntau ntawm daim ntawv uas cov ntaub ntawv yuav muab tso rau. Qhov no tuaj yeem ua tau los ntawm kev ntaus ntawv qhov chaw nyob ntawm qhov tsim nyog los yog xaiv los ntawm xaiv lub xov tooj ntawm cov ntawv. Tom qab lub koog ntxiv, nias qhov khawm ntawm thaj chaw ntawm lub qhov rais "OK".
- Tom qab ntawd, cov ntawv nyeem yuav muab tso rau ntawm daim ntawv nyob rau hauv qhov kev xav tau lo lus. Nws tseem raug rau nws los yog muab cov qauv ntawm lub rooj, yog tias nws yog cov ntaub ntawv tabular, vim nws puas lawm thaum nws ua tiav nws.
Txoj kev 3: txuag tau cov ntaub ntawv hauv ib qho kev xaiv
Muaj kuj yog ib qho rov qab thaum cov ntaub ntawv yuav tsum tsis txhob qhib nrog qhov tseeb zaub ntawm cov ntaub ntawv, tab sis tau txais kev cawmdim rau hauv lub teeb encoding. Nyob rau hauv Excel, koj tuaj yeem ua txoj haujlwm no.
- Mus rau lub tab "Cov Ntaub Ntawv". Nias ntawm yam khoom "Tseg Rau".
- Lub qhov rais qhib qhov rais qhib. Siv lub interface Explorer, peb txhais cov directory uas cov ntaub ntawv yuav muab khaws cia. Tom qab ntawd peb teev hom ntaub ntawv yog tias peb xav kom txuag tau phau ntawv hauv ib hom ntawv tsis yog tus qauv Excel (xlsx) hom ntawv. Tom qab ntawd nias rau ntawm qhov ntsuas "Kev pabcuam" thiab nyob rau hauv cov npe uas tau qhib, xaiv qhov khoom "Web Daim Ntawv Qhia".
- Nyob rau hauv lub qhov rais qhib, mus rau tab "Encoding". Hauv teb "Txuag Ntawv Ua" Qhib daim ntawv teev npe cia thiab teev los ntawm daim ntawv teev hom kev encoding uas peb xav tau tsim nyog. Tom qab ntawd, nyem rau ntawm lub pob "OK".
- Peb rov qab mus rau lub qhov rais "Txuag Daim Ntawv" thiab nias rau ntawm lub pob "Txuag".
Cov ntaub ntawv yuav raug cawm rau ntawm daim hard disk los yog tshem tawm tawm hauv txoj kev encoding uas koj txhais koj tus kheej. Tab sis nco ntsoov hais tias tam sim no ib txwm ntawv tau txais kev cawmdim hauv Excel yuav tsum tau txais kev cawmdim hauv no encoding. Yog xav hloov qhov no, koj yuav tsum tawm lub qhov rais dua. "Web Daim Ntawv Qhia" thiab hloov qhov chaw.
Muaj lwm txoj kev los hloov qhov kev xaiv ntawm cov ntawv tau txais kev cawmdim.
- Nyob hauv tab "Cov Ntaub Ntawv", nyem rau ntawm yam khoom "Kev xaiv".
- Lub qhov rais Excel opens. Xaiv sub "Qib Siab" los ntawm daim ntawv teev nyob rau sab laug ntawm lub qhov rais. Lub hauv nruab nrab ntawm lub qhov rais mus rau ntawm qhov chaw nyob "General". Ntawm no peb nias rau ntawm lub pob "Cov Kev Xaiv Sab Kev Kawm".
- Lub qhov rais twb paub peb qhib lawm. "Web Daim Ntawv Qhia"qhov twg peb ua txhua yam tib yam uas peb tau tham txog yav dhau los.
Tam sim no tej ntaub ntawv rua hauv Excel yuav muaj lub caij nyoog encoding uas koj tau ntsia.
Raws li koj tau pom, Excel tsis muaj lub cuab tam uas yuav cia koj mus ceev nrooj thiab yooj yim los hloov cov ntawv nyeem los ntawm ib qho kev tawm tsam rau lwm tus. Cov ntawv xov xwm no tau muaj kev ua haujlwm zoo heev thiab muaj ntau yam nta uas tsis tsim nyog rau txoj haujlwm no. Siv nws, koj yuav tsum mus dhau ob peb kauj ruam uas tsis ncaj qha rau cov txheej txheem no, tab sis ua haujlwm rau lwm yam hom phiaj. Txawm tias kev hloov dua siab tshiab los ntawm ib phau ntawv thib peb editor Editor Notepad ++ zoo li me ntsis yooj yim dua hauv qhov no. Txuag cov ntaub ntawv nyob rau hauv ib qho kev muab encoding hauv Excel kuj nyuab los ntawm qhov tseeb tias txhua zaus koj xav hloov qhov parameter, koj yuav tsum hloov lub ntiaj teb chaw ntawm qhov kev zov me nyuam.
