Cov Ntawv Teev Npe Ntawv CSV siv los ntawm ntau lub computer programs los pauv cov ntaub ntawv ntawm txhua lwm. Nws yuav zoo li nyob rau hauv Excel nws yog tau mus tso xws li cov ntaub ntawv nrog ib tug standard ob nias rau nws nrog cov laug nas khawm, tab sis tsis tas li nyob rau hauv cov ntaub ntawv no cov ntaub ntawv yog tso tawm kom raug. Muaj tseeb, nws muaj lwm txoj hau kev saib cov ntaub ntawv hauv cov ntaub ntawv. CSV. Cia peb saib seb qhov no yuav ua li cas.
Qhib CSV Cov Ntaub Ntawv
Hom ntawv lub npe CSV yog lub npe ntawm lub npe "Txoj kev sib nrauj-Sib cais"uas txhais ua lus Askiv li "vias cais". Tseeb, muaj pesnras yog siv cais hauv cov ntaub ntawv no, tab sis nyob rau hauv Lavxias teb sab versions, tsis zoo li cov lus Askiv, nws yog tseem pheej yig siv lub semicolon.
Thaum importing cov ntaub ntawv CSV Excel yog qhov teeb meem ntawm coding playback. Feem ntau, cov ntaub ntawv uas muaj Cyrillic cov tsiaj ntawv muaj npe nrog cov ntawv nyeem uas muaj tag nrho ntawm "krakozyabrami", uas yog, cov cim tsis muaj cwj pwm. Tsis tas li ntawd, qhov teeb meem tshwm sim yog qhov teeb meem ntawm qhov tsis sib haum xeeb ntawm cov neeg cais tawm. Ua ntej tshaj plaws, nws txhawj txog cov xwm txheej thaum peb sim qhib ib daim ntawv uas tau tsim los ntawm qee hom lus Askiv, Excel, nyob hauv cov neeg siv lus Askiv. Tom qab tag nrho, nyob rau hauv qhov chaws tawm separator yog ib qho kev ua tsis tiav, thiab Lus Askiv hais lus Askiv ua ib lub vib nas this. Yog li ntawd, qhov tshwm sim dua yog tsis muaj tseeb. Peb yuav qhia li cas los daws cov teebmeem no thaum qhib cov ntaub ntawv.
Txoj kev cai 1: Cov Ntaub Ntawv Ceev Ntaub Ntawv
Tab sis ua ntej peb yuav tsom rau qhov variant thaum daim ntawv CSV tsim nyob rau hauv qhov kev pab cuam Lavxias-lus thiab npaj rau kev qhib hauv Excel tsis ntxiv kev tswj ntawm cov ntawv.
Yog tias Excel twb ntsia tau qhib cov ntaub ntawv CSV nyob rau hauv koj lub computer los ntawm kev ua neej, qhov no, cia li nias rau ntawm cov ntaub ntawv los ntawm ob npaug rau sab laug nas khawm, thiab nws yuav qhib hauv Excel. Yog qhov kev txuas tsis tau tsim, ces qhov no yuav tsum tau ua ntau tus ntxiv kev tswj kev ua haujlwm.
- Nyob hauv Qhov rai Explorer nyob rau hauv cov ntaub ntawv uas muaj cov ntaub ntawv nyob hauv, right-click rau nws. Launches lub ntsiab lus teb lus qhia. Xaiv cov khoom hauv nws "Qhib nrog". Yog tias lub npe ntxiv muaj npe "Microsoft Office"ces nias rau qhov ntawd. Tom qab ntawd, daim ntawv yuav pib rau koj daim Excel. Tab sis, yog tias koj tsis pom cov khoom no, ces nias qhov chaw "Xaiv qhov kev pab cuam".
- Qhov kev xaiv xaiv qhov rais qhib opens. Ntawm no, dua, yog tias nyob hauv ib lub block "Cov kev qhia uas pom zoo" koj yuav pom lub npe "Microsoft Office", ces xaiv nws thiab nyem rau ntawm lub pob "OK". Tab sis ua ntej ntawd, yog tias koj xav tau cov ntaub ntawv CSV ib txwm cia li qhib hauv Excel thaum koj ob-nias rau ntawm lub npe qhov program, ces nco ntsoov tias "Siv cov kev xaiv xaiv rau tag nrho cov ntaub ntawv ntawm hom no" muaj ib tug zuam.
Yog hais tias lub npe "Microsoft Office" hauv qhov kev xaiv xaiv qhov rai koj tsis pom, ces nias lub khawm "Ntsuam xyuas ...".
- Tom qab ntawd, lub qhov rais Explorer yuav pib rau hauv phau ntawv qhia tias qhov kev pab cuam ntsia koj lub computer nyob hauv. Feem ntau, qhov kev nplaub tshev no hu ua "Cov Ntaub Ntawv Cov Ntaub Ntawv" thiab nws yog nyob rau hauv lub hauv paus ntawm lub disk C. Koj yuav tsum mus rau qhov Explorer ntawm qhov chaw nyob hauv qab no:
C: Cov ntaub ntawv Microsoft Office OfficeQhov twg es tsis yog lub cim "№" yuav tsum muaj tus naj npawb ntawm Microsoft Office suite nruab rau hauv koj lub computer. Feem ntau, daim nplaub tshev no yog ib qho, yog li xaiv ib phau ntawv Chaw ua haujlwmtxawm muaj pes tsawg tus muaj. Tom qab koj tsiv mus rau qhov directory uas tau teev tseg, nrhiav cov ntaub ntawv hu ua "HNAV" los yog "EXCEL.EXE". Daim ntawv thib ob ntawm lub npe yuav yog tias koj muaj qhov txuas txuas ntxiv nrog rau Qhov rai Explorer. Xaiv cov ntaub ntawv no thiab nyem rau ntawm lub pob. "Qhib ...".
- Tom qab qhov kev kawm no "Microsoft Excel" Nws yuav muab ntxiv rau qhov kev xaiv xaiv qhov rais, uas peb tau tham txog yav dhau los. Koj tsuas yog yuav tsum tau qhia lub npe yam xav tau, los xyuas qhov muaj qhov kos cim ntawm qhov txuas mus rau cov ntaub ntawv hom (yog tias koj xav kom qhib cov ntaub ntawv tas li CSV hauv Excel) thiab nias lub pob "OK".
Tom qab ntawd, cov ntsiab lus ntawm daim ntawv CSV yuav qhib rau hauv Excel. Tab sis qhov no yog tsim rau yog tias tsis muaj teeb meem nrog qhov chaw los sis nrog cov Cyrillic. Ntxiv mus, raws li peb pom, nws yuav tsum tau ua qee yam editing ntawm daim ntawv: vim cov ntaub ntawv tsis nyob rau hauv tag nrho cov rooj sib haum rau hauv lub xov tooj ntawm lub cev tam sim no, lawv yuav tsum tau txhab.
Txoj kev 2: Siv cov ntawv Wizard
Koj tuaj yeem ntshuam ntaub ntawv los ntawm CSV daim ntawv uas siv cov cuab yeej Excel built-in Cov Ntawv Teev Tseg.
- Khiav lub Excel program thiab mus rau tab "Cov ntaub ntawv". Rau daim kab xev hauv lub nras cov cuab yeej "Qhia lwm cov ntaub ntawv" peb nias qhov khawm, uas hu ua "Los ntawm cov ntawv nyeem".
- Daim pib ntshuam ntawv qhov rais qhib pib. Tsiv mus rau cov ntaub ntawv qhov chaw teev npe CVS. Xaiv lub npe thiab nyem rau ntawm lub pob. "Ntshuam"muab tso rau hauv qab ntawm qhov rais.
- Kaw lub qhov rais Cov Ntawv Wizards. Nyob hauv lub thawv ntawv "Hom ntaub ntawv" tus tes hloov yuav tsum nyob rau hauv txoj hauj lwm "Delimited". Txhawm rau xyuas kom meej tias cov ntsiab lus ntawm cov ntaub ntawv xaiv tau muab tso tawm kom raug, tshwj xeeb tshaj yog yog hais tias nws muaj Cyrillic, thov nco ntsoov tias hauv "Ua Ntawv Thov" twb teem caij mus "Unicode (UTF-8)". Txwv tsis pub, koj yuav tsum nruab nws manually. Tom qab tag nrho cov nqis saum toj no tau teev, nias ntawm lub pob "Tom ntej".
- Tom qab ntawd qhib lub qhov rais thib ob. Cov Ntawv Wizards. Ntawm no nws yog ib qho tseem ceeb heev los txiav txim siab uas yog tus cwj pwm hauv cov ntawv hauv koj daim ntawv. Nyob rau hauv peb cov ntaub ntawv, lub semicolon tshwm nyob rau hauv no lub luag hauj lwm, txij li thaum cov ntaub ntawv yog Lavxias-lus thiab yog localised tshwj xeeb rau cov software versions domestic. Vim li no, nyob rau hauv qhov chaw thaiv "Tus cwj pwm tsis zoo yog" peb muab tus zuam hauv txoj haujlwm "Semicolon". Tab sis yog tias koj tuaj yeem xa cov ntaub ntawv CVS, uas yog qhov zoo rau cov qauv lus Askiv, thiab ib qho kev ua ib qho raws li lub sijhawm, ces koj yuav tsum khij lub npov "Ntsuag". Tom qab teeb tsa saum toj no, nyem rau ntawm lub pob "Tom ntej".
- Qhov thib peb qhov rais qhib. Cov Ntawv Wizards. Raws li txoj cai, tsis tas ua dab tsi ntxiv. Qhov kev zam tsuas yog yog ib qho ntawm cov ntawv teev lus teev nyob rau hauv daim ntawv muaj ib hnub hom. Hauv qhov no, nws yuav tsum khij lub tsho no rau sab qis ntawm lub qhov rais, thiab qhov hloov ntawm qhov thaiv "Daim Ntawv Qhia Kem" teem caij rau txoj haujlwm "Hnub". Tab sis feem ntau, lub neej ntawd yog qhov txaus, uas yog hom ntawv teeb "General". Yog li koj tsuas yog nias lub pob. "Ua li cas" nyob hauv qab ntawm qhov rais.
- Tom qab qhov no, cov ntaub ntawv ntshuam me me opens. Nws yuav tsum tau qhia txog cov koog ntawm sab laug sab ntawm lub cheeb tsam uas cov ntaub ntawv xa tawm tuaj. Qhov no yuav ua tau los ntawm qhov muab tus cursor hauv lub tshav pob ntawm lub qhov rais, thiab tom qab txhaj tus nas laug khawm ntawm lub xovtooj ntawm daim ntawv. Tom qab ntawd, nws cov hauj lwm yuav muab ntaus rau hauv thaj av. Koj tuaj yeem nias lub khawm "OK".
- Tom qab cov ntaub ntawv no CSV yuav muab luam tawm mus rau ib daim ntawv zoo. Thiab, raws li peb tau pom, nws tshwm tawm ntau dua thaum siv Txoj Cai 1. Hauv particular, tsis muaj kev nthuav dav ntxiv ntawm qhov ntau thiab tsawg ntawm tes yog yuav tsum tau ua.
Tshooj: Yuav ua li cas hloov lub encoding hauv Excel
Method 3: qhib los ntawm "Cov Ntaub Ntawv" tab
Kuj tseem muaj ib txoj hauv kev qhib ib daim ntawv. CSV los ntawm lub tab "Cov Ntaub Ntawv" Excel cov kev pab cuam.
- Tua Excel thiab taw rau lub tab "Cov Ntaub Ntawv". Nias ntawm yam khoom "Qhib"nyob rau sab laug ntawm lub qhov rais.
- Qhov rais pib Tus cwjpwm. Koj yuav tsum tsiv mus nyob rau hauv phau ntawv ntawd ntawm PC Hard disk los yog tawm hauv xov tawm, uas yog hom ntawv koj xav tau yog nyob CSV. Tom qab ntawd, koj yuav tsum hloov cov ntaub ntawv hloov nyob rau hauv lub qhov rais mus rau txoj haujlwm "Txhua Ntaub Ntawv". Tsuas yog nyob rau hauv cov ntaub ntawv no CSV yuav tsum tau qhia nyob rau hauv lub qhov rais vim nws tsis yog cov ntaub ntawv raug coj los siv. Tom qab lub npe ntawm daim ntawv tso tawm, xaiv nws thiab nyem rau ntawm lub pob "Qhib" nyob hauv qab ntawm qhov rais.
- Tom qab ntawd, lub qhov rais yuav pib. Cov Ntawv Wizards. Txhua yam kev ua ntxiv yog ua los ntawm tib lub algorithm raws li nyob rau hauv Txoj kev 2.
Raws li peb tau pom, txawm tias qee qhov teeb meem nrog qhib cov ntaub ntawv CSV hauv Excel, lawv tseem muaj peev xwm daws tau. Ua li no, siv cov cuab yeej Excel built-in, uas yog hu ua Cov Ntawv Teev Tseg. Txawm hais tias, rau ntau tus neeg, nws yog txaus txaus siv tus txheej txheem ntawm kev qhib ib daim ntawv los ntawm ob npaug rau sab laug nas khawm ntawm nws lub npe.
