Yuav ua li cas qhib CSV hauv Excel

CSV cov ntawv sau cov ntawv siv tau siv los ntawm ntau cov khoos phis tawj rau kev sib pauv cov ntaub ntawv ntawm txhua lwm yam. Nws yuav zoo li tias nyob rau hauv expele koj tuaj yeem pib cov ntaub ntawv nrog tus qauv nyem rau ntawm nws nrog sab laug nas, tab sis tsis yog ib txwm nyob rau hauv cov ntaub ntawv no, tab sis tsis yog ib txwm nyob rau hauv cov ntaub ntawv no, tab sis tsis yog ib txwm nyob rau hauv no. Muaj tseeb, muaj lwm txoj hauv kev los saib cov ntaub ntawv muaj nyob hauv CSV cov ntaub ntawv. Cia peb kawm seb nws yuav ua tau li cas.

Qhib CSV cov ntaub ntawv

Lub npe ntawm CSV hom yog cov lus luv ntawm lub npe "comma sib cais muaj nuj nqis", uas tau muab txhais ua lus Lavxias, zoo li "qhov tseem ceeb muab faib los ntawm cov khoom ua tiav". Tseeb, hauv cov ntaub ntawv no, cov lus cog lus yog hais lus, hauv kev sib tham hauv Lavxias, tom qab, nws yog kev cai los siv lub chaw tsis nco qab.

Thaum import rau cov ntaub ntawv CSV mus rau Excel, qhov teeb meem ntawm kev ua si ntawm encoding yog cuam tshuam. Feem ntau, cov ntaub ntawv nyob rau hauv uas Cyrillic tam sim no tau tsim nrog cov ntawv nyeem ntawm kev nplua nuj "Krakoyabram", uas yog, nyeem tsis muaj cov cim. Ib qho ntxiv, qhov teeb meem nquag yog qhov teeb meem ntawm kev sib txuam ntawm separators. Ua ntej tshaj plaws, qhov kev txhawj xeeb no cov xwm txheej uas peb tab tom qhib cov ntaub ntawv ua hauv qee hom kev kawm lus Askiv, excelized hauv qab cov neeg siv Lavxias. Tom qab tag nrho, nyob rau hauv cov code code, tus separator yog comma, thiab Lavxias-hais lus Excel pom qhov taw tes nrog lub comma hauv qhov kev ua tau zoo no. Yog li ntawd, qhov tshwm sim tsis muaj tseeb. Peb yuav qhia yuav ua li cas daws cov teeb meem no thaum qhib cov ntaub ntawv.

Txoj Kev 1: Qhib cov ntaub ntawv ib txwm qhib

Tab sis thaum xub thawj peb yuav tsom rau kev xaiv thaum cov ntaub ntawv CSV yog tsim nyob rau hauv Lavxias-Hais Lus Program thiab twb tau npaj txhij rau kev qhib hauv cov ntsiab lus ntxiv.

Yog tias qhov kev pab cuam Excel tau raug teeb tsa los qhib CSV cov ntaub ntawv hauv koj lub khoos phis tawm, tom qab ntawd nws txaus los nyem rau ntawm ob zaug ntawm sab laug nas khawm, thiab nws yuav qhib hauv Excel. Yog tias qhov kev sib txuas tseem tsis tau tsim, tom qab ntawd nyob rau hauv cov ntaub ntawv no koj yuav tsum tau ua ib tug xov tooj ntawm cov kev tswj hwm ntxiv.

1. Ua nyob rau hauv lub qhov rais Explorer nyob rau hauv cov npe uas cov ntaub ntawv nyob, nyem sab xis nas khawm rau nws. Cov ntsiab lus ntsiab lus teb tau pib. Xaiv cov khoom "qhib nrog kev pab" hauv. Yog tias cov npe ntawm "Microsoft Office" muaj nyob hauv cov npe Advanced, tom qab ntawd nyem rau ntawm nws. Tom qab ntawd, cov ntaub ntawv yuav yooj yim pib hauv koj qhov kev ua piv txwv. Tab sis yog tias koj tsis tshawb xyuas cov khoom no, nyem rau ntawm "Xaiv qhov program" txoj haujlwm.



2. Qhov kev zov me nyuam xaiv qhov rai qhib. Ntawm no, ib zaug ntxiv, yog tias koj yuav pom lub npe "Microsoft Office" hauv "Cov Kev Pab Cuam Pom Zoo" thaiv nws thiab nyem rau ntawm "OK" khawm. Tab sis ua ntej ntawd, yog tias koj xav tau tias CSV cov ntaub ntawv ib txwm qhib thaum lub sijhawm uas "siv cov ntaub ntawv xaiv rau txhua cov ntaub ntawv" sawv kos cim.

   

   Yog tias koj tsis pom lub npe "Microsoft Office" hauv cov phiaj kev xaiv lub qhov rai, tom qab ntawd nyem rau ntawm "OVERVIEnciew ..." khawm.



3. Tom qab ntawd, tus Explorer Windows yuav pib hauv phau ntawv teev npe tso rau ntawm koj lub computer. Raws li txoj cai, daim nplaub tshev no hu ua "cov ntaub ntawv cov kev pabcuam" thiab nws yog nyob ntawm lub hauv paus ntawm C. Koj yuav tsum tau ua kev hloov mus rau tus neeg tshawb nrhiav ntawm qhov chaw nyob hauv qab no:

   C: \ Cov Ntawv Txheej Txheem Ua Haujlwm Microsoft Office \ Chaw ua haujlwm

   Qhov twg, es tsis txhob "lub cim, cov qauv ntawm Microsoft lub chaw ua haujlwm nruab rau ntawm koj lub computer yuav tsum yog nyob ntawm koj lub computer. Raws li txoj cai, xws li ib nplaub tshev yog ib qho, yog li xaiv Chaw Haujlwm Chaw Haujlwm, txawm xij tus lej tsis sawv. Los ntawm kev tsiv mus rau cov npe teev tseg, nrhiav ib daim ntawv hu ua "Excel" lossis "Excel.exe". Qhov thib ob ntawm lub npe yuav nyob rau hauv qhov kev tshwm sim uas koj tau ua rau kev txuas ntxiv hauv Windows Explorer. Tshaj tawm cov ntaub ntawv no thiab nyem rau ntawm "qhib ..." khawm.



4. Tom qab hais tias, Microsoft Excel txoj haujlwm yuav muab ntxiv rau cov kev xaiv lub qhov rai, uas peb tau hais ua ntej. Koj yuav tsum tau ua kom pom lub npe xav tau, ua raws li tus zuam nyob ze ntawm cov khoom siv CSV rau cov ntaub ntawv CSV (yog tias koj tau nyem rau ntawm "OK" khawm.

Tom qab ntawd, cov ntsiab lus ntawm daim ntawv CSV yuav qhib rau hauv excele. Tab sis cov qauv no yog qhov tsim nyog ib leeg yog tias tsis muaj teeb meem nrog txoj cai hauv zos lossis nrog daim phiaj ntawm Cyrillic. Ib qho ntxiv, raws li peb pom, koj yuav tsum ua qee qhov kho ntawm daim ntawv: Txij li cov ntaub ntawv tsis yog nyob rau hauv txhua kis nyob rau hauv lub xovtooj no tam sim no, lawv yuav tsum tau nthuav dav.

Txoj Kev 2: Siv Ntawv Wizard

Koj tuaj yeem tuaj yeem ntshuam cov ntaub ntawv los ntawm CSV hom ntawv sau siv cov cuab yeej txuas ntxiv, uas yog hu ua cov ntawv nyeem wizard.

1. Khiav txoj haujlwm Excel thiab mus rau hauv cov ntaub ntawv tab. Ntawm daim kab xev hauv "tau txais cov ntaub ntawv sab nraud" Toolbar, nyem rau ntawm lub pob, uas yog hu ua "los ntawm cov ntawv nyeem".



2. Cov ntawv sau cov ntawv ntshuam Windows yog tsim tawm. Tsiv mus rau hauv phau ntawv teev npe ntawm qhov chaw nyob ntawm CVS cov ntaub ntawv phiaj. Tshaj tawm nws lub npe thiab nyem rau ntawm "Ntshuam" khawm, nyob rau hauv qab ntawm lub qhov rais.



3. Cov ntawv nyeem wizard tau qhib. Hauv "hom ntaub ntawv" chaw thaiv, hloov yuav tsum tau sawv ntsug hauv "nrog seprators" txoj haujlwm. Txhawm rau kom pom tseeb cov ntsiab lus ntawm cov ntawv xaiv, tshwj xeeb yog tias nws muaj Cyrillic, nco ntsoov tias "Unicode (UTF-8)" tus nqi yog teem rau "cov hom ntawv". Hauv cov ntaub ntawv sib txawv, koj yuav tsum tau nruab nws tus kheej. Tom qab tag nrho cov chaw saum toj no tau teeb tsa, nyem rau ntawm "Tom ntej" khawm.



4. Tom qab ntawd cov ntawv nyeem thib ob Wizard qhov rai qhib. Ntawm no nws yog qhov tseem ceeb heev los txiav txim seb cov cim twg yog ib tug separator hauv koj daim ntawv. Hauv peb cov ntaub ntawv, hauv lub luag haujlwm no muaj ib qho chaw nyob, raws li cov ntaub ntawv yog Lavxias-hais lus thiab ib cheeb tsam rau cov qauv hauv tsev ntawm cov software. Yog li ntawd, nyob rau hauv cov chaw thaiv "lub cim-Separator yog" peb nruab ib tus zuam mus rau "taw tes nrog lub comma" txoj hauj lwm. Tab sis yog tias koj import CVS cov ntaub ntawv uas yog qhov zoo rau cov qauv lus Askiv, thiab cov lus tsis nco qab nyob rau hauv nws yog lub comma, ces koj yuav tsum tau tso ib tus zuam mus rau "txoj haujlwm". Tom qab cov chaw saum toj no yog tsim tawm, nyem rau ntawm "Tom ntej" khawm.



5. Lub qhov rais thib peb ntawm cov ntawv nyeem qhib. Raws li txoj cai, tsis muaj kev coj ua ntxiv tsis tas yuav tsim khoom. Qhov kev zam nkaus xwb, yog tias ib qho ntawm cov ntaub ntawv teeb tsa hauv daim ntawv muaj hnub tim. Hauv qhov no, nws yog ib qho yuav tsum tau khij cov kab no hauv qab ntawm lub qhov rais, thiab tus hloov mus rau hauv "kab ntawv hom ntaub ntawv" thaiv yog teem rau "hnub" txoj hauj lwm. Tab sis nyob rau hauv cov overwhooming feem ntau ntawm cov rooj plaub, lub neej ntawd kev teeb tsa uas "hom ntawv dav dav" yog ntsia. Yog li koj tuaj yeem nyem qhov "ua tiav" hauv qab ntawm lub qhov rais.



6. Tom qab ntawd, ib qho kev sib txawv cov ntaub ntawv txawv cov ntaub ntawv qhib. Nws yuav tsum qhia cov kev ua haujlwm ntawm sab laug ntawm thaj chaw sab sauv hauv cov ntaub ntawv txawv teb chaws yuav nyob. Qhov no tuaj yeem ua tiav los ntawm kev txhim kho tus cursor hauv lub qhov rais thaj chaw, thiab tom qab ntawd nias lub pob laug sab laug ntawm daim ntawv. Tom qab ntawd, nws txoj kev sib koom tes yuav teev nyob hauv daim teb. Koj tuaj yeem ua "OK" khawm.



7. Tom qab qhov no, cov ntsiab lus ntawm CSV cov ntaub ntawv yuav muab tso rau ntawm cov ntawv Excel. Ntxiv mus, raws li peb tuaj yeem pom, nws tau tshwm ntau dua li thaum siv cov txheej txheem 1. tshwj xeeb, ntxiv mus txuas ntxiv ntawm cov hlwb tsis tas yuav.

Zaj Lus Qhia: Yuav ua li cas hloov cov encoding hauv Excel

Txoj Kev 3: Qhib los ntawm cov ntaub ntawv tab

Kuj tseem muaj txoj hauv kev los qhib daim ntawv CSV los ntawm cov ntaub ntawv tab ntawm qhov kev pab cuam Excel.

1. Khiav Excel thiab txav mus rau cov ntaub ntawv tab. Nyem rau ntawm "Qhib" khoom nyob ntawm sab laug ntawm lub qhov rais.



2. Tus neeg xyuas lub qhov rais pib. Nws yuav tsum txav mus rau hauv cov npe no ntawm lub hard disk ntawm PC lossis ntawm cov xov xwm tshem tawm nyob rau hauv uas CSV hom ntawv yog xav nyob rau hauv. Tom qab ntawd, koj yuav tsum rov kho cov ntaub ntawv hloov hauv "txhua cov ntaub ntawv" qhov rai. Tsuas yog nyob rau hauv cov ntaub ntawv no, daim ntawv CSV yuav pom nyob hauv lub qhov rais, raws li nws tsis yog ib qho kev ua ntaub ntawv Excel. Tom qab cov ntaub ntawv npe tso tawm, xaiv nws thiab nyem rau ntawm "Qhib" khawm nyob hauv qab ntawm lub qhov rais.



3. Tom qab ntawd, cov ntawv nyeem wizard yuav pib. Tag nrho cov kev ua tau ua los ntawm tib lub algorithm raws li nyob rau hauv txoj kev 2.

Raws li koj tuaj yeem pom, txawm tias qee cov teeb meem nrog kev qhib cov ntaub ntawv ntawm CSV hom hauv expele, nws tseem muaj peev xwm daws tau lawv. Ua li no, koj yuav tsum tau siv cov cuab yeej Excel, uas yog hu ua ib tug tswv ntawv nyeem. Txawm hais tias, rau ntau kis, nws yog txaus los siv tus qauv txheem ntawm kev qhib cov ntaub ntawv los ntawm ob zaug nyem lub pob laug nas los ntawm nws lub npe.